0

I was creating an application in which we have to store files in data base. So i have chosen varbinary for it. Now we need to configure Full Text Search on this column.

But I am able to understand how varbinary data type will handle FTS. Because FTS works on text data type.

Cœur
  • 37,241
  • 25
  • 195
  • 267
S.P Singh
  • 1,267
  • 3
  • 17
  • 23

1 Answers1

3

Check this document and this document in MSDN

To create a full-text index on a varbinary(max) column, the Full-Text Engine needs access to the file extensions of the documents in the varbinary(max) column. This information must be stored in a table column, called a type column, that must be associated with the varbinary(max) column in the full-text index. When indexing a document, the Full-Text Engine uses the file extension in the type column to identify which filter to use.

Naruil
  • 2,300
  • 11
  • 15