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
2005 12:59 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] Follow up question about security > > > I have a follow up question about this too. In case I did > password protection, does it encrypt the data, what happened > if somebody use HEX reader to read the orig

[sqlite] Follow up question about security

2005-05-05 Thread Dong Xuezhang-A19583
I have a follow up question about this too. In case I did password protection, does it encrypt the data, what happened if somebody use HEX reader to read the original database file? If we encrypt the whole database, then sorting (specially COLLATE sorting) will have trouble, how to deal with t