For those migrating from and older version of mysql with a lot of legacy code, collation is an issue. Migrating it requires alter tables after the restore, and thereafter every new table needs to be created with the collation required in mind otherwise will use the server default.

Please allow us to change server collation.