这是字符编码的问题吗
mysql> insert tdb_goods_cate(cate_name) select goods_cate from tdb_goods group by goods_cate;
ERROR 1366 (HY000): Incorrect string value: '\xE5\x8F\xB0\xE5\xBC\x8F...' for column 'cate_name' at row 23
用的是Windows系统编码gbk,数据库编码utf8。是冲突了吧!
mysql> insert tdb_goods_cate(cate_name) select goods_cate from tdb_goods group by goods_cate;
ERROR 1366 (HY000): Incorrect string value: '\xE5\x8F\xB0\xE5\xBC\x8F...' for column 'cate_name' at row 23
用的是Windows系统编码gbk,数据库编码utf8。是冲突了吧!
2019-01-30
举报