mysql> insert into user(id  , username , birthday, sex, address) values('' ,  '

李四' , ' -' ,  'male' , 'beijing');

ERROR  (HY000): Incorrect string value: '\xC0\xEE\xCB\xC4' for column 'usern

ame' at row 1

mysql> select * from user;

Empty set (0.00 sec)

mysql> set names gbk;

Query OK,  rows affected (0.00 sec)

mysql> insert into user(id  , username , birthday, sex, address) values('' ,  '

李四' , ' -' ,  'male' , 'beijing');

Query OK,  row affected (0.10 sec)

mysql> select * from user;

+----+----------+------------+------+---------+

| id | username | birthday   | sex  | address |

+----+----------+------------+------+---------+

|   | 李四         |  - | male | beijing |

+----+----------+------------+------+---------+

 row in set (0.00 sec)