In theory, ( have not tried this with SQLite) you caould make 2 add-in
functions, encrypt(str) and decript(str) then use it as such:
Select decrypt(sensitive_column) from table where id=3;
Insert into table (sensitive_column) values (encrypt('3434 3434 3434
3434'))
To provide field-level encryption.
> -----Original Message-----
> From: EzTools Support [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 09, 2004 5:12 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [sqlite] Encrypting data stored in database
>
> Joey,
>
> Where in the code did you do that? Was it easy to put in one or two
> places?
>
> -brett
>
> try IeToolbox Passwords & Notes Keeper, Form Filler and much more
> www.ietoolbox.com
>
>
>
> Joey Blankenship wrote:
>
> > Not to respond out of turn here, but we had a need to obfuscate the
> > plain text (due to some users that are a little too curious for
their
> > own good) that was stored but did not want the performance burden
that
> > encryption/decryption would place on the PocketPC. Prior to writing
> > and subsequent to reading, we just perform a simple mangle of the
> > read/written data. A byte NOT or XOR works pretty well and does not
> > cause an extreme performance hit. Again, no real encryption, but it
> > hides the data from casual viewing.
> >
> > Joey.
> >
> > At 05:34 AM 9/9/2004, you wrote:
> >
> >> Hello sqlite users,
> >> Hello Dr. Hipp,
> >>
> >> I would like to know if there is a way to encrpyt the data stored
in
> >> the database but to still be able to use SQL queries with plain
text,
> >> something like
> >>
> >> CREATE TABLE TEST (fld)
> >> INSERT INTO Test VALUES ('some string')
> >> SELECT * FROM Test WHERE fld = 'some string'
> >>
> >> but, when the sqlite database is opened in a file viewer, 'some
> >> string' would not be visible but only it's encrypted form.
> >>
> >> Regards,
> >> George Ionescu
> >
> >
> >
>
__________________________________________________________________________________________
This electronic message may contain proprietary and confidential information of Verint
Systems Inc., its affiliates and/or subsidiaries.
The information is intended to be for the use of the individual(s) or
entity(ies) named above. If you are not the intended recipient (or authorized to
receive this e-mail for the intended recipient), you may not use, copy, disclose or
distribute to anyone this message or any information contained in this message. If
you have received this electronic message in error, please notify us by replying to
this e-mail. (1)
