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');