Losing last 1 or 2 characters in md5 encrypted passwords.

[civalo]

I have a membership database created using mysql that is based on the tutorial on this site. Everything seems to be right, however, mysql is dropping the last 1 or 2 characters of the encrypted passwords.

 

At first i figured that the VarChar field was not large enough set at 30, and felt kinda dense...lol....so i set it to 50....still dropping them.....

 

then i figured it was my script, but it drops them even if entered directly in Mysql......

 

Any suggestions would be helpful.....if you like...the site is at http://12.224.177.157/index2.html

 

Thanks in advance.

[benW]

Try using BLOB or TEXT instead of VARCHAR

[sohaibshaheen]

Md5 string is 128 bits long....   

[Pikachu2000]

Try using BLOB or TEXT instead of VARCHAR                   

 

It's a 32 character hexidecimal string. Store it as CHAR(32), if you must use MD5. You'd be better off using something stronger, with a salt, though.

[fenway]

Try using BLOB or TEXT instead of VARCHAR                   

That's a terrible idea -- performance hell.