我的mysql在配置时,默认字符集是gbk,我创建了一个数据库,我用mysql-front打开.sql文件后,发现里面的汉字不是简体字了,近似于乱码形式。
如下:
insert into category(cname,parentid,description,ctype) values ('鍖呭寘',0,'鍖呭寘',1);
insert into category(cname,parentid,description,ctype) values ('鐢佃剳浜у搧',0,'鐢佃剳浜у搧',1);
insert into category(cname,parentid,description,ctype) values ('鏁扮爜濞变箰',0,'鏁扮爜濞变箰',1);
insert into category(cname,parentid,description,ctype) values ('鍔炲叕瀹跺眳',0,'鍔炲叕瀹跺眳',1);
insert into category(cname,parentid,description,ctype) values ('鑻规灉涓撳尯',0,'鑻规灉涓撳尯',1);
insert into category(cname,parentid,description,ctype) values ('绀煎搧鍥㈣喘鍖?,0,'绀煎搧鍥㈣喘鍖?,1);insert into category(cname,parentid,description,ctype) values ('鎵嬫彁鍖?,1,'鎵嬫彁鍖?,2);
insert into category(cname,parentid,description,ctype) values ('鑳屽寘',1,'鑳屽寘',2);
insert into category(cname,parentid,description,ctype) values ('鏃呰绠卞寘',1,'鏃呰绠卞寘',2);
insert into category(cname,parentid,description,ctype) values ('绗旇鏈唴琚?,1,'绗旇鏈唴琚?,2);
insert into category(cname,parentid,description,ctype) values ('鏁扮爜鍖?,1,'鏁扮爜鍖?,2);
insert into category(cname,parentid,description,ctype) values ('浼戦棽鍖?,1,'浼戦棽鍖?,2);
请高人们帮我解释一下这是什么原因,怎么换成简体中文啊。
如下:
insert into category(cname,parentid,description,ctype) values ('鍖呭寘',0,'鍖呭寘',1);
insert into category(cname,parentid,description,ctype) values ('鐢佃剳浜у搧',0,'鐢佃剳浜у搧',1);
insert into category(cname,parentid,description,ctype) values ('鏁扮爜濞变箰',0,'鏁扮爜濞变箰',1);
insert into category(cname,parentid,description,ctype) values ('鍔炲叕瀹跺眳',0,'鍔炲叕瀹跺眳',1);
insert into category(cname,parentid,description,ctype) values ('鑻规灉涓撳尯',0,'鑻规灉涓撳尯',1);
insert into category(cname,parentid,description,ctype) values ('绀煎搧鍥㈣喘鍖?,0,'绀煎搧鍥㈣喘鍖?,1);insert into category(cname,parentid,description,ctype) values ('鎵嬫彁鍖?,1,'鎵嬫彁鍖?,2);
insert into category(cname,parentid,description,ctype) values ('鑳屽寘',1,'鑳屽寘',2);
insert into category(cname,parentid,description,ctype) values ('鏃呰绠卞寘',1,'鏃呰绠卞寘',2);
insert into category(cname,parentid,description,ctype) values ('绗旇鏈唴琚?,1,'绗旇鏈唴琚?,2);
insert into category(cname,parentid,description,ctype) values ('鏁扮爜鍖?,1,'鏁扮爜鍖?,2);
insert into category(cname,parentid,description,ctype) values ('浼戦棽鍖?,1,'浼戦棽鍖?,2);
请高人们帮我解释一下这是什么原因,怎么换成简体中文啊。
MySQL 中文显示乱码
建议直接mysqldump导出