mysql中角字符问题_mysql字符问题

创建一个表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

还是报错，哪位高所指教下

展开