Collation settings in phpMyAdmin and wp-config.php

  • Resolved elizabeth

    (@greybird)


    3 years, 3 months ago

    I posted something previously here that was marked as resolved though I still have questions about the same situation. My previous post.

    I looked at your suggested link in my previous post about collation but considering that I’m very ignorant about databases, it didn’t help me much. I have been exploring phpMyAdmin and reading about collation settings but can’t find any answers about how to set phpMyAdmin collation settings after migration.

    When I look at the right side of my table list in phpMyAdmin in the new host I see mostly utf8_general_ci under collation but there are a few that use utf8mb4_unicode_ci. When I look at Databases or Operations in phpMyAdmin it appears that utf8mb4_unicode_ci is the default collation. Do I need to change the default to utf8_general_ci to match most of my existing tables?

    Do wp-config.php settings take priority over the settings in phpMyAdmin?

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

  • Hey @greybird,

    The status has been removed and the original question answered. When we don’t hear back from users after a few days it is highly likely they don’t come back.

    Do I need to change the default to utf8_general_ci to match most of my existing tables?

    Typically when collations match across servers you have a better chance of having your data match correctly, however, they don’t always have to match and in the case above both of those collations are pretty close.

    As far as changing your collation type on a production server (or really on any server) I would use caution as this is not something that you want to experiment with on production data. Also if you have a site that you can’t afford to mess up, you might reach out to a developer who can help assist you and properly handle the data with care. Trying to learn and get some of the more complex database processes on a forum could take a long time and run the risk of making mistakes that in some cases are unrecoverable.

    Hope this helps~

    Thread Starter elizabeth

    (@greybird)

    I’m still looking for a good source for up to date instructional material on the subject of migration, compatibility, optimization and maintenance of older WordPress websites and their databases. Any suggestions would be appreciated.

    Suggested links should now be in the first thread created…

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Collation settings in phpMyAdmin and wp-config.php’ is closed to new replies.