求助 后台登陆问题

2016-07-07 15:45 来源:www.chinab4c.com 作者:ecshop专家

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT DISTINCT session_id FROM `sq_tjshop`.`ecs_cart` AS c, `sq_tjshop`.`ecs_sessions` AS s WHERE c.session_id = s.sesskey ) [2] => Array ( [error] => Illegal mix of collations (utf8_bin,IMPLICIT) and (gbk_bin,IMPLICIT) for operation '=' ) [3] => Array ( [errno] => 1267 ) )

登陆时候,怎么会出现这种问题。 出现这种问题的,好像不只是我一个人哦。

回答:
数据库的编码不一致,有的表是utf8有的是gbk。