Character encoding problem after moving from Vanilla 1 to Vanilla 2
I migrated my forum from Vanilla 1 to Vanilla 2. I used the vanilla2export.php to move the data over. Previous non-ASCII data is no longer displaying correctly
. It showed fine in Vanilla 1.
My tables are UTF-8. I can see the correct data when using an SQL client in UTF-8 mode. The data shows up the same way in the Vanilla 2 tables as it did in the Vanilla 1 tables. Additionally, the non-forum part of my site also does UTF-8 correctly.
When I add a new comment that includes non-ASCII characters, it shows up correctly on the forum, but incorrectly in the SQL client.
My pages are being with HTTP headers specifying UTF-8. I've seen this page
, which says that there are various settings for character encoding. It's for Vanilla 1, but looking at my config files, I see that I have no character-encoding-related settings in config.php, and config-default.php has:
$Configuration['Database']['CharacterEncoding'] = 'utf8';
$Configuration['Database']['ExtendedProperties']['Collate'] = 'utf8_unicode_ci';
$Configuration['Garden']['Charset'] = 'utf-8';
What do I need to do to make this work right?
0 · ·