Migrating from Mysql 4.0 to Mysql 5.0

[len]

Hello,

I am migrating my mantis installation from mysql 4.0 to mysql 5.0. My database contains french characters. I started by experimenting problems with the database. All the database seemed to be trunked to the first non-ascii character found. I managed to solve this problem by using iconv to convert the database dump as in:

iconv -f latin1 -t UTF-8 mantisbt.sql > mantisbt-utf8.sql

and then importing this dump but still the characters are not displayed ok. I tried the method for changing the database_api.php file with no luck. Any ideas?

Thank you,
Len

[len]

Finally I found the solution as the problem was not related to the database but the page encoding and it sufficed to change the files lang/strings_english.txt and the others by replacing

$s_charset = "windows-1252";
with:
$s_charset = "UTF-8";

I described all my steps here http://www.len.ro/work/tools/migrating- ... -0-to-5.0/

Hope it helps.