表字符集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
原因呢??