topic Re: [Azure SQL Database Source] Empty string replicated as white space. in Qlik Replicate

[Oracle Target] Source's empty string replicated as white space.

HNAKAGAW — Wed, 27 May 2026 07:48:48 GMT

Hello Support

[Environment]

Source : Azure SQL Database

Target : Oracle

[Question]

Source empty string (0 byte string '') is replicated to target as white space (' ').

Because Oracle Database treat empty string as NULL , I want NULL.

Can I replicate empty string as NULL by some configuration?

Best Regards

Nakagawa

Re: [Azure SQL Database Source] Empty string replicated as white space.

john_wang — Wed, 27 May 2026 04:39:30 GMT

Hello Nakagawa-san, @HNAKAGAW

In which phase are you encountering this behavior — Full Load, Change Processing, or both? And what's the column type? CHAR, or VARCHAR. We'd like to confirm the behavior for you.

thanks,

John.

Re: [Azure SQL Database Source] Empty string replicated as white space.

john_wang — Wed, 27 May 2026 04:42:45 GMT

Hello Nakagawa-san, @HNAKAGAW

There is an internal parameter, alwaysReplaceEmptyString, please set it to false in target EndPoint and try again.

Hope it helps.

John.

Re: [Azure SQL Database Source] Empty string replicated as white space.

HNAKAGAW — Wed, 27 May 2026 05:55:45 GMT

Hello John-san

Thank you for your reply.

>In which phase are you encountering this behavior — Full Load, Change Processing, or both?

It is Both.

>And what's the column type? CHAR, or VARCHAR.

It is VARCHAR.

> There is an internal parameter, alwaysReplaceEmptyString, please set it to false in target EndPoint and try again.

I tried alwaysReplaceEmptyString=false and task works which I want.

Thank you my problem is clear.

I had misunderstood , this behaivor is caused by oracle target .

Because now subject might be confusing for other users forum , I'm thinking of changing the subject like below , Is that okay?

[Oracle Target] Source's empty string replicated as white space.

Best Regards

Nakagawa

Re: [Azure SQL Database Source] Empty string replicated as white space.

john_wang — Wed, 27 May 2026 06:25:52 GMT

Hello Nakagawa-san, @HNAKAGAW

Glad to hear the issue was solved. Thanks for your support.

Regards,

John.