I've set up a full-text index on my SQL Server DB on a varbinary(max)
column. I have a type column specified, which contains the extension of the file, such a ".doc", ".pdf" etc.
However, I have noticed that when any .rtf files are indexed, SQL is including all of the meta information in the file (such as the RTF tag "listoverridecount0").
This is bloating the indexes quite a bit, and also means that searches will match on these tags (i.e. I can search on "listoverridecount0" and get EVERY .rtf returned).
Is there any reason that the iFilter for .rtf would not be removing the RTF Tags?
When I run this:
SELECT * FROM sys.fulltext_document_types WHERE document_type = '.rtf';
I get this:
document_type .rtf
class_id C7310720-AC80-11D1-8DF3-00C04FB6EF4F
path c:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\msfte.dll
version 12.0.6828.0
manufacturer Microsoft Corporation
I have filed a Microsoft Connect bug as I don't seem to be able to find any workaround. Presumably this is either a) Error with the RTF iFilter not removing tags, or b) Full Text index issue.
My SQL Server version is:
Microsoft SQL Server 2012 (SP1) - 11.0.3393.0 (X64) Oct 25 2013 19:04:40 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.2 (Build 9200: ) (Hypervisor)