Wampserver in MySQL Chinese garbled solution

1, modify the MySQL My.ini file:

Add below [client]

Default-character-set=utf8

Add below [mysqld]:

Character_set_server=utf8

2. Create a database:

Example to create a database code:

To create a database PHP:

1. CREATE DATABASE ' php '
2. CHARACTER SET ' UTF8 '
3. COLLATE ' utf8_general_ci ';

CREATE TABLE User:

1. CREATE TABLE ' user ' (
2. ' ID ' varchar (+) not NULL default ' ',
3. ' Name ' varchar (+) not NULL default '
4. ) Engine=innodb DEFAULT Charset=utf8;

Insert data:

1. Insert into User (Id,name) VALUES (1,' big Data ');
2. Insert into User (Id,name) VALUES (2,' cloud computing ');
3. Insert into User (Id,name) VALUES (3,' Hadoop ');
4. Insert into User (Id,name) VALUES (4,' hbase ');
5. Insert into User (Id,name) VALUES (5,' database ');

Wampserver in MySQL Chinese garbled solution