I have a table with HTML data, that I want to search with Full Text Index via an html-filter
So I created an index:
CREATE FULLTEXT CATALOG myCatalog AS DEFAULT CREATE FULLTEXT INDEX ON myTable (Body TYPE COLUMN Filetype) KEY INDEX PK_myTable
Body is a varbinary(max) column with HTML. The Filetype column is a computed column always returns ".html".
No results are being returned.
I verified that .html filter is installed. FullText index is also installed properly and works fine if I convert the column to nvarchar and create just a "plain text" index (not html).
No errors in the SQL log or FTS log.
The keywords table is just empty!
SELECT * FROM sys.dm_fts_index_keywords(DB_ID('myDatabase'), OBJECT_ID('myTable'))
All it returns is "END OF FILE" symbol.
It says "document count 35" which mean the documents were processed, but no keywords were extracted.
PS. I have SQL Server Express Edition 2012. Asked my coworker to test this on SQL Express 2016 - same result... Tried on our 2016 developer edition - same result! All different machines. What am I doing wrong?