数据库环境是
mysql5.x
default-character-set=gbk
collation = gbk-chinese-ci
引擎:MyISAM有一个字段,要插入中文,其它的中文字可以但MySQL死活插不进这个中文字:焗(焗油)
报错:Incorrect string value: '\xE7\x84\x97\xE6\xB2\xB9' for column 'hanyi' at row 1怎么搞?有没有GB18030编码?
mysql5.x
default-character-set=gbk
collation = gbk-chinese-ci
引擎:MyISAM有一个字段,要插入中文,其它的中文字可以但MySQL死活插不进这个中文字:焗(焗油)
报错:Incorrect string value: '\xE7\x84\x97\xE6\xB2\xB9' for column 'hanyi' at row 1怎么搞?有没有GB18030编码?
Query OK, 1 row affected (0.02 sec)mysql> SELECT *FROM tb;
+------+----------+
| id | name |
+------+----------+
| 1 | liangck |
| 1 | liang'ck |
| 2 | 焗 |
+------+----------+
3 rows in set (0.00 sec)
Query OK, 0 rows affected (0.00 sec)mysql> create table tx(c varchar(10) CHARACTER SET 'gbk');
Query OK, 0 rows affected (0.08 sec)mysql> show full columns from tx;
+-------+-------------+----------------+------+-----+----
| Field | Type | Collation | Null | Key | Def
+-------+-------------+----------------+------+-----+----
| c | varchar(10) | gbk_chinese_ci | YES | | NUL
+-------+-------------+----------------+------+-----+----
1 row in set (0.05 sec)mysql> insert into tx values ('是');
Query OK, 1 row affected (0.03 sec)mysql> insert into tx values ('焗');
Query OK, 1 row affected (0.03 sec)mysql> select * from tx;
+------+
| c |
+------+
| 是 |
| 焗 |
+------+
2 rows in set (0.00 sec)mysql>测试正常啊。建议你参考一下
http://topic.csdn.net/u/20090513/09/9ff145ac-8c3a-4f6b-9a15-aa931d9d8c2d.html
换成GBK或者Utf-8就可以
gbk和gb2312‘=’不匹配,十分疑惑。
我一般都是set names 'gbk'.
用utf8有时候会有问题!