Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether the collation_server Values of the Source and Destination Databases Are the Same
Updated on 2024-05-09 GMT+08:00
View PDF
Share

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

If the collation_server values of the source and destination databases are different, the migration may fail.

Failure Cause

The collation_server values of the source and destination databases must be the same.

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.

For details about how to change the value of collation_server for other types of databases, see the usage guide of the corresponding database.

Parent topic: Database Parameters