I tested and imported one vb3.8 site to xenforo a few months ago and it went well. Then a couple of weeks ago I did another forum, but instead of putting latin1_swedish_ci in the Force Character Set field, I accidentally put $config['Mysqli'['latin1_swedish_ci'] from my notes from previous testing. It didn't work and it took 3 weeks for me to find a problem on the live site. So now I have the same problem many have run into during testing where some characters such as é now show up as Ã©. The problem is I've been live for 3 weeks so I can't go back. I thought about finding every character in latin1 that is different from utf8 (I'm guessing there are less than 150), then search the database for all affected columns. Then do a query for each column like this with all of the replacements (not just the three below): Code: UPDATE `table_name` SET `column_name` = REPLACE(`column_name` ,'Ã¡','á'); UPDATE `table_name` SET `column_name` = REPLACE(`column_name` ,'Ã¤','ä'); UPDATE `table_name` SET `column_name` = REPLACE(`column_name` ,'Ã©','é'); .... I thought there had to be a better way. After spending hours reading blogs and stackoverflow I'm hoping I found one. What I did was created a copy of the live site to a test site. In the database for the test site, I converted the column custom_fields in the table xf_user_profile from mediumblob to mediumtext, since I found out that that contents of the blob won't be converted with the next steps because they are already stored as binary. Then I did a database dump on the test db forcing the character set to latin1 like this: Code: mysqldump -u username -p --opt --quote-names --skip-set-charset --default-character-set=latin1 database > fix_char.sql Then import the backup to the test db with utf8 Code: mysql -u username -p --default-character-set=utf8 database < fix_char.sql Then convert the column custom_fields in the table xf_user_profile back to mediumblob. I need to do a lot more looking around and testing on the test site, but it seems to have worked. Is there anything I'm missing? Has anyone done this before with success? Anything I should worry about or look into before trying the fix on the live site? Is there a reason that xf_user_profile is stored as a binary that I might be messing up with this process? Thanks in advance!