ERROR 1366 (HY000): Incorrect string value: '\xB4\xE7\xB1\xCA\xBC\xC7...' for co lumn 'goods_name' a

mysql> INSERT tdb_goods (goods_name,goods_cate,brand_name,goods_price,is_show,is
_saleoff) VALUES(‘R510VC 15.6英寸笔记本’,’笔记本’,’华硕’,’3399’,DEFAULT,DEFAULT)
;
ERROR 1366 (HY000): Incorrect string value: ‘\xB4\xE7\xB1\xCA\xBC\xC7…’ for co
lumn ‘goods_name’ at row 1

解决方案：

首先查看自己的数据表情况：

mysql> SHOW CREATE TABLE tdb_goods;

+———–+———————————————————————————————————————————————————————–

——————————————————————————————-+
| Table | Create Table

                                                                                       |

+———–+———————————————————————————————————————————————————————–

——————————————————————————————-+
| tdb_goods | CREATE TABLE tdb_goods(
goods_idsmallint(5) unsigned NOT NULL AUTO_INCREMENT,
goods_namevarchar(150) NOT NULL,
goods_catevarchar(40) NOT NULL,
brand_namevarchar(40) NOT NULL,
goods_pricedecimal(15,3) unsigned NOT NULL DEFAULT '0.000',
is_showtinyint(1) NOT NULL DEFAULT '1',
is_saleofftinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (goods_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 |

+———–+———————————————————————————————————————————————————————–

——————————————————————————————-+
1 row in set (0.00 sec)

mysql>

然后执行如下命令：

mysql> SET NAMES gbk;
Query OK, 0 rows affected (0.00 sec)

mysql>

再然后插入数据：

mysql> INSERT tdb_goods (goods_name,goods_cate,brand_name,goods_price,is_show,is
_saleoff) VALUES(‘R510VC 15.6英寸笔记本’,’笔记本’,’华硕’,’3399’,DEFAULT,DEFAULT)
;