Funny Latin characters got pasted into some of the posts, no this wasn’t an straight forward UTF-8 / Latin encoding issue.

This is how I got rid of them.

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,’‡’,'c’) ;
update wp_posts
set post_content= replace(post_content,’Â’,”) ;

This entry was posted on Monday, December 14th, 2009 at 12:01 pm and is filed under Wordpress. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

No Responses