Removendo caracteres estranhos do wordpress

Problemas de codificação de caracteres são um tanto comuns e muito chatos de serem resolvidos. Eu, ainda bem, não me deparei ainda com isso, mas você pode ter esse problema. Então vai um trecho de código para resolver esse problema:

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_comments SET comment_content = REPLACE(comment_content, ‘â€œ’, ‘“’);

UPDATE wp_comments SET comment_content = REPLACE(comment_content, ‘â€’, ‘”’);

UPDATE wp_comments SET comment_content = REPLACE(comment_content, ‘â€™’, ‘’’);

UPDATE wp_comments SET comment_content = REPLACE(comment_content, ‘â€˜’, ‘‘’);

UPDATE wp_comments SET comment_content = REPLACE(comment_content, ‘â€”’, ‘–’);

UPDATE wp_comments SET comment_content = REPLACE(comment_content, ‘â€“’, ‘—’);

UPDATE wp_comments SET comment_content = REPLACE(comment_content, ‘â€¢’, ‘-‘);

UPDATE wp_comments SET comment_content = REPLACE(comment_content, ‘â€¦’, ‘…’);