源代码的转换
创建目标文件夹
find forum_en_gbk -type d -exec mkdir -p utf8/{} /;生成脚本,用于将js文件从GBK编码转为UTF-8编码
find forum_en_gbk -name '*.js' -fprintf "js_gbk_to_utf8.sh" "iconv -f GBK -t UTF-8 %p > utf8/%p/n"生成脚本,用于将htm文件从GBK编码转为UTF-8编码
find forum_en_gbk -name '*.htm' -fprintf "htm_gbk_to_utf8.sh" "iconv -f GBK -t UTF-8 %p > utf8/%p/n"生成脚本,用于将php文件从GBK编码转为UTF-8编码
find forum_en_gbk -name '*.php' -fprintf "php_gbk_to_utf8.sh" "iconv -f GBK -t UTF-8 %p > utf8/%p/n"执行将js文件从GBK编码转为UTF-8编码的脚本
./js_gbk_to_utf8.sh执行将htm文件从GBK编码转为UTF-8编码的脚本
./htm_gbk_to_utf8.sh执行将php文件从GBK编码转为UTF-8编码的脚本
./php_gbk_to_utf8.sh替换ip数据文件
/ipdata/tinyipdata.dat数据库的转换
转换数据库的字符集
ALTER DATABASE `forum_en` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin转换数据表的字符集
ALTER TABLE `cdb_access` DEFAULT CHARACTER SET utf8 COLLATE utf8_binALTER TABLE `cdb_activities` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin
ALTER TABLE `cdb_activityapplies` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin
ALTER TABLE `cdb_adminactions` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin
ALTER TABLE `cdb_admincustom` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin
ALTER TABLE `cdb_admingroups` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin
ALTER TABLE `cdb_adminnotes` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin
ALTER TABLE `cdb_adminsessions` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin
ALTER TABLE `cdb_advcaches` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin
ALTER TABLE `cdb_advertisements` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin
ALTER TABLE `cdb_announcements` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin
ALTER TABLE `cdb_attachments` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin
ALTER TABLE `cdb_attachpaymentlog` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin
ALTER TABLE `cdb_attachtypes` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin
ALTER TABLE `cdb_banned` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin
ALTER TABLE `cdb_bbcodes` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin
ALTER TABLE `cdb_buddys` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin
ALTER TABLE `cdb_caches` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin
ALTER TABLE `cdb_campaigns` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin
ALTER TABLE `cdb_creditslog` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin
ALTER TABLE `cdb_crons` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin
ALTER TABLE `cdb_debateposts` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin
配置文件的修改
在config.inc.php文件中修改下面两行$dbcharset = 'utf8'; // MySQL 字符集, 可选 'gbk', 'big5', 'utf8', 'latin1', 留空为按照论坛字符集设定
$charset = 'utf-8'; // 论坛页面默认字符集, 可选 'gbk', 'big5', 'utf-8'