mysql插入中文字段出现乱码问题

创建orders_ware_info

mysql> CREATE TABLE orders_ware_info -> ( -> `id` INT AUTO_INCREMENT comment '编号', -> `order_id` INT comment '订单编号', -> `address` VARCHAR(200) comment '地址', -> `areacode` VARCHAR(20) comment '区域编号', -> PRIMARY KEY(id) -> );

插入数据

mysql> INSERT INTO orders_ware_info(id,order_id,address,areacode) VALUES (1,1,'北京','110');

错误：

ERROR 1366 (HY000): Incorrect string value: '\xE5\x8C\x97\xE4\xBA\xAC' for column 'address' at row 1 mysql>alter table orders_ware_info modify address varchar(200) character set gbk;

再次插入

INSERT INTO orders_ware_info(id,order_id,address,areacode) VALUES (1,1,'北京','110');