Using full-text index to search BLOB columns

[1DMF]

Hi,

I have set up SQL to store PDF BLOBs.

I have created a full-text index for the VARBINARY column storing the BLOB.

I have installed the Adobe iFilter for searching PDF BLOBs with full-text index.

However, when I run the following query...

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]

I don't get any results?

I know the PDF BLOB contains the word 'Mortgage', so why don't I get any results?

You help is appreciated.

1DMF.

"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Free Electronic Dance Music

 

[1DMF]

Well I've tried deleting the catalogue, removing all the table records and indexes (including PK), re-running the iFilter install

exec sp_fulltext_service 'load_os_resources', 1;
exec sp_fulltext_service 'verify_signature', 0;

Restarting SQL Server, re-created the indexes and FT catalogue, nothing seems to work?

I've even resaved the PDF including an embedded index, and re-imported the BLOB into the DB, but using this search...

SELECT FileID, FileDesc, PubDate 
FROM Compliance_Updates 
WHERE CONTAINS(FileData, 'mortgage')

... I get zero results.

Your help is appreciated.

1DMF.

"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Free Electronic Dance Music