October 31st, 2013, 05:21 AM
Full-Text index search of PDF BLOB
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...
CONTAINSTABLE ([Compliance_Updates],([FileDesc], [FileData]), 'ISABOUT( FORMSOF (INFLECTIONAL, Mortgage) WEIGHT(0.9))',language 'English') AS res
FileData contains the PDF BLOB. The search word is 'Mortgage'