Script did not worked good if I converted latin1 to utf8. Only worked good if I converted utf8 to latin1 and then back to utf8
I fixed the script and added one extra config:
http://code.google.com/p/xuups/downloads/detail?name=dbupdate_1.1.zip
I also noticed that my instructions were incorrect, please test it as follows:
Place the dbupdate.php on your XOOPS root (same directory as mainfile.php);
Edit the file and change the config settings(if needed):
//START CONFIG
$doBinary = false; //If updated strings are not readable, try set this to 'true'
$old_charset = 'latin1';
$old_collation = 'latin1_swedish_ci';
$new_charset = 'utf8';
$new_collation = 'utf8_general_ci';
//END CONFIG
Point your browser to dbupdate.php and execute it
You should get a page with SQL statements.
Open phpmyadmin and select your XOOPS database.
Open SQL tab and enter the statements you got from dbupdate.php
Execute.
Wait, may take some time if database is to big.
Now your database should have been migrated. Look at your tables and check if fields content are readable.
Edit your mainfile.php(xoops < 2.5) or xoops_data/data/secure.php(xoops > 2.5) and define XOOPS_DB_CHARSET accordingly
Your language files will have to be updated to the new charset also. If you don't have utf8 language files, change your language to english.
See if content is readable.
If not, upload your database backup, set option $doBinary = true, and repeat the steps.
Report back, please.
