Home Forums SQL Server 7,2000 General help with full text search on column saved as image data type RE: help with full text search on column saved as image data type

  • 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. Visit here[/url] for more information.