April 25, 2008 at 5:06 am
Hi guys,
i use a table with a varbinary(max) column "myfile" .
The content of the column is a MS-Woddocument.
It is possible to select the content of the worddocument?
Like this:
Select myfile from Table
--> but the result is only 0xd.....
The result shoul be the content of the document.
regards martin
April 25, 2008 at 9:09 am
Since it's binary, it won't have the contents in there in a selectable format. (At least, I'm pretty sure it doesn't.)
SQL 2008 is supposed to be able to deal with that kind of thing more effectively.
I think the usual solution right now is store the word document as a binary, and store the contents as varchar(max). Then use full text indexing on the contents.
BCP can re-create the file from the binary. There might be a way to build a front end that can read the contents from that, but I'm not sure.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply