Is this possible to search a encrypted data?

net framework to do encrypted the data, and store in the database. But I would like to query the encrypted data, except from decryption the data one by one. Is this possible to query the encrypted data? Thanks.

P.S. I use the Framework.Security.TripleDES class for encryption, and using MSSQL database. Thanks.

Answers


By definition NO. If your encrypted data is searchable, the encryption is broken. You must use a different, random, IV for each item encrypted and the only way to search is to decrypt every item and compare it with the searched item. Which is prohibitive. What you can do is store also a hash of the data and search the hash, see Indexing Encrypted Data. This allows you to quickly do extact searched, but no partial searched nor range searches.


If you use the same IV to encrypt each record, you can do simple searches by encrypting the searched string and comparing with stored data. However, if you need more complicated searches, you are out of luck unless you reconsider the architecture of your application.


Need Your Help

Update, Insert to sql .. There is already an open DataReader associated with

c# asp.net sql

string[] stringList2 = new string[10]; if (VaildDataRow == true) { //Response.Write("<script>alert('2valid data row" + TbRow + "')</script>"); TbCol = 0; TcCol...

Syntax Error (?) on jQuery-ui Tabs: Mismatching Fragment Identifier

jquery jquery-ui jquery-ui-tabs

I'm trying to create a jquery-ui tabs box, and I'm getting a "Mismatching Fragment Identifier" error. I know that means that the href address in the /li/ elements is not matching the id in the /div/

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.