数据库能设置uft-8的我都设置了,可是存中文的时候还是出错:
mysql> insert into licensey (yjyfw,jname) values ('麻醉药品',161);
ERROR 1366 (HY000): Incorrect string value: '\xC2\xE9\xD7\xED\xD2\xA9...' for column 'yjyfw' at row 1
mysql> insert into licensey (yjyfw,jname) values ('CoCo',161);//存英文就可以
Query OK, 1 row affected (0.11 sec)
[mysqld]
default-character-set=utf8
character-set-server=utf8
character_set_server=utf8
[mysql.server]
default-character-set = utf8
[mysqld_safe]
default-character-set = utf8
[client]
default-character-set = utf8
[mysql]
default-character-set=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 | C:\Program Files (x86)\MySQL\MySQL Server 5.5\share\charsets\ |
+--------------------------+---------------------------------------------------------------+
8 rows in set (0.00 sec)
看我这时间发问题就知道我弄了一个晚上了,呜呜呜
也不知道大神们几点睡醒T。T