note 80414 added to function.md5

MySQL MD() will not give you the same hash if character set is different. ex : <?php #suppose table_name CHARSET=UTF8 #$md5 = md5('Städte'); # will give you a different hash than MySQL MD5() #instead use $md5 = md5(utf8_encode('Städte')); $r = mysql_query("SELECT *, MD5(word) FROM table_name WHERE MD5(word) LIKE '{$md5}'"); if($r) while( $row= mysql_fetch_assoc($r) ) print_r($row); ?> ---- Server IP: 69.147.83.197 Probable Submitter: 196.219.79.81 ---- Manual Page -- http://www.php.net/manual/en/function.md5.php Edit -- https://master.php.net/note/edit/80414 Del: integrated -- https://master.php.net/note/delete/80414/integrated Del: useless -- https://master.php.net/note/delete/80414/useless Del: bad code -- https://master.php.net/note/delete/80414/bad+code Del: spam -- https://master.php.net/note/delete/80414/spam Del: non-english -- https://master.php.net/note/delete/80414/non-english Del: in docs -- https://master.php.net/note/delete/80414/in+docs Del: other reasons-- https://master.php.net/note/delete/80414 Reject -- https://master.php.net/note/reject/80414 Search -- https://master.php.net/manage/user-notes.php