mysql> describe students;

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

| Field  | Type                | Null | Key | Default | Extra          |

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

| id     | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |

| name   | varchar(20)         | NO   |     | NULL    |                |

| age    | tinyint(3) unsigned | YES  |     | 0       |                |

| height | decimal(5,2)        | YES  |     | NULL    |                |

| gender | enum('              | YES  |     | NULL    |                |

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

5 rows in set, 2 warnings (0.01 sec)

mysql>

mysql> insert into students values('5','平二','18','160',2);

ERROR 1366 (HY000): Incorrect string value: '\xB6\xFE' for column 'name' at row 1

mysql>

mysql> set names gbk;

Query OK, 0 rows affected (0.00 sec)

mysql> insert into students values('5','平二','18','160',2);

Query OK, 1 row affected (0.00 sec)