How to read a “tCompressedString(varbinary(max))” fieldvalue from a SharePoint content database

this blog helped me to find the solution:

http://blog.cloudsiders.com/2010/02/sharepoint-2007-vs-2010-how-do-my-list-content-types-policies-customxsn-look-like/comment-page-1/#comment-59

a snippet from my code:

using System.IO.Compression;
…
SqlBytes bytes = sqlDataReader.GetSqlBytes(sqlDataReader.GetOrdinal(“xmlFields”));
Stream stream = bytes.Stream;
for (int i = 0; i < 14; i++)
                stream.ReadByte();
DeflateStream deflateStream = new DeflateStream(stream, CompressionMode.Decompress, true);
StreamReader reader = new StreamReader(deflateStream);
string fields = reader.ReadToEnd();

Advertisements