Truncate trailing binary zeros in char columns (oracle_endpoint_imp.c:769)

[murali23krishna]

I am using Oracle source endpoint and Kafka as the target endpoint, however when I check a few columns' data, I see trailing zeros are truncated and when I look at the log I see the subject message, is there a way to control this behavior?

[DesmondWOO]

Hi @murali23krishna ,

Thanks for reaching out to the Qlik Community.

Could you send us the column definition and a sample record? I would like to better understand the data structure and content. If possible, please run the following SQL command:

select dump(your_column, 1016) from your_table;

and share the output.

Regards,
Desmond

[john_wang]

Hello @murali23krishna ,

Besides Desmond's comment, let's try to add an internal parameter to tune Oracle source side behavior:

1. Open Oracle source endpoint
2. Go to the Advanced tab
3. Open Internal Parameters
4. Add a new parameter named truncateTrailingBinaryZerosInChars
   
5. Uncheck the box and save the setting, the screenshot sample:
   Re-run the task and let us know if it helps.
   Good luck,

John.