Upgraded to version 2.31 and get occasional "Â" letters in my posts. Anyone ever seen anything like this? I suppose it could be a wordpress plugin but it's annoying me having to go back and fix the ish lol.
It's because 2.3.1 changed the database format to UTF-8. There were a few fixes posted at wordpress.org, including two scripts, one of which was a dead link. None of the fixes worked for me, although I did get my tables all upgraded to UTF-8. In the end, I went through the posts manually, category by category, finding those with odd characters and manually editing those posts. Downgrading really isn't a solution since all future upgrades are going to be UTF-8 as well so sooner or later you're going to have to bite the bullet. Manual editing was a royal pain but it's done now for me and won't need to be redone.
Yep. I don't have "thousands" but it was still a mighty pain. I'm just reporting that I researched this over a few days and if there is a good fix for this I couldn't find it.
I was wondering wht that was happening. I dod the same thing and fixed it manually by downing the sql database and cutting and pasting from notepad.
I manually changed them as well. Ah well, at least that means we'll be set from this point going forward though. Least the content wasn't ruined though eh?
Under the Options->Reading menu tab you will see Encoding for pages and feeds: that is set for UTF-8 I'm wondering if you change the setting to ANSI it solves the problem.
Had exactly the same problem and because I found nothing online about how to solve it, I ended up going through the posts manually just like you guys... Annoying but I guess it had to be done!
No. At least it didn't work for me. I think that tells Wordpress what to expect but by bthe time I got to that step the upgrade (seemingly) had already modified the database (although not the database settings) so changing it did nothing.
It's a simple fix as far as I know, and one I did with earlier releases. If you open up wpconfig.php in an ftp program, then change the line below, you're good to go. Change: define('DB_CHARSET', 'utf8'); To: define('DB_CHARSET', ''); So you just remove the utf8 from the brackets, and touch nothing else. Then all your special characters magically get restored. Much easier than manually going through each post.
I had this problem with a blog site and some 40 pages suffered because of it. However I fixed it the hard way