原来倒入的帖子都用html utf8 encoding 成 袈 的形式, 属于ascii, 没有乱码。 但是编辑的时候会头疼。。
新写的,
把mysql table 的语言都切换成 utf8,
ALTER TABLE `evo_antispam` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
ALTER TABLE `evo_basedomains` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
ALTER TABLE `evo_bloggroups` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
ALTER TABLE `evo_blogs` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
ALTER TABLE `evo_blogusers` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
ALTER TABLE `evo_categories` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
ALTER TABLE `evo_coll_settings` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
ALTER TABLE `evo_comments` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
ALTER TABLE `evo_files` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
ALTER TABLE `evo_filetypes` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
ALTER TABLE `evo_groups` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
ALTER TABLE `evo_hitlog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
ALTER TABLE `evo_links` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
ALTER TABLE `evo_locales` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
ALTER TABLE `evo_pluginevents` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
ALTER TABLE `evo_plugins` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
ALTER TABLE `evo_pluginsettings` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
ALTER TABLE `evo_pluginusersettings` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
ALTER TABLE `evo_postcats` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
ALTER TABLE `evo_posts` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
ALTER TABLE `evo_poststatuses` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
ALTER TABLE `evo_posttypes` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
ALTER TABLE `evo_sessions` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
ALTER TABLE `evo_settings` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
ALTER TABLE `evo_subscriptions` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
ALTER TABLE `evo_useragents` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
ALTER TABLE `evo_users` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
ALTER TABLE `evo_usersettings` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
ALTER TABLE `evo_item__prerendering` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci ; 然后修改 conf/_locales.php.
$force_io_charset_if_accepted = 'utf-8';
$db_config['connection_charset'] = 'utf8';
$default_locale = 'zh-CN-utf-8'; /*注意这个http://forums.b2evolution.net/viewtopic.php?t=13709 上没有提到,但是也是很重要的*/这样mysql里保存的不是html utf8 encoded, 而是真是的unicode, 这样编辑不会困难。
不过似乎偶尔还会出现乱码问题,再观察观察。
没有评论:
发表评论