topic Re: For some Char columns, trailing spaces are being trimmed, for others, they are not. in Qlik Replicate

For some Char columns, trailing spaces are being trimmed, for others, they are not.

Ed5 — Thu, 03 Aug 2023 17:37:11 GMT

Source:Sybase Adaptive Server Enterprise 15.7

Target: Az SQL Managed Instance

Based on some research, It seems that for non-nullable char columns, the trailing spaces are not being trimmed during the replication process. However, for nullable char columns, the trailing spaces are indeed being trimmed. Is this correct?

I checked out the documentation, and it does not mention anything about trimming or not trimming the trailing spaces of the char columns, as it happens with Oracle's documentation.

As an FYI, one of the tables with nullable char columns has had errors during the replication process, and they have been logged into qlik exceptions table. I can see the INSERT statement with the value being trimmed (e.g., 'P' instead of 'P ').

Could you please clarify what is the right behavior, or could this be a bug?

Please let me know if there is any setting I should validate. This is our first time using the tool, and we are using the default settings, which means that the columns don't have any transformation logic. They are being replicated as they are in the source.

Thank you!

Re: For some Char columns, trailing spaces are being trimmed, for others, they are not.

Dana_Baldwin — Thu, 03 Aug 2023 17:57:01 GMT

Hi @Ed5

What is the full version number of Replicate you are using?

This might require a support case, especially if this turns out to be a software defect that has to be elevated to our development team. Please open a case and attach the task diagnostics package.

Thanks,

Dana

Re: For some Char columns, trailing spaces are being trimmed, for others, they are not.

Ed5 — Thu, 03 Aug 2023 18:25:07 GMT

Hi @Dana_Baldwin,

If it is the one in the upper right corner of the qlik portal, then it is 2022.11.0.394.

I'll open the case then.

Let me know if you need any other detail.

Thank you!

Re: For some Char columns, trailing spaces are being trimmed, for others, they are not.

Ed5 — Thu, 03 Aug 2023 18:28:34 GMT

@Dana_Baldwin , I cannot find how to create a support case. Could you please let me know how to create it? Thanks.

Re: For some Char columns, trailing spaces are being trimmed, for others, they are not.

Dana_Baldwin — Thu, 03 Aug 2023 18:33:16 GMT

@Ed5 You should see a "create support case" button at this link: Case Portal - Qlik Community