ERROR 1366 (HY000): Incorrect string value: '\xB5\xC4\xB7\xA8\xCA\xA6...' for co
lumn 'user_name' at row 1在插入中午是报上面的错误,在网上的方法都用了,我也确定我数据库的编码是统一的UTF-8的方式,不知道是什么问题,请各位帮我看看,谢谢了
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 | D:\MySQL\MySQL Server 5.0\share\charsets\ |
+--------------------------+-------------------------------------------+mysql数据库中文乱码
lumn 'user_name' at row 1在插入中午是报上面的错误,在网上的方法都用了,我也确定我数据库的编码是统一的UTF-8的方式,不知道是什么问题,请各位帮我看看,谢谢了
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 | D:\MySQL\MySQL Server 5.0\share\charsets\ |
+--------------------------+-------------------------------------------+mysql数据库中文乱码
MYSQL命令行不支持UTF8