We are currently upgrading the infrastructure of the .org community. We appreciate your patience as some features may be disabled or not working temporarily. More details here
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 · ·