Twitter

So cold today... and the trains are running fine :O 20 mins ago

Oh my god its been so long since I've been on the tube, forgotten all the routes. 15 hrs ago

Why why WHY did they take out the majority of the computers in the Library? It's impossible to get one. #RAGE #lunchtime 17 hrs ago

Follow me @fatjoe151
Hello there . This post is over 60 days old. Any comments made here are unlikely to get a response due to its age, however, give it a go if you wish.
Gravatar
Home » SouthanUK News » Viewing single Post

Well that was weird – WordPress encoding

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.



Add to:              

Adverts

Leave us a comment!

No need to register, click Facebook Connect to use your Facebook account, or "Twitter" use your twitter account!
If you dont feel like using them, don't worry, just post as a Guest