Searching Binary data from sql server 2005

[renjucool]

hi,

i am working electronic document management system store documents word excel adobe in database in binary format in sql server 2005.
i want to search the contents from the binary data.I am storing word documents in binary format in sql server table...how to search the contents inside the word document.What will b the search query

Renjur
Kochi

[Motoma]

hi,

i am working electronic document management system store documents word excel adobe in database in binary format in sql server 2005.
i want to search the contents from the binary data.I am storing word documents in binary format in sql server table...how to search the contents inside the word document.What will b the search query

Renjur
Kochi

I do not know much about the Word document format, but I believe PDFs contain zipped XML.You should probably look up the .doc format and figure out how the data is stored to see if it is viable to search the binary data. A better bet would be to store keywords and phrases in the database as well, and perform searches on those, mapping back to the original documents.

[dadvir]

hi,

i am working electronic document management system store documents word excel adobe in database in binary format in sql server 2005.
i want to search the contents from the binary data.I am storing word documents in binary format in sql server table...how to search the contents inside the word document.What will b the search query

Renjur
Kochi

Have you managed to solve this? please let me know.

[renjucool]

Have you managed to solve this? please let me know.

I solved it my using SQL SERVER FULL TEXT SEARCH METHOD and using ifilters....can search any type of documents contents