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.
Regards. Xuezhang. -----Original Message----- From: Jay Sprenkle [mailto:[EMAIL PROTECTED] Sent: Thursday, May 05, 2005 10:29 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Follow up question about security > > SQLite doesn't have any concept of users, permissions, etc., at > least not as far as I'm aware, though there is an encrypted-database > option available, I believe. > Unless you can restrict access to the database file you have to encrypt your data when you store it, and decrypt it on retrieval. There is a package to do that but I believe you must purchase that version. It might be a worthwhile option.
