Each time I was uploading my WP install from offline to online, I was noticing strange characters in text and digging a bit I have discovered that wp-config.php on the online server was set to define('DB_CHARSET', 'utf8mb4'); so each time I would upload the new “release” I had to edit to wp-config.php to utf8 to display correctly extended characters.
Lately I have discovered (through phpmyadmin) not only that the default collation sequence on my install is set to utf8mb4, but also some tables in the WP db are set to utf8mb4, while others are set to utf8_general_ci…
I have read that under certain conditions WP will attempt to convert collation sequence to utf8mb4 when possible.
So now I have a fruit salad of collation sequence in my db.
What shall I do?
