MySQL inserting data into data table garbled problem

MySQL CREATE database, data table, default setting is Latin1_swedish_ci

So when we create the database and data table should be based on their own needs to modify the format of the encoding, generally with UTF8_GENERAL_CI

You can also modify the MySQL configuration file by using the My.ini method.

Retrieve [client] add below her

Default-character-set=utf8

Retrieving [MySQL] and [mysqld] add in turn

Default-character-set=utf8

Character_set_server=utf8

Save the restart environment to create the database again:

MySQL inserting data into data table garbled problem