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

[HNAKAGAW]

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

[john_wang]

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.

[john_wang · Accepted solution]

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.

[HNAKAGAW]

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

[john_wang]

Hello Nakagawa-san, @HNAKAGAW 

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

Regards,

John.