Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-06-09 : 08:30:23
|
| Marie writes "I have a table in my DB which has a blobdata field, the image data stored in that table comes from different parts of the application, some from ms word, some html, xml, txt, etc.I can retrieve and display the text file with no problem because they are not compressed, but the doc, html and xml are compressed and I cannot display them. they are using LZ77 compression. and I have downloaded a decompression c program from the web, but the output of that is not readable either. I have also used textcopy to output to a word doc file, that prompts me for how do I want to convert this data, if I select US ASCII, I get this: ‹I need help please, I have looked all over the web. the purpose of retrieving this data is to include it in crime analysis reports.thanks" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-06-11 : 10:18:40
|
| I guess you have to create a file from the data stored. Run the decompression c app on it then return the output file from that?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
|
|
blob data