Troubleshooting database MySQL Insertion garbled problem

When we encounter MySQL garbled problem, the general need to modify the My.ini file;

I came across two versions, one mysql5.5 and the other mysql5.7 .

5.5 is under this directory: C:\Program files\mysql\mysql Server 5.5

5.7 is under this directory: C:\ProgramData\MySQL\MySQL Server 5.7

Note that: 5.7 programdata is a hidden file, you need to enter the Programdata to see, and then to modify;

The next step is how to change the font:

The SQL file can be displayed by opening the My.ini with sublime, and in SQL format:

Start the database in PowerShell, then enter \s, view the character set,

If it is GBK in the file to change to GBK, if UTF8 do not change, in short, let the character set unified;

This operation will basically solve the MySQL garbled problem.

Note that you need to restart the server at last!

Troubleshooting database MySQL Insertion garbled problem