UTF-8 and Wordpress 2.2.x
There’s a utf-8 problem brewing quietly in the self-hosted Wordpress world—particularly among those that have been running for a while now.
My Digital Life explains in detail about the problem I experienced (see also the Trac and the Codex) and a (temporary) workaround—this worked for me, by the way. But if you’re not a fan of latin1 character set and associated latin1_swedish_ci collation, then I’d recommend this UTF-8 database converter plugin. Run once, it’s painless—this worked for me too, except for non-english characters (like if you used the caret ones natively in posts and or pages).
Remember to backup before you do any of these.