Re: [GENERAL] MD5

[Chris Smith]

Use the md5 function:
select md5('welcome');
               md5
----------------------------------
 40be4e59b9a2a2b5dffb918c0e86b3d7
(1 row)
Regards,
Chris Smith
Suite 30, 45-51 Huntley St, Alexandria, NSW 2015 Australia
Ph: +61 2 9517 2505
Fx: +61 2 9517 1915
email: [EMAIL PROTECTED]
web: www.interspire.com
Jamie Deppeler wrote:
Tino Wildenhain wrote:
Hi,
Am Freitag, den 17.12.2004, 09:41 +1100 schrieb Jamie Deppeler:
 

Hi,
I was just wondering is it possible to encrypt a filed in the database 
with md5? i know it is possible to do it with DB users
   

No. You cannot encrypt with md5 because you cant decrypt.
md5 is a hash function. But you can use it any time to
hash values you insert.
Regards
Tino

 

Well basically i want to store and hashed value that will never be 
changed just compaired too hashed values

also when i try to encrpyt a field i get this error 
encypt(text,"unknown","unknown")

------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.5.4 - Release Date: 12/15/2004

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.5.4 - Release Date: 12/15/2004
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend