Checking Whether the Source and Destination Database Character Sets Are Consistent

Whether the source and destination database character sets are consistent

Check whether the character sets of the servers hosting the source and destination databases are consistent.

Failure cause: This item cannot be checked because the source database fails to be connected.

Handling suggestion: Check whether the source database is connected.

Failure cause: This item cannot be checked because the destination database fails to be connected.

Handling suggestion: Check whether the destination database is connected.

Failure cause: Insufficient user permissions

Handling suggestion: Check whether the database user permissions meet the migration requirements.

Failure cause: The character set of the source database is inconsistent with that of the destination database.

Handling suggestion: Modify the character sets.

Run commands to modify the self-created source database.

1. Check whether source and destination database character sets are consistent.

   show variables like "character_set_server"\G;

   

2. Modify the character set of the source database server.

   set character_set_server='utf8';