Shulou(Shulou.com)06/01 Report--

This article mainly introduces the solution to the 1267 error in mysql, which has certain reference value and can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

The solution to the 1267 error in mysql: execute [set names gbk] before executing the mysql query statement. Gbk is the character set used to build the table, please modify it according to the actual situation.

The solution to a 1267 error in mysql:

If the character set used when creating the table is different from the default character set of mysql, the following errors often occur during the query operation, especially if there are Chinese characters:

ERROR 1267 (HY000): Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation 'like'

The solution is:

Before executing the mysql query statement, execute "set names gbk". Gbk is the character set used to build the table, please modify it according to the actual situation!

Thank you for reading this article carefully. I hope it will be helpful for everyone to share the solutions to the 1267 errors in mysql. At the same time, I also hope that you will support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.