http://wordpress.org/support/ WordPress › Support Topic: What's the *correct* database collation & encoding supposed to be? en Tue, 24 Nov 2009 12:26:11 +0000 http://wordpress.org/support/topic/279792#post-1102933 Sun, 14 Jun 2009 08:14:38 +0000 blogjunkie 1102933@http://wordpress.org/support/ <p>ok thanks for explaining that. I'll give it a try and see how it goes. </p> http://wordpress.org/support/topic/279792#post-1102655 Sun, 14 Jun 2009 01:20:17 +0000 figaro 1102655@http://wordpress.org/support/ <p>I'm not sure there is "a correct" encoding, but I would recommend utf8_unicode_ci. Your database was probably set to latin1 when it was created. You can change by selecting your db in phpMyAdmin, click on "Operations" at the top and change the collation. You will need to make sure your db collation matches what's in your wp-config.php file. It's best to get this all matching at the start...trying to change things in an established blog can get messy. </p> <p>Also, keep an eye on plugins that create tables in the db...quite often they will create latin1 tables. </p> http://wordpress.org/support/topic/279792#post-1102650 Sun, 14 Jun 2009 01:13:09 +0000 blogjunkie 1102650@http://wordpress.org/support/ <p>I'm curious to what the *correct* database collation &amp; encoding for a new WP install is supposed to be? My site appears to have the wrong encoding in some browsers - <a href="http://mymacbuzz.com" rel="nofollow">http://mymacbuzz.com</a></p> <p>The tables encoding is in <code>utf8_general_ci</code> but the database collation is <code>latin1_swedish_ci</code>. This is the same for all new WP blogs I set up but I can't figure out why <a href="http://mymacbuzz.com" rel="nofollow">http://mymacbuzz.com</a> has problems.</p> <p>Appreciate any help you experts can give me. Cheers </p>