topic MySQL tables' charactersets and collation changed after data loading in Qlik Replicate

MySQL tables' charactersets and collation changed after data loading

desmondchew — Thu, 08 Sep 2022 06:37:05 GMT

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"

Please see attached screenshot.

Re: MySQL tables' charactersets and collation changed after data loading

OritA — Thu, 08 Sep 2022 07:02:48 GMT

Hi,

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.

Regards,

Orit