Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
IanM
Contributor III
Contributor III

Replicate Oracle creates table using VARCHAR (BYTE)

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

Labels (2)
1 Solution

Accepted Solutions
john_wang
Support
Support

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.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!

View solution in original post

2 Replies
john_wang
Support
Support

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.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
IanM
Contributor III
Contributor III
Author

Many thanks John. That has solved the problem.