MySQL character encoding

The mysql5.6 Community Edition is installed.

After installation, the encoding is set to UTF8

In the MySQL INI file

[Mysql]default-character-set=utf8[mysqld]default-character-set=utf8init_connect = ' Set NAMES UTF8 '  

When building a library, an example

CREATE DATABASE ' goods ' CHARACTER SET ' utf8 ' COLLATE ' utf8_general_ci ';

When building a table, an example

CREATE TABLE ' shop ' (id int (one) primary key auto_increment, ' owner ' varchar (+), ' maintype '  varchar ') engine= InnoDB DEFAULT Charset=utf8;

Complete the above settings, in MySQL with the CMD interface, the basic is Chinese.

The encoding is incorrect in the navicat used.

Right-click the Connection property, set to the same encoding as MySQL.

MySQL character encoding