MySQL inserts Chinese into full question mark??? Problem-solving Method _mysql

1, check and modify the MySQL my.ini configuration file

Copy Code code as follows:

Default-character-set=utf8

2, the establishment of the database is to specify the character set

Copy Code code as follows:

Create DATABASE mydb default character set UTF8 collate utf8_general_ci;

3, the establishment of data representation also to specify the character set:
The problem command:

Copy Code code as follows:

CREATE TABLE IF not EXISTS ' MyDB ' (
' username ' varchar not NULL,
' userid ' int (one) is not NULL,
) Engine=innodb DEFAULT charset=latin1;

The correct command:

Copy Code code as follows:

CREATE TABLE IF not EXISTS ' MyDB ' (
' username ' varchar not NULL,
' userid ' int (one) is not NULL,
) Engine=innodb DEFAULT Charset=utf8;

Description: MySQL version: 5.5.24