Processing Space

I got tired of using EUC. Not the encoding’s fault really. Just that my editor doesn’t edit in EUC and that’s not its fault either. It’s probably because I didn’t install the codepage on my system. Well, it was easier to ask WordPress to display SJIS instead of EUC than for me to install EUC, so I went in and changed my config….

Well, I was wrong (happens more often than I’d like). WordPress stores multibyte text (you know, like 日本語) in the effective encoding at the time of posting, and when I just change my config and settings, the encoding of these text aren’t converted. That’s reasonable for WordPress, but doesn’t help me since now my pages look like I go into temporary insanity and scribble gibberish (ex. ¤ÎÀ¤³¦¤) every once in awhile.

To make matters worse, these text make some WordPress admin pages unusable since the gibberish interferes with the markup in the pages. The very pages I need to fix my problem are crippled !

As a last resort before reformatting my hard drive, which is the way I solve most of my PC problems, I decided to try to clean up the rebelling text in the database (MySQL).

My luck was unbelievable. It worked ! My harddrives sighed relief. My pages now look like they are written by a sane person. This anal author rejoices in the knowledge that his text are now safely stored and displayed to millions in SJIS.

This entry was posted on 2005/10/8 Saturday at 9:32 am and is filed under Playing with technology. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.