I just upgraded from WP 2.2.2 to 2.7 using incremental upgrades. WP 2.7 seems to be working fine. My only problem is that special characters are not displaying properly. In my old WordPress, the characters displayed fine whether I used straight quotes or curly quotes in the original posts. Now curly quotes and apostrophes, copyright symbols, etc. that used to display fine in previous pages and posts are no longer displaying correctly.
Example: A curly starting quote in the original now displays as 'â€œ'. A curly ending quote in the original now displays as 'â€'. An apostrophe displays as 'â€™'. A dash dipslays as 'â€“'.
Looking through the other posts on this forum, it seems that other people are also having trouble with special characters - something to do with Collate function in the database?
I checked my wp-config.php file and it has the following:
/** MySQL hostname */
/** Database Charset to use in creating database tables. */
/** The Database Collate type. Don't change this if in doubt. */
I checked my Database in phpMyAdmin, and my database collation is: "latin1_swedish_ci" (I don't remember seeing that before). I selected the database, selected "Operations," and under "Collation" at the bottom, I selected "utf8_general_ci", and pressed "Go." I went back to the database table, and the SUM at the bottom of the Collation column now says ""utf8_general_ci" but all the individual tables still say "latin1_swedish_ci".
I checked my blog and the special characters still do not display. Here is an example page: http://www.rayfowler.org/sermons/god-so-loved-the-world/ (Sorry it is a sermon, I am not trying to preach to you guys, but all my problem pages are sermons that I copied and pasted into the blog from Microsoft Word. They used to display fine, but now they are not with the new upgrade to 2.7)
Am I on the right track here, and if so what do I do next to fix this? Or if I am on the wrong track, can someone put me on the right track? Thanks.