See if this works:

Moved below the fold, lest you just really want to see me playing with quotes. Thanks to Matt

Matt emailed:

My problem was that the wp_posts table and all the fields under it were set to latin1_swedish_ci (it’s the default the database likes to create). WordPress operates on utf8. So Worpress expects it to be set to utf8_general_ci and so some special characters entered into the latin1 turn into question marks.

The fix for me was to go into phpMyAdmin and change the wp_posts table to utf8_general_ci and then change the collation for the fields themselves inside wp_posts to all say utf8_general_ci. It did not fix the question marks already there, since the orginial characters were lost in the first posting. However all new posts show up correctly.

Did not seem to fix it. Now, all text after a quote disappears.

Update:

‘test’

“test”

Host Senator Jim Kyle has just announced that Democratic Leadership Council Chair Harold Ford will join his “Nashville Conversation” patterned on the DLC’s “National Conversation”, the latest of which was held in Nashville.

Update: Cool, this worked:

1) Open wp-config.php;
2) Find:

define(‘DB_CHARSET’, ‘utf8’);
define(‘DB_COLLATE’, ”);

3) Change it to:

/*define(‘DB_CHARSET’, ‘utf8’);
define(‘DB_COLLATE’, ”);*/

Posted in uncategorized on October 1st, 2008 by SayUncle | RSS 2.0 |