\u4e00\u5e74\u591a\u524d\u7684B52 Forum \u7528\u4e86phpBB2 big5 \u7de8\u78bc\uff0c\u6b77\u7d93\u4e86HDD\u640d\u6bc0\uff0c\u704c\u4e86\u65b0\u7684CentOS 5.x (\u539f\u672c\u70baver.4.x) Mysql \u4e5f\u5f9e4.x \u8b8a\u6210\u4e865.x\u3002
\n\u5176\u4ed6\u7684application \u79fb\u690d\u90fd\u6c92\u4ec0\u9ebc\u554f\u984c\uff0c\u552f\u7368\uff0cphpBB2 \u8cc7\u6599\u5eab\u7de8\u78bc\u3002\u5728\u8cc7\u6599\u5eab\u4e0a\u770b\u5230\u7684\u662f\u7a7f\u8457latin \u7de8\u78bc\uff0c\u4e0d\u904e\u5be6\u8cea\u4e0a\u662fbig5 \u7de8\u78bc\uff0c\u79fb\u690d\u5230Mysql 5.0 \u6574\u500b\u7d66\u4f60\u4e82\u78bc\uff0cdefault utf8\u7de8\u78bc\u3002<\/p>\n
\u6628\u5929P Project pending \u4e2d\uff0c\u5c31\u5728\u516c\u53f8\u7528AppServ \u6a21\u64ec\u8d77\u8cc7\u6599\u5eab\u7684\u8f49\u63db\u3002<\/p>\n
1. \u9996\u5148\uff0c\u5148\u5b89\u88dd2.4.4a AppServ, \u628a\u4e4b\u524d\u7684\u8cc7\u6599\u5eab\u639b\u9032\u53bb, \u9810\u8a2d\u61c9\u8a72\u662flatin \u7de8\u78bc \u53c3\u8003\u7db2\u7ad9<\/p>\n http:\/\/blog.teatime.com.tw\/post\/1\/48 \u4e00\u5e74\u591a\u524d\u7684B52 Forum \u7528\u4e86phpBB2 big5 \u7de8\u78bc\uff0c\u6b77\u7d93\u4e86HDD\u640d\u6bc0\uff0c\u704c\u4e86\u65b0\u7684CentOS 5.x (\u539f\u672c\u70baver.4.x) Mysql \u4e5f\u5f9e4.x \u8b8a\u6210\u4e865.x\u3002 \u5176\u4ed6\u7684application \u79fb\u690d\u90fd\u6c92\u4ec0\u9ebc\u554f\u984c\uff0c\u552f\u7368\uff0cphpBB2 \u8cc7\u6599\u5eab\u7de8\u78bc\u3002\u5728\u8cc7\u6599\u5eab\u4e0a\u770b\u5230\u7684\u662f\u7a7f\u8457latin \u7de8\u78bc\uff0c\u4e0d\u904e\u5be6\u8cea\u4e0a\u662fbig5 \u7de8\u78bc\uff0c\u79fb\u690d\u5230Mysql 5.0 \u6574\u500b\u7d66\u4f60\u4e82\u78bc\uff0cdefault utf8\u7de8\u78bc\u3002 \u6628\u5929P Project pending \u4e2d\uff0c\u5c31\u5728\u516c\u53f8\u7528AppServ \u6a21\u64ec\u8d77\u8cc7\u6599\u5eab\u7684\u8f49\u63db\u3002 1. \u9996\u5148\uff0c\u5148\u5b89\u88dd2.4.4a AppServ, \u628a\u4e4b\u524d\u7684\u8cc7\u6599\u5eab\u639b\u9032\u53bb, \u9810\u8a2d\u61c9\u8a72\u662flatin \u7de8\u78bc 2. \u4f7f\u7528teatime \u7db2\u7ad9\u7684urf8.php \u628a\u4e4b\u524d\u7684phpbb2 \u7684\u8cc7\u6599\u5eab\u540d\u7a31, mysql ID\/PW key in \u4e0a\u53bb 3. php urf8.php urft.sql \u9019\u500b\u52d5\u4f5c\u662f\u628a\u4e4b\u524d\u7684phpBB2 export \u51fa\u6210sql \u8a9e\u6cd5\uff0c\u5176\u4e2d\u4e00\u958b\u59cb\u5b9a\u7fa9\u7528utr8 \u7de8\u78bc\uff0c\u57f7\u884c\u6703\u628a\u4e4b\u524d\u7684table \u6d88\u9664\uff0c\u7136\u5f8c\u5728\u9935\u9032\u53bb\u4e4b\u524d\u5f97\u8cc7\u6599 4. \u5b89\u88dd2.5.9 AppServ \u958b\u65b0\u7684database(phpbb2), \u7de8\u78bc\u9078\u7528utf8-generic \uff08\u9078\u4e86utf8-unicode … Continue reading phpBB2 big5 -> smf utf8<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-860","post","type-post","status-publish","format-standard","hentry","category-daily"],"_links":{"self":[{"href":"http:\/\/www.banbanli.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/860","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.banbanli.net\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.banbanli.net\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.banbanli.net\/blog\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/www.banbanli.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=860"}],"version-history":[{"count":3,"href":"http:\/\/www.banbanli.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/860\/revisions"}],"predecessor-version":[{"id":862,"href":"http:\/\/www.banbanli.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/860\/revisions\/862"}],"wp:attachment":[{"href":"http:\/\/www.banbanli.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=860"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.banbanli.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=860"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.banbanli.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=860"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n2. \u4f7f\u7528teatime \u7db2\u7ad9\u7684urf8.php \u628a\u4e4b\u524d\u7684phpbb2 \u7684\u8cc7\u6599\u5eab\u540d\u7a31, mysql ID\/PW key in \u4e0a\u53bb
\n3. php urf8.php urft.sql<\/code> \u9019\u500b\u52d5\u4f5c\u662f\u628a\u4e4b\u524d\u7684phpBB2 export \u51fa\u6210sql \u8a9e\u6cd5\uff0c\u5176\u4e2d\u4e00\u958b\u59cb\u5b9a\u7fa9\u7528utr8 \u7de8\u78bc\uff0c\u57f7\u884c\u6703\u628a\u4e4b\u524d\u7684table \u6d88\u9664\uff0c\u7136\u5f8c\u5728\u9935\u9032\u53bb\u4e4b\u524d\u5f97\u8cc7\u6599
\n4. \u5b89\u88dd2.5.9 AppServ \u958b\u65b0\u7684database(phpbb2), \u7de8\u78bc\u9078\u7528utf8-generic \uff08\u9078\u4e86utf8-unicode \u5728\u8f49\u63dbsmf \u6703\u6709\u554f\u984c\uff09\ufe4d
\n5. \u5230\u7af9\u8c93\u661f\u7403download utf8 \u7248\u76842.0.19\uff0c\u7136\u5f8c\u9032\u884c\u5b89\u88dd
\n6. mysql -u root -p phpbb2 < utf8.sql<\/code> \u628a\u525b\u525b\u8f49\u597d\u7684\u8cc7\u6599\u5eab\u5305\u542bsql \u8a9e\u6cd5\uff0cimport \u5230\u8cc7\u6599\u5eab\u88e1\u9762\uff0c\u9019\u908a\u82b1\u4e86\u6211\u883b\u591a\u7684\u6642\u9593\uff0c\u4e3b\u8981\u662f\u4e4b\u524d\u704c\u4e86calendar \u5916\u639b\uff0c\u4ed6\u4fee\u6539\u4e86\u4e0d\u5c11default \u7684table \u67b6\u69cb\uff0c\u9020\u6210\u5728import \u7684\u6642\u5019\u51fa\u73fe\u4e86\u883b\u591a\u7684\u932f\u8aa4\uff0c\u9700\u8981\u624b\u52d5\u4fee\u6539
\n7. \u4fee\u6539phpbb2\/db\/mysql4.php \u88e1\u9762\u7684 if( $this->db_connect_id ) \u4e4b\u524d\u52a0\u5165,
\n@mysql_query(\"SET NAMES utf8\",
\n$this->db_connect_id);<\/code>
\n8. download smf \u4e3b\u7a0b\u5f0f\u4e26\u5b89\u88dd
\n9. download phpBB2 convert.php \u4fee\u6539\u5be6\u969b\u4e0a\u5f97\u4f4d\u5740\uff0c\u9078utf8
\n10. done \ud83d\ude00<\/p>\n
\nhttp:\/\/phpbb-tw.net\/phpbb\/
\nhttp:\/\/phorum.study-area.org\/index.php?topic=39353.0
\nhttp:\/\/www.simplemachines.org\/<\/p>\n","protected":false},"excerpt":{"rendered":"