I've got a database with full-text search enabled. Within that database, I have a table with two columns that are being indexed.
One column is a VARBINARY(MAX) table, and is storing the content of documents of various types. The full-text index on that table references that column, as well as another column with the file type of the document being stored.
The other column is an NVARCHAR(MAX) column, storing the plain text contained within the document, parsed using various parsers, in the event that the document doesn't contain xml-formatted content. This is specifically done for PDFs.
The problem that I'm having is that, for some reason, the NVARCHAR(MAX) column isn't being indexed by the full-text engine. When using the query
SELECT * FROM
The only records which show up in the catalog are those from the VARBINARY(MAX) column. There are no keywords obtained from the content of the NVARCHAR(MAX) column.
I've tried rebuilding the catalog many times, I've even tried dropping the index on the table and re-creating it. Nothing seems to make the database index that column.
Any ideas as to why this isn't working? Any information that I could provide to help? Here's the code I used to create the full-text index on that table:
CREATE FULLTEXT INDEX ON [dbo].[Table] KEY INDEX [PK] ON ([Catalog]) WITH (CHANGE_TRACKING AUTO)
ALTER FULLTEXT INDEX ON [dbo].[Table] ADD ([NVARCHARMAXColumn] LANGUAGE [English])
ALTER FULLTEXT INDEX ON [dbo].[Table] ADD ([VARBINARYMAXColumn] TYPE COLUMN [FileTypeColumn] LANGUAGE [English])
ALTER FULLTEXT INDEX ON [dbo].[Table] ENABLE