Joined: Jun 16, 2003 Posts: 11856 Location: California, USA
Posted: Sun Nov 10, 2013 6:33 pm Post subject: Character encoding issues in past forum posts
Earlier today I noticed that as a result of moving to a new server, non-ASCII characters in posts and private messages are displayed as a � character.
I have found the cause of the problem: we are using a slightly newer version of the PHP web programming language and in that newer version the PHP developers changed the default encoding of strings from ISO-8859-1 to UTF-8.
To fix this problem, I pulled the database offline for that last half hour, made a full backup of the database, and reimported the entire database as UTF-8 using MySQL's built-in character encoding conversion utilities.
AFAICT, the character encoding conversion looks correct. But I only checked my posts the contained the Euro, pound, and yen symbols. So, if anyone sees any old posts with a � character, please post a link to the posts and I will manually reconvert the posts from our backups.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum