RE: [sqlite] Follow up question about security

2005-05-05 Thread D. Richard Hipp
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 algorith

Re: [sqlite] Follow up question about security

2005-05-05 Thread Jay Sprenkle
On 5/5/05, Dong Xuezhang-A19583 <[EMAIL PROTECTED]> 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

RE: [sqlite] Follow up question about security

2005-05-05 Thread Dong Xuezhang-A19583
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 conce

Re: [sqlite] Follow up question about security

2005-05-05 Thread Jay Sprenkle
> >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 re

RE: [sqlite] Follow up question about security

2005-05-05 Thread Thomas Briggs
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. > -Original Message- > From: Dong Xuezhang-A19583 [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 05, 2005 12:59 PM > To: s