topic How to ignore case insensitivities when loading into target MySQL database? in Qlik Replicate

How to ignore case insensitivities when loading into target MySQL database?

desmondchew — Wed, 30 Aug 2023 07:29:42 GMT

We are loading from Oracle source into MySQL 8.0 target databases. The row count on both source and target databases do not tally. Setting verbose target apply doesn't help as it showed that the total number of records were loaded correctly. However when we did a "select count(*)" over the target database show that we have lesser records.

Further probe we discovered that MySQL database in the target endpoint has rejected records that are case sensitive. Is there a way to instruct Replicate so that it will ignore case insensitivity?

Thank you.
Desmond

Re: How to ignore case insensitivities when loading into target MySQL database?

sureshkumar — Thu, 31 Aug 2023 01:49:31 GMT

Hello @desmondchew

Please open a Support ticket with us to analyze further on this.

Regards,
Suresh

Re: How to ignore case insensitivities when loading into target MySQL database?

desmondchew — Thu, 31 Aug 2023 02:36:40 GMT

I have found a solution to this. The default collation on MySQL 8.0 is utf8mb4_0900_as_ci (case insensitive) which means "ABC" and "abc" are treated as same value.

By changing the database collation to "utf8mb4_0900_as_cs" (case sensitive) allows me to load all the data into MySQL.

Regards

Desmond

Re: How to ignore case insensitivities when loading into target MySQL database?

sureshkumar — Thu, 31 Aug 2023 05:24:39 GMT

Hello @desmondchew

That's good to hear that, the issue has been resolved.

Regards,
Suresh