need help migrating to utf8

[plongeur.com]

Hi,

I have charset issue on my vbulletin installation. I don't know what i did wrong during the upgrade from 3.0 to 5.2.5 but it seems i ended up with a DB that is partly in Latin1 and partly in UTF8.

I tried several things but it never ended up working as expected.

Is there anyone who could have a look and find a solution to migrate the whole forum to utf8 ? this could be paid service of course but i am on a budget :)
Does anyone know a reliable service that could help me ?

Best regards.

[TheLastSuperman]

I would:

Copy the database in phpmyadmin via operations tab, this is your backup now ;).
Next edit the collation on the tables in question from latin to utf8.


Do this one-by-one on the tables checking the site each time.

If anything goes wrong simply change the last tables collation back to what it was prior and continue.


If you really mess up guess what? You made a backup before beginning haha so simply:
- Rename the current database to "samename_bak" or samename_bkp etc.
- Rename the copy you made before back to the same name of the main database.
- Assign the same database user listed in your config.php file to the copy you just renamed to the main database name - grant all privileges as well. Now your forum is fixed and back to square one.

[plongeur.com]

Well, i don't have a copy because everything seemed to be working OK so i went live.
It is still mostly working but i have issues with special characters in logins and passwords and in some case (comments for instance).

I tried dumping the DB and reinporting it, changing collation of all tables, etc... it never worked and i can't figure out why...