--------+
| ID | username | GENDER |BIRTHDAY | entry_date | JOB | salary | res
ume |
+------+-------------+--------+------------+------------+------+-----------+----
--------+
| 2 | wangdong | male | 1990-09-08 | 2014-02-17 | CTO | 100000.00 | str
ong man |
| 1 | wangdongxue | male |1990-09-08 | 2014-02-17 | CTO |100000.00 | str
ong man |
| 1 | wangdongxue | male |1990-09-08 | 2014-02-17 | CTO |100000.00 | str
ong man |
| 1 | wangdongxue | male | 1990-09-08| 2014-02-17 | CTO | 100000.00 | str
ong man |
+------+-------------+--------+------------+------------+------+-----------+----
--------+
4 rows in set (0.06 sec)
mysql> insert into USER values (3,'查显成','男性','1988-09-08','2014-02-17','UFO
',100000,'帅锅');
ERROR 1366 (HY000): Incorrect string value:'\xB2\xE9\xCF\xD4\xB3\xC9' for colum
n 'username' at row 1
mysql> show variables like'character_set%';
+--------------------------+----------------------------------------------------
-----+
| Variable_name | Value
|
+--------------------------+----------------------------------------------------
-----+
| character_set_client | utf8
|
| character_set_connection | utf8
|
| character_set_database | utf8
|
| character_set_filesystem | binary
|
| character_set_results | utf8
|
| character_set_server | utf8
|
| character_set_system | utf8
|
| character_sets_dir | D:\Program Files\MySQL\MySQL Server5.1\share\chars
ets\ |
+--------------------------+----------------------------------------------------
-----+
8 rows in set (0.07 sec)
mysql> set character_set_client=gbk;
Query OK, 0 rows affected (0.07 sec)
mysql> select * from user;
+------+-------------+--------+------------+------------+------+-----------+----
--------+
| ID | username | GENDER |BIRTHDAY | entry_date | JOB | salary | res
ume |
+------+-------------+--------+------------+------------+------+-----------+----
--------+
| 2 | wangdong | male | 1990-09-08 | 2014-02-17 | CTO | 100000.00 | str
ong man |
| 1 | wangdongxue | male |1990-09-08 | 2014-02-17 | CTO |100000.00 | str
ong man |
| 1 | wangdongxue | male |1990-09-08 | 2014-02-17 | CTO |100000.00 | str
ong man |
| 1 | wangdongxue | male |1990-09-08 | 2014-02-17 | CTO |100000.00 | str
ong man |
+------+-------------+--------+------------+------------+------+-----------+----
--------+
4 rows in set (0.00 sec)
mysql> insert into USER values (3,'汤柳清','男性','1988-09-08','2014-02-17','UFO
',100000,'帅锅');
Query OK, 1 row affected (0.02 sec)
mysql> select * from user;
+------+-------------+--------+------------+------------+------+-----------+----
--------+
| ID | username | GENDER |BIRTHDAY | entry_date | JOB | salary | res
ume |
+------+-------------+--------+------------+------------+------+-----------+----
--------+
| 2 | wangdong | male | 1990-09-08 | 2014-02-17 | CTO | 100000.00 | str
ong man |
| 1 | wangdongxue | male |1990-09-08 | 2014-02-17 | CTO | 100000.00| str
ong man |
| 1 | wangdongxue | male |1990-09-08 | 2014-02-17 | CTO |100000.00 | str
ong man |
| 1 | wangdongxue | male |1990-09-08 | 2014-02-17 | CTO |100000.00 | str
ong man |
| 3 | ユ | 锋