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

感觉回答。

mysql-essential-5.1.55

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

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

感谢回答！

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

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

呆会我重起计算机再试。

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

我重启了，确实也是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

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