Feb 19, 2011, 07:56 PM
h’i “test”
? ?_?
Hmm looks like the display issue is fixed now too. Thanks for bringing this up (I know others have and thanks to them too).
Edit:
To anyone coming across this thread by searching, the problem came up after switching web servers. I believe this changed the default character set mysql was using. I converted all of the relevant phpbb/nuke tables (posts, search, private messages) to the new default collation (see the mysql collation_ variable) which was utf8_general_ci and previously latin1_swedish_ci. You have to convert the table, and not just set the default. When I converted, I ended up with duplicate keys in the wordlist table. I resolved this by temporarily closing the forum, dumping the data, dropping the table, and reinserting it using INSERT IGNORE with no collation specified (so that it would use the default).
I also changed languages/lang-english.php to define _CHARSET as UTF-8.
? ?_?
Hmm looks like the display issue is fixed now too. Thanks for bringing this up (I know others have and thanks to them too).
Edit:
To anyone coming across this thread by searching, the problem came up after switching web servers. I believe this changed the default character set mysql was using. I converted all of the relevant phpbb/nuke tables (posts, search, private messages) to the new default collation (see the mysql collation_ variable) which was utf8_general_ci and previously latin1_swedish_ci. You have to convert the table, and not just set the default. When I converted, I ended up with duplicate keys in the wordlist table. I resolved this by temporarily closing the forum, dumping the data, dropping the table, and reinserting it using INSERT IGNORE with no collation specified (so that it would use the default).
I also changed languages/lang-english.php to define _CHARSET as UTF-8.