pluby
The Architect
Joined: Jun 16, 2003
Posts: 11949
|
 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.
Patrick |
|
