Subject | Re: [firebird-support] Field encrypt / decrypt.. |
---|---|
Author | Mark Rotteveel |
Post date | 2009-10-21T07:30:45Z |
> Any UDF supports encrypt / decrypt function ?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.
> I've looked into FreeAdhocUDF and checked
> F_ENCRYPTMD5 function but there's no Decrypt functions.
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