turned out some of the database tables were using latin_swedish_ci as character set instead of the default utf8...reason: unknown.
when trying to fix it I googled a lot but no real help to find, so here are the queries needed to fix the database by converting it to utf8, and to replace the broken symbols:
Code: Select all
ALTER TABLE wp_posts CONVERT TO CHARACTER SET utf8;
UPDATE wp_posts SET post_content = REPLACE(post_content, '“', '“');
UPDATE wp_posts SET post_content = REPLACE(post_content, 'â€', '”');
UPDATE wp_posts SET post_content = REPLACE(post_content, '’', '’');
UPDATE wp_posts SET post_content = REPLACE(post_content, '‘', '‘');
UPDATE wp_posts SET post_content = REPLACE(post_content, '—', '–');
UPDATE wp_posts SET post_content = REPLACE(post_content, '–', '—');
UPDATE wp_posts SET post_content = REPLACE(post_content, '•', '-');
UPDATE wp_posts SET post_content = REPLACE(post_content, '…', '…');
UPDATE wp_posts SET post_content = REPLACE(post_content, 'Â ', ' ');
UPDATE wp_posts SET post_content = REPLACE(post_content, 'Â', '');