mysql 在DOS窗口输入带中文的数据时报错,知道是字符集问题,但都改成utf8了,求解这到底是怎么回事!
mysql> show variables like '%character%';
+--------------------------+-------------------------------------------+
| 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 | I:\MySQL\MySQL Server 5.5\share\charsets\ |
+--------------------------+-------------------------------------------+
8 rows in set (0.00 sec)
mysql> insert into student(id,name,chinese,english,math) values(5,'李来财',82,84,67);
ERROR 1366 (HY000): Incorrect string value: '\xC0\xEE\xC0\xB4\xB2\xC6' for column 'name' at row 1