What's the *correct* database collation & encoding supposed to be? (3 posts)

  1. blogjunkie
    Posted 7 years ago #

    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 - http://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 http://mymacbuzz.com has problems.

    Appreciate any help you experts can give me. Cheers

  2. figaro
    Posted 7 years ago #

    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.

  3. blogjunkie
    Posted 7 years ago #

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

Topic Closed

This topic has been closed to new replies.

About this Topic