I just migrated several WordPress websites to a new hosting company with the Duplicator plugin, but I’m not sure if I need to set collation for my new databases.
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? My previous host was experimenting with my websites and made changes to my wp-config.php file. They added define(‘DB_COLLATE’, ”); line and edited the define(‘DB_CHARSET’, ”); in some cases adding a language when that line was completely missing previously.
I need advice for both phpMyAdmin settings and the wp-config.php file edits.
- You must be logged in to reply to this topic.