On 11 Mar 2006, at 4:39 pm, Björn Eiríksson wrote:
On 11.3.2006, at 16:36, Trausti Thor Johannsson wrote:
if you do that, then the database is un-crypted while the app is
in use, so, just run your app, and then open the database with
some kind of viewer.
Much better is to encrypt all info inside the database, each
field, read it in, de-crypt it for use, then discard the variable.
Never leave the database de-crypted.
If all the info inside is encrypted then does SELECT work correctly
to search for data ?
It works OK for "select columnx, columny... from table_name where
columnz ="nnn"
provided that columnz is unencrypted. Given that you have designed
the database yourself you can make the "nnn" data in columnz fairly
innocent data and you know from the design what is in the other
fields. It makes for some awkward array management in memory and you
must remember to dispose of these structures when you are done with
them (regardless of any garbage collection!) but it works OK.
Ian.
--
Dr Ian M Piper
[EMAIL PROTECTED]
skype: ianmpiper
--
Where is the wisdom we have lost in knowledge?
Where is the knowledge we have lost in information?
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
