全文搜索如何处理二进制数据类型(如varbinary和image) [英] How does Full Text Search works with binary data types (such as varbinary and image)
问题描述
我正在创建一个应用程序,我们必须将文件存储在数据库中。所以我为它选择了 varbinary 。现在,我们需要在此列上配置全文搜索。
但我能够理解 varbinary 数据类型将处理FTS。由于 FTS适用于文本数据类型。 解决方案
要在varbinary(max)列上创建全文索引,全文引擎需要访问varbinary(max)列中文档的文件扩展名。此信息必须存储在称为类型列的表列中,该列必须与全文索引中的varbinary(max)列关联。索引文档时,全文引擎使用类型列中的文件扩展名来标识要使用的过滤器。
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.
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.
这篇关于全文搜索如何处理二进制数据类型(如varbinary和image)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!