I need to send data in Korean in a CSV file and Korean characters are not rendered correctly in CSV. I tried to use Tools-Convert the encoding of a text but got no luck as utf8bom is not an available format as output codepage.
I searched a lot on the net but I am now stuck as I cannot find any reliable solution. Some guys propose to add 0xEF and such using text aggregator but there 0xEF is interpreted as a standard string and not as a “prefix” for the following text encoding.
I really have doubt that we cannot do that properly in Make as special characters are everywhere in the non-English world.
Anyone to tell me what I missed and how to handle that so my Korean characters will render correctly in the resulting CSV file?
I joined the annual WW meeting of my provider and submitted the case last November. Strange enough, they were not able to reproduce the issue on their side, so I guess it was a problem with how character sets and encoding are managed in our organization. Still, I was not able to get any support internally in my company so I just gave up.
Then, a few weeks after, the platform has been enriched with new EXCEL modules, not requiring access to Microsoft account, and able to render the output under any xls* document type. Using standard xlsx solved the issue and special characters are now rendered perfectly.
