MySQL 1267 error Solution

ArticleDirectory

• MySQL 1267 error Solution

MySQL 1267 error Solution If the character set used during table creation is different from the default MySQL character set, the following error occurs frequently during query operations, especially when there are Chinese characters:

Error 1267 (hy000): Illegal mix of collations (gbk_chinese_ci, implicit) and (latin1_swedish_ci, coercible) for Operation 'like'

Solution: Run "set names GBK" before executing the MySQL query statement. GBK is the character set used for table creation. Please modify it as needed!