MySQL and navicat Chinese garbled Solution

After research

 

After MySQL sets the encoding gb2312,

 

In navicat, select the MySQL Default Character Set, select the default character set when creating the database, and create the varchar field of the table (or its

 

Other character fields) do not select encoding, the system default GBK encoding, there will be no garbled.

 

If you have already created a table with garbled characters, you must adjust the three types of codes. In particular, it is necessary to design a table with the fields of relevant characters

 

Change each configuration to GBK.