I have just upgraded my wordpress installation from the legacy 2.0.11 (which was stable and officially supported until very recently) to 2.8.4 in one fell swoop by following the steps in the wordpress codex. There appeared to be only a few glitches that were relatively quickly ironed out and everything seemed to be running fine. Until I noticed several stray Âs in some of the older posts. And Ã»s instead of üs, Ã©s instead of és, Ã¢s instead of âs, etc. etc.
I looked in SQL and see that I have two different character sets for the tables in the wordpress database: latin1_swedish_ci collation and utf-8 collation labels
Unfortunately, I am not comfortable to just go ahead and change the tables to utf-8; I only know enough about SQL to get myself in trouble.
Alas, the wordpress "guide" is not written in layman's terms, except for this phrase in the opening paragraph: "character set conversion is not a simple process". And the official wordpress forums are pretty much useless because they are filled with people like me - the blind leading the blind. Luckily, someone has attempted a translation elsewhere:
Originally Posted by mydigitallife.info
This is EXACTLY what happened to me (thank goodness for copies of database backups kept in separate folders!)
In the Guide to Convert WordPress Database Character Set to UTF8, it says:
I've asked the following question in mydigitallife.info forum, but the thread is dated 2007, so the question may be overlooked. I am hoping that someone here will help.Originally Posted by mydigitallife.info
What exactly do I look for in phpMyAdmin to find out if fields belong to indexes or FULLTEXT indexes?
EMorris, etherwork.net/blog/ (URL unlinked, in the interests of keeping spammers at bay as much as possible)
WinXP, firefox, SQL 4.1.21-log, PHP 5.2.8, Apache 1.3.37 (Unix)
screenshot of what I see in phpMyAdmin at flickr.com/photos/etherwork/3936558945/sizes/o/
(I am reluctant to simply dive in and hope for the best, having already very recently restored wordpress from a backup after a disastrous result from running the wordpress plugin to Convert WordPress Database Character Set.)