Subject Re: [firebird-support] Field encrypt / decrypt..
Author Mark Rotteveel
> Any UDF supports encrypt / decrypt function ?
> I've looked into FreeAdhocUDF and checked
> F_ENCRYPTMD5 function but there's no Decrypt functions.

MD5 is a (cryptographic) hash function, which is a one way function to scramble content in a deterministic way (eg for passwords or for cryptographic signatures). There is no possibility to reverse an MD5 hash, so there is no decrypt function for that.

If you want encryption/decryption, you'll need to use something like AES. I am of the opinion that usually one would apply cryptography in the application, not in the database.

Mark
--
Jetzt kostenlos herunterladen: Internet Explorer 8 und Mozilla Firefox 3.5 -
sicherer, schneller und einfacher! http://portal.gmx.net/de/go/atbrowser