Let me tell you my story... I was having an issue with Â char visible within the post's content. Instead of editing each one, I was passing a simple query:
UPDATE wp_posts SET post_content = REPLACE( post_content, binary 'Â', '' );
Everything was fine so far, however, after adding new posts the issue was back again, so I thought trigger would be the key! So I've written one as follows:
CREATE TRIGGER watch_posts AFTER INSERT ON wp_posts FOR EACH ROW UPDATE wp_posts SET post_content = REPLACE( post_content, binary 'Â', '' );
From this point within most of the posts I'm having now blank edit page where word count is equal to 0. But the database still consist of post_content which is not empty. How to prevent existing posts to not be blank anymore?