SMF Forum Special character issues: Mixed database latin1 + utf8

Asked Dec 25 '22 at 03:59

Active Dec 25 '22 at 03:59

Viewed 38 times

I recently recovered from a backup an SMF forum which has half its database in latin1 and the other half in utf8 encoding.

I edit Settings.php

'''
Code Select
######### Legacy Settings #########
# UTF-8 is now the only character set supported in 2.1.
$db_character_set = 'utf8';
'''

Half the forum displays fine

and

''''
Code Select
######### Legacy Settings #########
# UTF-8 is now the only character set supported in 2.1.
$db_character_set = 'latin1';
''''

The other half.

I've tried fixing this on phpmyadmin but failed.

asked Dec 25 '22 at 03:59

divinem

There are many things that can go wrong. Let's start by doing `SELECT col, HEX(col) ...` to get a sample of the non-ASCII text in selected columns. Then see "best practice" in https://stackoverflow.com/questions/38363566/trouble-with-utf8-characters-what-i-see-is-not-what-i-stored . After that, I'll help guide into what to do next. The fear is that your attempt to "fix" the problem actually compounded the problem. – Rick James Dec 26 '22 at 23:53

0 Answers0