表字符集latin1，client如何查看中文字符

表结构如下：

*************************** 1. row ***************************
       Table: my_data_7e
Create Table: CREATE TABLE `my_data_7e` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` bigint(20) unsigned NOT NULL DEFAULT '0',
  `uname` varchar(16) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  `blog_id` varchar(22) NOT NULL DEFAULT '',
  `blog_type` int(11) unsigned NOT NULL DEFAULT '1',
  `blog_class` int(11) unsigned NOT NULL DEFAULT '0',
  `blog_title` varchar(96) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  `blog_info` text NOT NULL,
  `blog_body` mediumtext NOT NULL,
  `blog_pubdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `blog_uppdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `blog_pubip` varchar(16) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '000:000:000:000',
  `blog_uppip` varchar(16) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '000:000:000:000',
  `blog_hits` int(11) unsigned NOT NULL DEFAULT '0',
  `x_pic_flag` int(11) unsigned NOT NULL DEFAULT '0',
  `x_sizes` int(11) unsigned NOT NULL DEFAULT '0',
  `x_cms_flag` int(11) unsigned NOT NULL DEFAULT '1',
  `x_cms_nums` int(11) unsigned NOT NULL DEFAULT '0',
  `x_rank` int(11) unsigned NOT NULL DEFAULT '0',
  `status` int(11) unsigned NOT NULL DEFAULT '1',
  `blog_2008` int(2) unsigned NOT NULL DEFAULT '0',
  `is_top` int(11) unsigned NOT NULL DEFAULT '0',
  `is_sign` int(11) unsigned NOT NULL DEFAULT '0',
  `articlestatus` int(2) unsigned NOT NULL DEFAULT '0',
  `pubtime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `tj` int(3) unsigned NOT NULL DEFAULT '0',
  `x_rank_1` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `blog_id_u` (`blog_id`),
  KEY `uid_status_pubdate_x_rank` (`uid`,`status`,`blog_pubdate`,`x_rank`),
  KEY `uid_status_xr1_pbdate_xr` (`uid`,`status`,`x_rank_1`,`blog_pubdate`)
) ENGINE=InnoDB AUTO_INCREMENT=2964758 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8

表字符集是latin1

实验设置set names utf8、set names gbk和set names latin1

修改CRT字符集为GB2312

 

关键点：

1、binary

2、crt设置为gbk

 

原因呢？？

转载于:https://www.cnblogs.com/gsblog/p/3685669.html