Illegal mix of collations (utf8_general_ci, IMPLICIT) and (gbk_chinese_ci, COERCIBLE) for operation & #39 ;=&# 39;, coercible

Illegal mix of collations (utf8_general_ci, IMPLICIT) and (gbk_chinese_ci, COERCIBLE) for operation '=', coercible

Error:Illegal mix of collations (utf8_general_ci, IMPLICIT) and (gbk_chinese_ci, COERCIBLE) for operation '='
Errno:1267

The problem is obvious, that is, the Mysql character encoding problem, so the main troubleshooting direction should be to set encoding and use Encoding

Here is a common command for Mysql to set encoding, which is generally used when linking data:

SET CHARACTER_SET_CLIENT = utf8,
CHARACTER_SET_CONNECTION = utf8,
CHARACTER_SET_DATABASE = utf8,
CHARACTER_SET_RESULTS = utf8,
CHARACTER_SET_SERVER = utf8,
COLLATION_CONNECTION = utf8_general_ci,
COLLATION_DATABASE = utf8_general_ci,
COLLATION_SERVER = utf8_general_ci,