[Type] 查询语句错误
[1267] Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
[Query] SELECT count, lastupdate FROM common_failedlogin WHERE ip='218.79.226.160' AND username='上海'Program messages: [Line: 0030]admin.php(discuz_admincp->init)
[Line: 0056]source/class/class_admincp.php(discuz_admincp->check_cpaccess)
[Line: 0124]source/class/class_admincp.php(discuz_admincp->check_user_login)
[Line: 0165]source/class/class_admincp.php(logincheck)
[Line: 0113]source/function/function_member.php(DB::fetch_first)
[1267] Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
[Query] SELECT count, lastupdate FROM common_failedlogin WHERE ip='218.79.226.160' AND username='上海'Program messages: [Line: 0030]admin.php(discuz_admincp->init)
[Line: 0056]source/class/class_admincp.php(discuz_admincp->check_cpaccess)
[Line: 0124]source/class/class_admincp.php(discuz_admincp->check_user_login)
[Line: 0165]source/class/class_admincp.php(logincheck)
[Line: 0113]source/function/function_member.php(DB::fetch_first)
解决方案 »
- 数组问题...
- 当用户通过浏览器访问服务器时,服务器上的用户是谁呢?
- 一个简单的变量问题
- 求mysql查询语句
- 怎么让鼠标停在一个有背景图片的td上时,鼠标指针变手形?
- php+mysql站内搜索+分页
- 有关phpMyAdmin的运行问题!
- 想用PHP来测试网络上文件是否存在,HTTP协议的可以,其他的就不可以了,有方法吗?
- 初学PHP,请各位介绍一下比较好用得PHP编辑软件。谢谢了
- 紧急求助smarty section遍历问题
- EasyEclipse for PHP上面,如何使用断点调试?
- 为什么PHP向MySQL中插入中文后,在MySQL和网页上显示的都是?????啊?跪求大仙帮忙!!!!
所以提交过来的中文请正确的编码,例如UTF-8.这个得看你提交页面的编码以及是用何种方式传递中文.然后再根据自己数据库的编码定义进行相应的转换.