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.