Tag Archives: Wordpress

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.

Southanuk Mobile – WPTouch and Android

So recently you may have noticed I bought myself a brand new HTC Desire. Since then I’ve been striving to get this site to display properly in the web browser.

 

SouthanukAndroid

To achieve this I used the fantastic WPTouch made by BraveNewCode. A very simple and easy to use plugin that requires hardly any configuration. Its very easy to add new user agents of websites I wanted to target and looks great too! You can also integrate your Twitter account into it using their other plugin WordTwit [Unfortunately I don’t use that on this blog, but I’m sure its up to the standard of WPTouch.]

 

To try it out on your mobile device, point your camera to this QR code and give it a scan, or just enter m.southanuk.co.uk to view it also.

[qrcodetag]http://m.southanuk.co.uk[/qrcodetag]