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...
FileData contains the PDF BLOB. The search word is 'Mortgage'
CONTAINSTABLE ([Compliance_Updates],([FileDesc], [FileData]), 'ISABOUT( FORMSOF (INFLECTIONAL, Mortgage) WEIGHT(0.9))',language 'English') AS res