About MySQL Chinese garbled

The first step: Check the SQL script to see if the statement that created the database has a setting utf8:create the default character set UTF8;

Step two: At the end of the statement that creates the table, add: Character set = UTF8; make the table recognize UTF8;

The third step: because the operating system is Chinese, so character_set_results must be set to Gb2312,results is when you query the database results.

<!--attention!!! This setting is only currently valid, the next time you open SQL or the original settings--

Set Character_set_client=utf8;
Set Character_set_connection=utf8;
Set Character_set_database=utf8;
Set character_set_filesystem=binary;
Set character_set_results=gb2312;
Set Character_set_server=utf8;
Set Character_set_system=utf8;

Fourth step: source E:/shop.sql; complete.

About MySQL Chinese garbled