Well that was weird – WordPress encoding

SouthanUK General No Comments

Seems the site decided it was time that it shouldn’t encode the site properly.

utf8-whatisthat

Since Southanuk is a relatively old WordPress installation [Around 2006] it was using an old character set, namely latin_1. Converted it to UTF8 and all is now good and properly displaying. Have a few celebratory ‘ , – s.

 

For others having the same problem with WordPress not encoding pages properly, I recommend the bbWP2UTF8 plugin. Its very simple to use and is a lot easier than this method, although saying that, it may work if the plugin doesn’t.

[edit]

Well something went wrong very shortly after I had posted this, post numbers weren’t auto-incrementing. Should be all fixed. Also discovered a very nice MySQL command to help convert those troublesome characters to UTF8:

update DBNAME

set ROWNAME = replace(ROWNAME,'’','\'');

update DBNAME

set ROWNAME= replace(ROWNAME,'…','...');

update DBNAME

set ROWNAME= replace(ROWNAME,'–','-');

update DBNAME

set ROWNAME= replace(ROWNAME,'“','"');

update DBNAME

set ROWNAME= replace(ROWNAME,'â€Â','"');

update DBNAME

set ROWNAME= replace(ROWNAME,'‘','\'');

update DBNAME

set ROWNAME= replace(ROWNAME,'•','-');

update DBNAME

set ROWNAME= replace(ROWNAME,'‡','c');

[Source]

GEF follows shortly and possibly something on Monday if I can get it to work.