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.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Full Text Search - image file

Author  Topic 

thakur_amit
Starting Member

6 Posts

Posted - 2010-03-29 : 12:03:58
Hi,

I am using SQL Server 2008 and Full Text search.

Its working fine for PDF / doc files but not working for .JPG files.

Basically i have some document scanned and stored it in varbinnary datatype in DB.

I am able to search for .doc /.xml /.pdf files .. but not able to search .jpg.

also i am not getting ".jgp" extension in result of following query


SELECT document_type, version, manufacturer
FROM sys.fulltext_document_types order by document_type



Please suggest, how to do it
   

- Advertisement -