mysql> Create Table Student(Sname CHAR(3)DEFAULT '男')ENGINE=InnoDB;
ERROR 1067 (42000): Invalid default value for 'Sname'
检查字符集设置
mysql> show variables like "%char%";+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
该设置的都设置了。
创建数据表时将字符集设置为utf8
mysql> Create Table Student(Sname CHAR(2)DEFAULT '男')ENGINE=InnoDB DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.02 sec)
可以设置中文数据了。