[其它] 佬舊MYSQL4.0轉移MYSQL5(UNICODE)

ENIX.DQ

first,use mysqldump to dump database -->database.sql

mysqldump -uroot -p databasename >database.sql


second,convert your database.sql to UNICODE

USING ConvertZ with an usful LIST to solve MR."許功蓋"
(if you are using Windows)

you can get a new file(database-utf8.sql) that encoding by utf8

finally~ restore it to your new database!

mysql -uroot -p --default-character-set=utf8 databasename < database-utf8.sql

ENIX.DQ

phpBB升級UNICODE

before start,plz make sure you have "convertZ".

first,convert all language(.php) file to utf-8
and replace the "big5" to "utf-8" in all language file

then,open this file"./include/db.php"
add this

$db-&gt;sql_query("SET NAMES utf8;");
$db-&gt;sql_query("SET CHARACTER_SET_CLIENT=utf8;");
$db-&gt;sql_query("SET CHARACTER_SET_RESULTS=utf8;");

before " ?&gt; "

finish!