Md5 checksum changes when password submitted to MySQL db??

[pcghost]

I have a field, it's a varchar(16). Now I know it is not long enough to hold the Md5 checksum of a standard length password, but that is beside the point for the moment. Here is the situation. When our PHP script runs its UPDATE query and writes the Md5 checksum to the database (roughly 35 digits) what ends up in the database is a completely different 16 digit checksum. Now the strange thing is if we run a query to compare the two it comes back saying they are the same.

Does MySQL have some native checksum compressing ability or am I smoking my breakfast? How can they be == if they are different lengths? 😕

[jweissig]

Hello,

A md5 sun should only be 16 bytes long, so your varchar values should be good.

Can you please post the before value and the after values. Can you please show me the script that is making the convertion.

Thanks,
- Justin