topic Replicate Oracle creates table using VARCHAR (BYTE) in Qlik Replicate

Replicate Oracle creates table using VARCHAR (BYTE)

IanM — Fri, 19 Mar 2021 17:09:42 GMT

Hi, Fairly new to replicate.

I'm setting up replicate between two oracle Databases. Source is Non-Unicode and destination is Unicode (AL32UTF8).

Replicate is creating the tables on the destination, and is using the VARCHAR2 (10 BYTE) format.

Because source and destination use different number of BYTEs due to the codepage, I'm getting truncation on the destination.

Can I somehow force Replicate to use VARCHAR2 (10 CHAR) to overcome this, or will I have to do this manually by script and set replicate to truncate on full load.

I assume if I have to create destination tables by script, I cannot rely on Replicate to create the first unique index, and I will have to do that manually as well?

Thanks

Re: Replicate Oracle creates table using VARCHAR (BYTE)

john_wang — Sat, 20 Mar 2021 02:25:41 GMT

Hello @IanM ,

You can add an internal parameter

charLengthSemantics

in Target Oracle endpoint advanced tab, set its value to CHAR.

Let me know if you need any additional assistance.

Regards,

John.

Re: Replicate Oracle creates table using VARCHAR (BYTE)

IanM — Mon, 22 Mar 2021 09:13:36 GMT

Many thanks John. That has solved the problem.