sql server full text search: Searching a string in image datatype column -- sql server full text search

Searching a string in image datatype column

jefftim NO[at]SPAM gmail.com
3/1/2007 6:22:26 AM

sql server full text search: Hi all

I'm saving doc,txt,rtf,msg and pdf files in binary format in image
datatype column in sql server 2000.
I've created fulltext indexing on the table. i'm able to search a
string from the column if the file is of doc,rtf or txt.But the
search
is not conducted if the file is pdf or msg.
So if anyone has any solution for the above try to help me as early
as
possible.

Regards

Jeff

Re: Searching a string in image datatype column

Hilary Cotter
3/1/2007 12:34:01 PM

you need to install the adobe ifilter and a msg ifilter. Ifiltershop.com has
a msg ifilter.

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]