| Subject | Re: [firebird-support] Tools for encription field in Firebird |
|---|---|
| Author | W O |
| Post date | 2014-08-28T17:50:51Z |
If you can read Spanish, here is an article about encryption, read also the related articles:
Greetings.
Walter.
On Thu, Aug 28, 2014 at 7:26 AM, Mark Rotteveel mark@... [firebird-support] <firebird-support@yahoogroups.com> wrote:
On Thu, 28 Aug 2014 12:54:33 +0200, "Svein Erling Tysvær
svein.erling.tysvaer@... [firebird-support]"Depending on the encryption algorithm, indexes might be entirely unusable.
<firebird-support@yahoogroups.com> wrote:
> At my workplace, we encrypt (or obfuscate) some fields in our programs
and
> only use Firebird for storage of the field (hence, Firebird knows
nothing
> about the encryption). One drawback with encryption is that it limits
use
> of indexes - it may be possible to use an index for exact match, but not
> for other things like BETWEEN, >=, LIKE or STARTING. Hence, think twice
> before encrypting fields in huge databases.
With a CBC algorithm and a random IV - which is the right choice -
encrypting the same cleartext leads to different ciphertext.
Mark