Jump to content

Archived

This topic is now archived and is closed to further replies.

civalo

Losing last 1 or 2 characters in md5 encrypted passwords.

Recommended Posts

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.

Share this post


Link to post
Share on other sites

Try using BLOB or TEXT instead of VARCHAR

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Try using BLOB or TEXT instead of VARCHAR                   

That's a terrible idea -- performance hell.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.