Re: store encrypted data in sqlite ?

2009-10-02 Thread Carsten Haese
Stef Mientki wrote: > hello, > > I want to store some fields in an sqlite database. > > I use ezPyCrypto to encrypt and decrypt: > > User = ['z684684', 'Mientki, Stef', 1,1,0,1,1 ] > > encryption_key_1 = ezPyCrypto.key ( 512 ) > > SQL_Base = 'insert or replace into __USERS__ values (' > for fi

Re: store encrypted data in sqlite ?

2009-10-02 Thread Jonathan Gardner
On Oct 2, 11:53 am, Stef Mientki wrote: > > Will this method work always ? > Are there better methods ? > I SQLite doesn't like raw data (with all its \0 glory), you're out of luck, unfortunately. Base64 encoding is a really good solution for places like this. You are aware, of course, of the da

store encrypted data in sqlite ?

2009-10-02 Thread Stef Mientki
hello, I want to store some fields in an sqlite database. I use ezPyCrypto to encrypt and decrypt: User = ['z684684', 'Mientki, Stef', 1,1,0,1,1 ] encryption_key_1 = ezPyCrypto.key ( 512 ) SQL_Base = 'insert or replace into __USERS__ values (' for field in User : SQL += ",'" + encryption_k