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
- If the database is a self-managed MySQL database, run commands to change the value.
- Run the following command to check the value:
SHOW VARIABLES LIKE "collation_server";
- Run the following command to change the value:
SET collation_server='utf8_unicode_ci';
- Run the following command to check the value:
- 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.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot