Re: Searchable/Sortable Encrypted Fields in MySQL?

2005-07-13 Thread Gleb Paharenko
Hello. Where are you going to store the key? You could use subqueries for manipulations with encrypted data. Here is the example, however, you should turn of binary logging, because insert statements are being stored with key. create table pwd(id int auto_increment, pass char(100),

Searchable/Sortable Encrypted Fields in MySQL?

2005-07-12 Thread Matt McNeil
I need to securely store lots of sensitive contact information and notes in a (MySQL or other freely available) database that will be stored on a database server which I do not have direct access to. This database will be accessed by a PHP application that I am developing. However, I also

Re: Searchable/Sortable Encrypted Fields in MySQL?

2005-07-12 Thread mos
At 04:16 PM 7/12/2005, Matt McNeil wrote: I need to securely store lots of sensitive contact information and notes in a (MySQL or other freely available) database that will be stored on a database server which I do not have direct access to. This database will be accessed by a PHP application