Wordpress UTF8 chars fix - search & replace

utf8_bodge.sql

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_title = REPLACE(post_title, '“', '“');
UPDATE wp_posts SET post_title = REPLACE(post_title, '”', '”');
UPDATE wp_posts SET post_title = REPLACE(post_title, '’', '’');
UPDATE wp_posts SET post_title = REPLACE(post_title, '‘', '‘');
UPDATE wp_posts SET post_title = REPLACE(post_title, '—', '–');
UPDATE wp_posts SET post_title = REPLACE(post_title, '–', '—');
UPDATE wp_posts SET post_title = REPLACE(post_title, '•', '-');
UPDATE wp_posts SET post_title = REPLACE(post_title, '…', '…');

UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, '“', '“');
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, '”', '”');
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, '’', '’');
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, '‘', '‘');
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, '—', '–');
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, '–', '—');
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, '•', '-');
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, '…', '…');

UPDATE wp_terms SET name = REPLACE(name, '“', '“');
UPDATE wp_terms SET name = REPLACE(name, '”', '”');
UPDATE wp_terms SET name = REPLACE(name, '’', '’');
UPDATE wp_terms SET name = REPLACE(name, '‘', '‘');
UPDATE wp_terms SET name = REPLACE(name, '—', '–');
UPDATE wp_terms SET name = REPLACE(name, '–', '—');
UPDATE wp_terms SET name = REPLACE(name, '•', '-');
UPDATE wp_terms SET name = REPLACE(name, '…', '…');

UPDATE wp_termmeta SET meta_value = REPLACE(meta_value, '“', '“');
UPDATE wp_termmeta SET meta_value = REPLACE(meta_value, '”', '”');
UPDATE wp_termmeta SET meta_value = REPLACE(meta_value, '’', '’');
UPDATE wp_termmeta SET meta_value = REPLACE(meta_value, '‘', '‘');
UPDATE wp_termmeta SET meta_value = REPLACE(meta_value, '—', '–');
UPDATE wp_termmeta SET meta_value = REPLACE(meta_value, '–', '—');
UPDATE wp_termmeta SET meta_value = REPLACE(meta_value, '•', '-');
UPDATE wp_termmeta SET meta_value = REPLACE(meta_value, '…', '…');

UPDATE wp_term_taxonomy SET description = REPLACE(description, '“', '“');
UPDATE wp_term_taxonomy SET description = REPLACE(description, '”', '”');
UPDATE wp_term_taxonomy SET description = REPLACE(description, '’', '’');
UPDATE wp_term_taxonomy SET description = REPLACE(description, '‘', '‘');
UPDATE wp_term_taxonomy SET description = REPLACE(description, '—', '–');
UPDATE wp_term_taxonomy SET description = REPLACE(description, '–', '—');
UPDATE wp_term_taxonomy SET description = REPLACE(description, '•', '-');
UPDATE wp_term_taxonomy SET description = REPLACE(description, '…', '…');