Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
We have a replicate job that uses postgreSQL as source and both Kafka and Oracle as endpoint.
Some columns in our tables have a single space as value. (So " ") This is replicated fine to Oracle, we can see the length is 1 and the columns in questions are non nullable so that works.
However in our Kafka message for the same action the value is given as "", so no single space anymore but NULL. I only found a mention of this type of behavior for Oracle as source in case of CHAR columns so it comes unexpectedly to us.
Is there a way to keep the space (so the actual value) in the Kafka message?
Hi @Vigo ,
Great to hear that! Please do not forget to mark a solution that worked for you! 😊
Regards,
Desmond