How can I replace corrupted punctuation? WordPress

• SOLVED

I recently uploaded a back-up file when I accidentally deleted an important page on my wordpress website. I then updated Wordpress to 3.0.4. I am using Frugal.

Everything seemed fine but then I noticed all my apostrophes had been replaced by ’ and an ü by ü
"Glück's" has become Glück’s!

It only happens on old posts but you can imagine that there are a lot to replace.

I found a seeming solution on Google but that was for an old version of Wordpress.
http://wordpress.org/support/topic/apostrophes-replace-with-ae%E2%84%A2-after-upgrading-to-25?replies=3

Is there a way to override this and fix the corrupted typing?

Yours Hopefully
Heather

Answers (3)

2011-02-07

Nick Parsons answers:

I had a similar issue in the past, which I was able to solve by using the [[LINK href="http://wordpress.org/extend/plugins/wp-utf8-sanitize/"]]UTF8 Sanitize Plugin[[/LINK]].

I'd recommend giving that a try.

2011-02-07

Rashad Aliyev answers:

Hello,

What about your charset? Be sure you've this code below on your wp-config.

define('DB_CHARSET', 'utf8');

2011-02-09

Peter Michael answers:

Are these umlauts already messed up in the backup file i.e. stored in the DB like your example?