Checking Whether the collation_server Values of the Source and Destination Databases Are the Same

Failure Cause

Handling Suggestion

Change the value of collation_server of the source database to be the same as that of the destination database.

• If the database is a self-managed MySQL database, run commands to change the value.
  1. Run the following command to check the value:

     SHOW VARIABLES LIKE "collation_server";
     
     

  2. Run the following command to change the value:

     SET collation_server='utf8_unicode_ci';
     
     

• If the database is an RDS for MySQL DB instance, change the value of the collation_server parameter by referring to Modifying Parameters of an RDS for MySQL Instance.