Fixing Entries

Tuesday, June 3rd, 2008 | Quickie, WordPress |

A recent visitor to the CB pointed out a problem on some of my older entries. It's something I was expecting to have to fix but got sidetracked and never got around to. Basically with the upgrade to WordPress 2.5.x, there are a couple of new settings in the wp_config.php file which have WordPress to use UTF-8 character encoding to better handle non-English langauges/characters. However as older versions of WordPress automatically converted standard quotes/astrophes to their fancy/curly versions and those fancy versions are dependent upon which character encoding scheme they are written in. Since I wasn't sure how many entries I had that are affected by this and I wanted to leave the UTF-8 encoding enabled; I ran this SQL query to fix at least some of the problems: UPDATE wp_posts SET post_content = REPLACE(post_content,''','\'') WHERE post_content LIKE '%'%';

There are probably other characters I need to fix yet, so if you happen to see something like hieroglyphics on this site or other gibberish, let me know what entries you found it on so I can fix them. And my thanks to Lynsey for prompting me to fix these entries.

Tags: Encoding, MySQL, WordPress