I am receiving an excel which has some Chinese characters in it and after processing sending it to CRM, but at CRM those Chinese characters are converted into '???'.
I am using UTF 16 encoding at all the schemas and pipelines. Everything else is working as expected just those Chinese characters are converting to '?'.
Am I missing something?
I solved it. A pipeline was changing the encoding of incoming files from UTF 8 to ASCII. I made some changes in the code and set the encoding as UTF8 and now everything works.