Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello team ,
I would like to have your expertise on the below topic :
We have a table with a column that in the source (DB2) the value of this column is encoded as a BSON .
On the Qlik replicate , in the output columns list this column is by default set to BLOB .
As a target it is used MySQL , but this column contains strange characters, which cannot be handled. I understood that in order to see the value we must decode it ,however, I also understood that MySQL it is not supporting BSON type of data.
Do you think that it is possible for a datatype conversion when replicating in this case ? If yes, what datatype you suggest using from the output columns drop list menu?
Thank you
Ionut Deaconescu
Hello @deaconescu ,
No worries! I'm glad to hear the problem was solved.
Best Regards,
John.