Update RC1 to RC3 ERROR (question marks)

[Diman_UA]

Hello
Very long plagued with problems of translation forum from version RC1 to RC3.
At RC1 appears everything is fine, but when to upgrade, once in smf_boards some question marks instead of category names.
People under the avatars too mess (some question marks), but the messages remain in the normal form.
How to solve the problem? Need urgent transfer to the new version, but these errors.
Thank you

$ Db_character_set = 'utf8'; / / is not the case, the upgrade has changed the structure of tables and that has changed has changed encoding.
Encoding database latin1_swedish_ci, and where question marks utf8_general_ci and how to get it all?

sorry for my bad english, i'm from Ukraine

[Alex' Manson]

i think you should use a english utf8 of  a fresh SMF RC3?
thats what i guess, well not sure but 60% sure, maybe someone else is better than me but try doin what i said + backup the file first!

[JimM]

You can change the collation of the database in phpMyAdmin.  You will need to convert each table with something like the following querry:

Code Select Expand

ALTER TABLE table CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

You might try searching Google for how to change collation using phpMyAdmin.