MySQL tables' charactersets and collation changed after data loading
My source database is running Oracle 11g. The target database is MySQL 8.0.30 with default characterset "utf8mb4" and table collation "utf8mb4_0900_ai_ci" respectively.
However after I perform an initial full loading, the target tables has changed its characterset to "latin1" and table collation as "latin1_swedish_ci"
In the task setting under task setting --> Full Load --> Full Load Settings --> Target Table Preparation You can set what will happen when Replicate reloads a table . The default setting is 'DROP and CREATE table' IF you wish to keep existing table and only truncate its data you should change this setting to 'TRUNCATE before loading'. This will keep the existing table definition and only truncate the data before reloading it.
In the task setting under task setting --> Full Load --> Full Load Settings --> Target Table Preparation You can set what will happen when Replicate reloads a table . The default setting is 'DROP and CREATE table' IF you wish to keep existing table and only truncate its data you should change this setting to 'TRUNCATE before loading'. This will keep the existing table definition and only truncate the data before reloading it.
