Ann Harrison wrote:

> Seconding what Roman said, application level encryption disables
> almost all of SQL except for equality matches,

...and with the use of a random IV, even equality matches would be
disabled. Which is probably good if you suspect that people may
be prying inside your database. (Imagine a table with secret
addresses and phone numbers. ECB field-level encryption, whether
by the app or by the engine, would make those data unreadable, but
would still reveal if certain people live together.)


Paul Vinkenoog