是否可以在SQL Server 2008中的加密列上使用全文本搜索 [英] Is it possible to use full text search on encrypted column in SQL Server 2008

问题描述

我有一列，使用数据库中的对称密钥进行加密.加密的内容只是文本.我想使用全文搜索查询此文本.是否有可能? 我正在考虑使用全文搜索过滤器索引一列，但未找到任何现成的过滤器. 那么是否有可能开发这样的过滤器，特别是是否有可能从过滤器代码访问存储在数据库中的加密密钥并解密列中的文本? 您能推荐任何教程，如何开始这样的开发吗?

I have a column, that is encrypted using symmetric key in a database. An encrypted content is just a text. I would like to query this text using full text search. Is it possible? I was thinking about using full text search filters to index a column, but didn't find any ready-to-use filter. So is it possible to develop such a filter, in particular, is it possible to access encryption key, that is stored in a database, from filter code and decrypt the text from the column? Could you recommend any tutorial, how to start with such a development?

推荐答案

据我了解，不支持加密索引.您基本上有两个选择:

From what I understand, there is no support for encrypted indexes. You basically have two options:

1. 您可以清楚地索引部分数据(不加密)，并将部分数据与完全加密的数据进行匹配.
2. 在搜索之前解密数据

尽管这篇文章适用于SQL Server 2005，适用于SQL Server 2008.

Although this post was for SQL Server 2005, it remains true for SQL Server 2008.

这篇关于是否可以在SQL Server 2008中的加密列上使用全文本搜索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！