WordPress 2.2 database character sets

For those upgrading their WordPress powered blogs to 2.2, just a word of warning regarding the new character encoding options available in the wp-config.php file.

The standard file should have a section which reads:

// ** MySQL settings ** //
define('DB_NAME', dbname// The name of the database
define('DB_USER', 'dbuser'); // Your MySQL username
define('DB_PASSWORD', 'dbpassword'); // ...and password
define('DB_HOST', 'localhost');
define('WP_HOME', 'http://www.yourblog.com/');
define('WP_SITEURL', 'http://www.yourblog.com/');
define('DB_CHARSET', 'utf8');
define('DB_COLLATE', 'utf8');

Note the new options added at the bottom regarding the codepage used in the blog’s database. If these are set incorrectly they may make your blog unreadable, else prevent special characters from appearing correctly. I personally found that commenting these two lines out left the blog functioning as before, but for people wishing to change the codepage of their database, WordPress has a rough guide available, originally written for the beta testers.

Tagged with: , ,

Related posts

TrackBack

TrackBack URL for this entry:
http://www.chezenterprises.co.uk/blog/2007/05/25/wordpress-22-database-character-sets/trackback/

Comments

[...] se ha hablado muchísimo en diferentes blogs. Cada blog, cada usuario, en fin cada quien propone una solución diferente al problema e incluso el Codex (la carta magna sobre WordPress) ofrece también una y no es para [...]

[...] se ha hablado muchísimo en diferentes blogs. Cada blog, cada usuario, en fin cada quien propone una solución diferente al problema e incluso el Codex (la carta magna sobre WordPress) ofrece también una y no es para [...]

Post a comment