compression deflate

[Analizer1]

i would like to store the compressed stream in a table
is there a way to convert the compressed stream to
a string or someother storeable data type


thanks

 

[Peter Bromberg [C# MVP]]

Just read all the bytes in the stream into a byte array and store it in a
column of type Image.
-- Peter
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short Urls & more: http://ittyurl.net

 

[Marc Gravell]

You ideally need to handle this as a BLOB; here are some older
examples talking to SQL2000 (image) - but I have (in recent memory)
posted updates (somewhere) with SQL2005 and varbinary(max).

stream=>database
http://groups.google.co.uk/group/microsoft.public.dotnet.languages.csharp/msg/314e7e3782e59a93

database=>stream
http://groups.google.co.uk/group/microsoft.public.dotnet.languages.csharp/msg/fcd173f1db2951f1

Marc

 

[Analizer1]

from what ive worked with
write() compresses
read() un-compresses

i tried to read the compressed bytes but fails
says Not supported
I dont have the exact error availble right now