Translate CCSID 65535 (DB2 data)

[dan-rosen]

Does anyone have a solution to translate CCSID 65535 data from a DB2 database? Talend doesn't seem to have a conversion option that I can see, so all string data comes in as a random assortment of letters. I also tried adding a translate option in my connection string and no luck. I haven't seen an answer in community yet.

Thanks,

Dan

[dan-rosen · Accepted solution]

solved my own issue! for anyone looking, add this as an additional parameter to your connection: ;translate binary=true;