> Has anyone ever needed to encrypt sqlite data on a record by record > basis? I'm a little stumped about this issue mainly because any search > using a reasonably securely encrypted record (such as with AES) would be > futile because it's encrypted differently even with the same passwords > being used.
You could maintain the data twice. One column encrypted, one column hashed (md5, sha etc). If you need the data, use the encrypted column, if you need to search, use the hashed column. -- Richard Heyes http://www.v-webmail.co.uk --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
