Is there any definitive guide to solve encoding/character set problems with WordPress? I have a couple of dozen sites and many of them have the same problems. For example characters display fine on the site but are messed up in the database. For example the character é is displayed in the db as Ã©. Also if I do an export of the db the characters are messed up the same way.
I have read every single forum thread about this. The codex pages are quite confusing as well, even for me as a webdesigner/developer.
These codex pages are unclear and contain all kinds of warnings (rightly so)
In the forum threads there are some plugins mentioned, but I've read enough bad experiences about them not to try them yet. And most of them are outdated (wp 2.1). The problem is also that even if you use something like phpMyAdmin, looking at the db tables you never know what you're looking at. There's all kinds of layers/steps in getting the "raw" data out of the db onto your screen, at each step some wrong conversion can take place, etc.
I just want to know a few things:
1) what character encodings do I have for REAL in my databases?
2) if not in UTF-8, what to do to get it that way?