I *@£43%$ Hate Punctuation
I have now realised that the recent upgrade to WordPress 2.2 has randomly replaced 60% of the apostrophes in my entire database with garbage like this ‘.
Shite.
I have now realised that the recent upgrade to WordPress 2.2 has randomly replaced 60% of the apostrophes in my entire database with garbage like this ‘.
Shite.
June 18th, 2007 at 4:11 pm
What, you used “smart” quotes sometimes?
June 18th, 2007 at 5:23 pm
Not to my knowledge. It’s appears to be random. I generally write all my posts in plain text and paste them into the Tinymce editor in WordPress. The editor in WordPress is unpredictable, but it has never done this before. I think the upgrade from WP 2.1 to 2.2 borked the MYSQL data somehow. I think it added a sprinkling of new data that killed my apostrophes.
Perhaps it’s WordPress’ attempt to improve our punctuation. Introducing a rogue form of apostrophe that randomly mutates.
June 19th, 2007 at 3:43 am
Hmm… can you go through it more than once? I mean, has it altered the data within MYSQL? If so, then if you can gain access to that data, you can write a query to replace those characters (or at least to show you when those anomalous characters are present, so you can edit them by hand). If it hasn’t altered the data, then it’d be interesting to see what kind of a pattern exists. And you might actually replace the straight quotes with “smart” quotes pre-emptively, and see if those get mangled on the way through.
Overly interested in SQL. Sorry. New contract starting next week. Sigh.
Good luck.
June 19th, 2007 at 9:01 pm
It looks to me like your character encodings are screwed. WordPress is using UTF-8 encoding but if you’re copying and pasting from an external editor, it might be coming in different. Check the WordPress doc for stuff on encodings; like Davimack says, it’s probably easy enough to fix with a script.
June 19th, 2007 at 10:33 pm
I think you guys may have the right of it. I thought it might be UTF encodings, but to my knowledge the euro symbol isn’t used to represent apostrophes?
It’s happened to a few people who have upgraded and there’s a thread on the wordpress site, but no fix issued yet. However I found a plugin that enables you to find and replace characters or words in your database so I may give that a try.