创建一个表mysql>createtabletest(usernamevarchar(20));QueryOK,0rowsaffected(0.02sec)插入一个词语mysql>insertintotestvalues("你好");ERROR1366(HY000):Incorrectstringvalue:'\...
创建一个表
mysql> create table test(username varchar(20));
Query OK, 0 rows affected (0.02 sec)
插入一个词语
mysql> insert into test values("你好");
ERROR 1366 (HY000): Incorrect string value: '\xE4\xBD\xA0\xE5\xA5\xBD' for column 'username' at row 1
查看字符集
mysql> show global variables like 'char%';
+--------------------------+----------------------------------+
| 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 | /usr/local/mysql/share/charsets/ |
+--------------------------+----------------------------------+
正确啊,没有问题
使用set names设置utf8和gbk字符
mysql> insert into test values("你好");
ERROR 1366 (HY000): Incorrect string value: '\xE4\xBD\xA0\xE5\xA5\xBD' for column 'username' at row 1
mysql> set names gbk;
Query OK, 0 rows affected (0.00 sec)
mysql> insert into test values("你好");
ERROR 1366 (HY000): Incorrect string value: '\xE4\xBD\xA0\xE5\xA5\xBD' for column 'username' at row 1
还是报错,哪位高所指教下
展开