If you can read Spanish, here is an article about encryption, read also the related articles:
http://firebird21.wordpress.com/2014/08/28/encriptando-columnas-de-una-tabla/ Greetings. Walter. On Thu, Aug 28, 2014 at 7:26 AM, Mark Rotteveel [email protected] [firebird-support] <[email protected]> wrote: > > > On Thu, 28 Aug 2014 12:54:33 +0200, "Svein Erling Tysvær > [email protected] [firebird-support]" > > <[email protected]> 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. > > Depending on the encryption algorithm, indexes might be entirely unusable. > With a CBC algorithm and a random IV - which is the right choice - > encrypting the same cleartext leads to different ciphertext. > > Mark > > >
