Example to explain the solution of MySQL character set error

The error is as follows:

Illegal mix of collations (gbk_chinese_ci,implicit)

and (gbk_bin,implicit) for operation ' = ',

SQL state:hy000, Error code:1267

Error Reason:

The encoding of the database is different from the coding of the table;

Processing method:

If the code set when MySQL is installed is JBK, the following can be handled when the table is being built:

CREATE TABLE ' Teachers ' (

' id ' int (one) not NULL default ' 0 ',

' name ' varchar default NULL,

' Password ' varchar default NULL,

' department_id ' int (one) default NULL,

PRIMARY KEY (' id ')

) Engine=myisam DEFAULT CHARSET=GBK;

Or:

CREATE TABLE ' Teachers ' (

' id ' int (one) not NULL default ' 0 ',

' name ' varchar default NULL,

' Password ' varchar default NULL,

' department_id ' int (one) default NULL,

PRIMARY KEY (' id ')

) ;