[wp-hackers] Character Encoding Hell (and filtering /n to <p>)

[Ryan Boren]

On Jan 8, 2008 8:43 AM, Andre SC <andre at pixelplexus.co.za> wrote:
> Dunno if this will help. I've had reports of similar issues with
> aStickyPostOrderER from a user using it on a Hebrew language blog where
> category names would turn up with those evilly acusing question marks.
>
> The user the then reported that he'd fixed it by adding:
> `mysql_query("SET NAMES 'utf8′");`
> before every original mysql_query call.
>

If your tables are UTF-8, make sure the following is in wp-config.php.
 This will cause SET NAMES to be called.

define('DB_CHARSET', 'utf8');