veszka Posted May 9, 2011 Share Posted May 9, 2011 Hello, I found a strange symptom. I run the following sql statememt on my system: SELECT `customers_email_address` , md5(`customers_email_address`), md5('[email protected]') FROM `customers` WHERE `customers_email_address` = '[email protected]' and here is the result: customers_email_address [email protected] md5(`customers_email_address`) e7142ac387b136d8d400fadfc8c5b0c4 md5('[email protected]') cdd9624df4286dc51f1e187e43ce5255 as you can see, the two md5 hash are not equal. Why? What I did wrong? Thank you! Link to comment Share on other sites More sharing options...
veszka Posted May 10, 2011 Author Share Posted May 10, 2011 Hello, I found a strange symptom. I run the following sql statememt on my system: SELECT `customers_email_address` , md5(`customers_email_address`), md5('[email protected]') FROM `customers` WHERE `customers_email_address` = '[email protected]' and here is the result: customers_email_address [email protected] md5(`customers_email_address`) e7142ac387b136d8d400fadfc8c5b0c4 md5('[email protected]') cdd9624df4286dc51f1e187e43ce5255 as you can see, the two md5 hash are not equal. Why? What I did wrong? Thank you! Has anyone any idea? Kind regards! Link to comment Share on other sites More sharing options...
veszka Posted May 16, 2011 Author Share Posted May 16, 2011 Has anyone any idea? Kind regards! I got it. The problem is with charater set... Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.