md5 password encyption

[wesomon99]

Sorry if this is an obvious solution, but searching has produced nothing for me.

I have a MySQL database with passwords encrypted using an MD5 hash. I then have java code that also encrypts using MD5 to check passwords that a user puts in.

This works fine for almost all passwords. However, if a password begins with a number, the hash does not work.

Here is an example, for the password '12345':
MySQL MD5 hash:
827ccb0eea8a706 c4c34a16891f84e 7b
Java MD5 hash:
827ccbeea8a706c 4c34a16891f84e7 b

Example for the password '1pass':
MySQL MD5 hash:
0a9f45cecbccaad a43f6ca89774390 4d
Java MD5 hash:
a9f45cecbccaada 43f6ca897743904 d


The MySQL MD5 inserts a 0 somewhere, producing a string 1 extra character long.
Help?

[Atli]

The 32 character long MD5 that the MySQL is generating is correct. If this is the string generated by you Java function, it must be bugged.

I've check with both PHP and C#, and in both cases they matched the MySQL output.

[wesomon99]

The 32 character long MD5 that the MySQL is generating is correct. If this is the string generated by you Java function, it must be bugged.

I've check with both PHP and C#, and in both cases they matched the MySQL output.

Okay Atli, thanks for the help. I switched to using the MySQL MD5 encryption (SELECT MD5('password') ) and this has worked perfectly.