Full text index not created on varbinary(max)

Full text index not created on varbinary(max) - sql 2008

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sameeksha - 15 Jul 2008 14:05 GMT

Hi

Full text query on varbinary(max) column is not returning results, as the
index is not populated.
Some configuration error - can't figure out what.
FDHost process has no issues

The log shows this - Informational: Full-text Auto population completed for
table or indexed view '<name>' (table or indexed view ID '<id>', database ID
'<id>'). Number of documents processed: 0. Number of documents failed: 0.
Number of documents that were retried: 0.

Any insights into this issue?

Signature

Thanks,
Sameeksha
MCAD.Net

Reply to this Message

Russell Fields - 15 Jul 2008 23:06 GMT

Sameeksha,

Since this is varbinary(max) I do not believe that the standard text parser
will work on it.

Have you made sure that the document extension is stored in an additional
column (referred to as a document type column), and that your full-text
index is configured to use this document type column? If so, then you would
have values like doc for Word documents, xls for Excel Spreadsheets, pdf for
PDFs, and so on.

Also, you need iFilters for some datatypes that are not natively supported
by SQL Server. For example, Adobe has an iFilter for PDFs.

RLF

> Hi
>
[quoted text clipped - 11 lines]
>
> Any insights into this issue?

Reply to this Message