June 8, 2005 at 1:08 pm
I have a table which has blob data. this table stores text, doc, htlm, xml and jpg (mugshots and tatoos) etc. I need to retrieve the text from doc and html file back into a readable text format. the problem is that this file has somehow been compressed using LZ77 and is displaying raw data. the text files are no problem as it is not compressed. How do I get back the data from doc and html files? into a text file that is readable.
thanks
June 9, 2005 at 6:39 pm
SQLServer won't be helping you with the decompression - what client side development environment are you using for this? Is there another column in the table which lets you know the type of data stored?
You could, if you have a standard WinRAR/WinZIP which can process your LZ77 compression, use the textcopy command from a DOS box to rip out the BLOB data to a file on the disk on a row-by-row basis. I have used this before in conjunction with a simple query to build up the list of textcopy commands to export the data - one command per row.
June 10, 2005 at 12:16 am
LIke Ian said, SQL Server only "stores" such data, but doesn't provide build-in functions to interpret them. That's the job of your client app. You might find some useful additional information about BLOBs in genereal here:
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply