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...