On Mar 11, 2006, at 8:52 AM, Ian Piper wrote:
On 11 Mar 2006, at 4:39 pm, Björn Eiríksson wrote:
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.
And a lot of SQL would not be useful.
I'd suspect that a where clause that uses "like" is not useful any more
_______________________________________________
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>
