Wednesday 10 July 2013

Problem with  in Posts in Wordpress

I haven't got this one fully sorted yet.  As I importing and exporting in UTF-8; why I'm still getting these  values is still beyond me.  If anyone reading this can point me in the right direction that'd be much appreciated.

However in the meantime the MySQL commands below are useful for cleansing the blogs

UPDATE wp_posts SET post_content = REPLACE(post_content, 'Â', '');
UPDATE wp_posts SET post_title = REPLACE(post_title, 'Â', '');
UPDATE wp_posts SET post_content = REPLACE(post_content, '˜', '');
UPDATE wp_posts SET post_title = REPLACE(post_title, '˜', '');
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, 'Â', '');

No comments: