On Thu, 2005-05-05 at 10:38 -0700, Dong Xuezhang-A19583 wrote: > I understand that I got to encrypt and decrypt it, but what happened > for the indexed column? If I have a collate column at Chinese PINYIN, > after you encrypt it, the sorting method will be broken, so is there > any encrypt algorithm donot loose sorting sequence? Or collate and > encrypt need to have some logic to tight together. >
With the encryption extension, all of that is taken care of automatically. You just have to supply the decrypt key when you open the database file and SQLite takes care of all the details for you. -- D. Richard Hipp <[EMAIL PROTECTED]>