Hi,

I have created an FT index on a VARBINARY(MAX) column that stores BLOBs of PDFs.

I have installed the Adobe iFilter DLL for enabling FT searches on PDF BLOBs

However, when I perform a search with a word I know exists in the PDF docs, no results are returned.

Any ideas what I'm doing wrong?

Here is the query...

Code:
SELECT [FileID],[FileDesc],[PubDate]
FROM Compliance_Updates
INNER JOIN 
CONTAINSTABLE ([Compliance_Updates],([FileDesc], [FileData]), 'ISABOUT( FORMSOF (INFLECTIONAL, Mortgage) WEIGHT(0.9))',language 'English') AS res
ON res.[key]=[FileID]
FileData contains the PDF BLOB. The search word is 'Mortgage'

Thanks,
1DMF