PHP md5() gives different output then MySQL md5

Question

I'm trying to set up a login system, but I can't solve one problem: PHP is giving me an other output with md5(); than MySQL... For example, in PHP: ``` $password = md5("brickmasterj"); return $password; ``` Returns: ``` 3aa7b18f304e2e2a088cfd197351cfa8 ``` But the MySQL equivalent gives me a shorter version: ``` 3aa7b18f304e2e2a08 ``` What's the problem? And how do I work with this while checking passwords?

Accepted Answer

I guess the problem in the length of column of your table, set the length of password field to at least 32

PHP md5() gives different output then MySQL md5

Solution

Problem