CoffeeBear.net

Fixing Entries

Posted by Mark | Filed under Quickie, WordPress

A recent vis­i­tor to the CB pointed out a prob­lem on some of my older entries.  It’s some­thing I was expect­ing to have to fix but got side­tracked and never got around to.  Basi­cally with the upgrade to Word­Press 2.5.x, there are a cou­ple of new set­tings in the wp_config.php file which have Word­Press to use UTF-8 char­ac­ter encod­ing to bet­ter han­dle non-English langauges/characters.  How­ever as older ver­sions of Word­Press auto­mat­i­cally con­verted stan­dard quotes/astrophes to their fancy/curly ver­sions and those fancy ver­sions are depen­dent upon which char­ac­ter encod­ing scheme they are writ­ten in.  Since I wasn’t sure how many entries I had that are affected by this and I wanted to leave the UTF-8 encod­ing enabled; I ran this SQL query to fix at least some of the prob­lems: UPDATE wp_posts SET post_content = REPLACE(post_content,''','\'') WHERE post_content LIKE '%'%';

There are prob­a­bly other char­ac­ters I need to fix yet, so if you hap­pen to see some­thing like hiero­glyph­ics on this site or other gib­ber­ish, let me know what entries you found it on so I can fix them.  And my thanks to Lynsey for prompt­ing me to fix these entries.

Similar Posts

• Updates via nagging…
  This post was brought to you via the nagging of Pukka. That's right Pukka; this post's for you. :p S ...
• Welcome to CB.net!
  Hi, I'm Mark (aka Manzabar1). If you want to know more about me; well, you'll just have to keep read ...
• Bored at Work
  I'm sitting here waiting for the program I'm testing to finish processing some data that I threw at ...
• 5 Days and counting.…
  Just 5 days away from flying off to a foreign country for the first time. :) Oh and I am working on ...
• VectorLover 2 — Initial Release
  As previously mentioned, I've been working on updating and customizing the VectorLover WordPress the ...