Convert CSV files use "us-ascii" encoding which contain Chinese characters, however the result contain garbled

Description:
A: I have Excel(xlsx) contain remark column, which contain Chinese characters
B: I read excel output as datatable
C: write CSV file use “us-ascii” (must use this encoding) encoding without header
D: Open CSV file find it contain garbled
F: After that, I should open csv file use “UltraEdit32”, If I use other encoding, when open, still have garbled, I posted it below.
abc.xlsx (8.3 KB)

Excel:
image

Convert CSV file:
image-8

CSV(Encoding with “UTF-8”), use “UltraEdit32” open:
image

Thanks in advance for you help!

1 Like

Hey @Lori

Kindly try the below encoding options,

Ref - Supported Character Encoding

Thanks
#nK

@Nithinkrishna
I try gb231 and big5, it’s still have garbled。

Remark: I had edit my post, explain why I have to use “us-ascii” encoding.

image

Hi,

if it’s encoded as us-ascii by WriteCSV activity, all the Chinese characters is converted to 0x3F("?") as the following.

img20220224-5

So, we cannot recover it to original character.
Can you try to use “UTF-8” encoding and check it using Notepad.exe?

Regards,

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.