MySQL不知道哪里出错了

Question

以下代码输入性别时出错
mysql> create table student(
-> id int,
-> name varchar(20),
-> grade float,
-> gender char
-> );
Query OK, 0 rows affected (0.04 sec)

mysql> insert into student(id,name,grade,gender)
-> values(1,'lily',98,'男');
ERROR 1366 (HY000): Incorrect string value: '\xC4\xD0' for column 'gender' at row 1

Answer 1

gender字段长度不够，用char的话长度设为4，因为utf8汉字占3个字节