Andy Broomfield Web Dev

Is there a way in Mysql 8.0 of changing the default collation used for a charcter set. Eg. changing utf8mb4 to use collation utf8mb4_unicode_ci instead of utf8mb4_a900_ai_ci.

Using drush sql:sync and host doesn't add it to the dump and the import fails with a duplicate key as theres an accent in one of the names.

#MySql #MySql8_0

Oct 24, 2024 at 12:50pmWeb
Show threadAndy Broomfield Web DevOct 24, 2024
Hmm, this might be as host is still using MySql 5.7 and we upgraded ahead of them upgrading our servers
Show threadwillpower232Oct 25, 2024
@andybroomfield if the client isn't specifying it when it connects then is it the database default?
Show threadAndy Broomfield Web DevOct 25, 2024
@willpower232 I don’t think it’s being set. I posted a follow up that the host is still using MySQL 5.7 and they where planning an upgrade which is why we upgraded locally. I think it’s not setting a default collation in the export.