dcsimg
Error in password when stored into Oracle 8.0.5 - Very Urgent!
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Anonymous
Posted On:   Tuesday, April 16, 2002 03:48 AM

I encrypted a password, say 'password' with MD5 then stored it into my Oracle database. The column is VARCHAR(255).



Later when I load that encrypted password from my database to compare with a user-entered password (which is also encrypted using the same MD5), I found that the one which I stored & loaded is slightly different.



I tried to verify this by printing the encrypted password prior to storing into my database & the discrepancy still occurs.



Can anyone help?



Many Thanks!

Re: Error in password when stored into Oracle 8.0.5 - Very Urgent!

Posted By:   Arup_Majumdar  
Posted On:   Tuesday, April 16, 2002 09:50 PM

This is due to the difference in the character encoding system.
When encrypting passwd using MD5, u might have used java utils, which converts the passwd
into a cyphettext in Unicode (2 bytes/character), whereas the Oracle database, most probably is
configured in ANSI text format (1 byte/character).
Try to store in the binary format and not as Varchar, that'll solve the problem.
About | Sitemap | Contact