Welcome to NeoOffice developer notes and announcements
NeoOffice
Developer notes and announcements
 
 

This website is an archive and is no longer active
NeoOffice announcements have moved to the NeoOffice News website


Support
· Forums
· NeoOffice Support
· NeoWiki


Announcements
· Twitter @NeoOffice


Downloads
· Download NeoOffice


  
NeoOffice :: View topic - Character encoding issues in past forum posts
Character encoding issues in past forum posts
 
   NeoOffice Forum Index -> Server Outages
View previous topic :: View next topic  
Author Message
pluby
The Architect
The Architect


Joined: Jun 16, 2003
Posts: 11949
PostPosted: 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
Back to top
Display posts from previous:   
   NeoOffice Forum Index -> Server Outages All times are GMT - 7 Hours
Page 1 of 1

 
 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

Powered by phpBB © 2001, 2005 phpBB Group

All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © Planamesa Inc.
NeoOffice is a registered trademark of Planamesa Inc. and may not be used without permission.
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.