mysql 中文注释显示乱码

 

mysql> show create table interflow.reference_cost\G
*************************** 1. row ***************************
       Table: reference_cost
Create Table: CREATE TABLE `reference_cost` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '???? key',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '????',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '????',
  `update_oper` varchar(20) NOT NULL DEFAULT '' COMMENT '?????',
  `sn_year` varchar(10) NOT NULL DEFAULT '' COMMENT '??',
  `sn_month` varchar(10) NOT NULL DEFAULT '' COMMENT '??',
  `brand_id` int(12) NOT NULL COMMENT '??ID',
  `goods_sn` varchar(25) NOT NULL DEFAULT '' COMMENT '??',
  `cost_dj_untax` decimal(20,6) NOT NULL COMMENT '????-???',
  `create_oper` varchar(20) NOT NULL DEFAULT '' COMMENT '???',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=768105 DEFAULT CHARSET=utf8 COMMENT='?????'
1 row in set (0.00 sec)

中文注释显示乱码，设置一下参数：
 

set character_set_client = 'utf8';
set character_set_connection = 'utf8';
set character_set_database = 'utf8';
set character_set_results= 'utf8';
set character_set_server='utf8';

mysql> show create table interflow.reference_cost\G
*************************** 1. row ***************************
       Table: reference_cost
Create Table: CREATE TABLE `reference_cost` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增序列 key',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_oper` varchar(20) NOT NULL DEFAULT '' COMMENT '更新操作人',
  `sn_year` varchar(10) NOT NULL DEFAULT '' COMMENT '年份',
  `sn_month` varchar(10) NOT NULL DEFAULT '' COMMENT '月份',
  `brand_id` int(12) NOT NULL COMMENT '品牌ID',
  `goods_sn` varchar(25) NOT NULL DEFAULT '' COMMENT '款号',
  `cost_dj_untax` decimal(20,6) NOT NULL COMMENT '成本单价-不含税',
  `create_oper` varchar(20) NOT NULL DEFAULT '' COMMENT '创建人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=768105 DEFAULT CHARSET=utf8 COMMENT='备考成本表'
1 row in set (0.00 sec)