What’s the *correct* database collation & encoding supposed to be?

  • I’m curious to what the *correct* database collation & encoding for a new WP install is supposed to be? My site appears to have the wrong encoding in some browsers – https://mymacbuzz.com

    The tables encoding is in utf8_general_ci but the database collation is latin1_swedish_ci. This is the same for all new WP blogs I set up but I can’t figure out why https://mymacbuzz.com has problems.

    Appreciate any help you experts can give me. Cheers

Viewing 2 replies - 1 through 2 (of 2 total)

  • 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.

    Also, keep an eye on plugins that create tables in the db…quite often they will create latin1 tables.

    Thread Starter David Wang

    (@blogjunkie)

    ok thanks for explaining that. I’ll give it a try and see how it goes.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘What’s the *correct* database collation & encoding supposed to be?’ is closed to new replies.