Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (gbk_chinese_ci,COERCIBLE) for operation '='' in E:\www\edusoho\vendor\doctrine\dbal\lib\Doctrine\DBAL\Connection.php:643 Stack trace: #0 E:\www\edusoho\vendor\doctrine\dbal\lib\Doctrine\DBAL\Connection.php(643): PDOStatement->execute(Array) #1 E:\www\edusoho\vendor\doctrine\dbal\lib\Doctrine\DBAL\Connection.php(381): Doctrine\DBAL\Connection->executeQuery('SELECT * FROM u...', Array) #2 E:\www\edusoho\src\Topxia\Service\User\Dao\Impl\UserDaoImpl.php(29): Doctrine\DBAL\Connection->fetchAssoc('SELECT * FROM u...', Array) #3 E:\www\edusoho\src\Topxia\Service\User\Impl\UserServiceImpl.php(237): Topxia\Service\User\Dao\Impl\UserDaoImpl->findUserByNickname('????????????') #4 E:\www\edusoho\src\Topxia\Service\User\Impl\UserServiceImpl.php(298): Topxia\Service\User\Impl\UserServiceImpl->isNicknameAvaliable('????????????') #5 E:\www\edusoho\web\install\install.php(261): Topxia\ in E:\www\edusoho\vendor\doctrine\dbal\lib\Doctrine\DBAL\DBALException.php on line 47

http://blog.csdn.net/hi0000012345/article/details/6447846

解决Mysql：Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

1、请问一下您的mysql版本是多少

2、并查看一下创建的数据库编码是什么

show create database db_name;

use dbname; status;

 

感觉回答。

mysql-essential-5.1.55

CREATE DATABASE `edusoho` /*!40100 DEFAULT CHARACTER SET gbk */

请问这几行错误代码是我的MYSQL有问题吗？如何解决？

@美师美课:感觉回答。 mysql-essential-5.1.55 CREATE DATABASE `edus...

是的。您的数据库是gbk编码的。你需要重新设置为utf-8编码的。

具体请查看 @东海顽石 的帖子

感谢回答！

我已经更换成utf-8编码,查询如下：

CREATE DATABASE `edusoho` /*!40100 DEFAULT CHARACTER SET utf8 */

呆会我重起计算机再试。

另外我还有一个担心，就是edusoho的改成了uft-8，我有的数据库还是用的gbk，会不会影响到我其他的数据库呢？

亲，会的。 你可以重建edusoho数据库。用utf-8-general-ci重建

我重启了，确实也是utf-8-general-ci，但问题依旧存在！

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (gbk_chinese_ci,COERCIBLE) for operation '='' in E:\www\edusoho\vendor\doctrine\dbal\lib\Doctrine\DBAL\Connection.php:643 Stack trace: #0 E:\www\edusoho\vendor\doctrine\dbal\lib\Doctrine\DBAL\Connection.php(643): PDOStatement->execute(Array) #1 E:\www\edusoho\vendor\doctrine\dbal\lib\Doctrine\DBAL\Connection.php(381): Doctrine\DBAL\Connection->executeQuery('SELECT * FROM u...', Array) #2 E:\www\edusoho\src\Topxia\Service\User\Dao\Impl\UserDaoImpl.php(29): Doctrine\DBAL\Connection->fetchAssoc('SELECT * FROM u...', Array) #3 E:\www\edusoho\src\Topxia\Service\User\Impl\UserServiceImpl.php(237): Topxia\Service\User\Dao\Impl\UserDaoImpl->findUserByNickname('????????????') #4 E:\www\edusoho\src\Topxia\Service\User\Impl\UserServiceImpl.php(298): Topxia\Service\User\Impl\UserServiceImpl->isNicknameAvaliable('????????????') #5 E:\www\edusoho\web\install\install.php(261): Topxia\ in E:\www\edusoho\vendor\doctrine\dbal\lib\Doctrine\DBAL\DBALException.php on line 47

大家帮忙解决一下吧，是怎么回事？数据库确实也是utf-8-general-ci，但问题依旧存在，是不是还有其他的细节设置？

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (gbk_chinese_ci,COERCIBLE) for operation '='' in E:\www\edusoho\vendor\doctrine\dbal\lib\Doctrine\DBAL\Connection.php:643 Stack trace: #0 E:\www\edusoho\vendor\doctrine\dbal\lib\Doctrine\DBAL\Connection.php(643): PDOStatement->execute(Array) #1 E:\www\edusoho\vendor\doctrine\dbal\lib\Doctrine\DBAL\Connection.php(381): Doctrine\DBAL\Connection->executeQuery('SELECT * FROM u...', Array) #2 E:\www\edusoho\src\Topxia\Service\User\Dao\Impl\UserDaoImpl.php(29): Doctrine\DBAL\Connection->fetchAssoc('SELECT * FROM u...', Array) #3 E:\www\edusoho\src\Topxia\Service\User\Impl\UserServiceImpl.php(237): Topxia\Service\User\Dao\Impl\UserDaoImpl->findUserByNickname('????????????') #4 E:\www\edusoho\src\Topxia\Service\User\Impl\UserServiceImpl.php(298): Topxia\Service\User\Impl\UserServiceImpl->isNicknameAvaliable('????????????') #5 E:\www\edusoho\web\install\install.php(261): Topxia\ in E:\www\edusoho\vendor\doctrine\dbal\lib\Doctrine\DBAL\DBALException.php on line 47

@美师美课: Fatal error: Uncaught exception 'PDOException' wi...

建议上群里找专家远程协助。 这个还是个环境的问题呀。

谢谢大家，我已搞定，在你们提供的帮助答案的基础上，Program Files\MySQL\MySQL Server 5.1中，将my.ini中的gbk都改为uft8，然后删除数据库，重起计算机，再来试，这次就OK了！