Skip to Content
0

Unable to display Chinese characters in csv export

Jan 27, 2017 at 08:21 AM

328

avatar image

Hello,

We are doing a csv export from SAP MII. We use the below format for achieving this

http://<server:port>/XMII/Illuminator?QueryTemplate=<QueryTemplatePath>&Param.1=<ParamValue>...&Content-Type=text/csv.

The csv files gets successfully downloaded but when we open it does not display the right Chinese characters in the excel file. The data is displayed correctly in the SAP MII report.

If we try to import the csv file in excel and use UTF-8 encoding in the option it displays the right Chinese words but when I directly open the csv file it opens in UTF-7 encoding.

Can someone please help how we can fix this.

Regards

Suhas

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Neha Kshirsagar
Jan 31, 2017 at 04:01 AM
0

Hi Suhas ,

I am not sure whether it works for your file,can you add "&charset=UTF-8" to the URL can check.

Thanks & Reagrds,

Neha

Share
10 |10000 characters needed characters left characters exceeded
Ria Elezabeth Ninan
Jan 31, 2017 at 05:52 PM
0

Hi Suhas,

Another way of forcing excel to open the csv with UTF-8 is by adding a BOM(Byte-order-marker). For this you could open the csv in an editor like Notepad++ and change the encoding to "Encode in UTF-8 BOM" and then save. Now if you open this csv, excel will use UTF-8 decoding and display the characters correctly.

This is also a workaround, and not the solution to your problem; but hope this helps!

Thanks and Best Regards,

Ria

Share
10 |10000 characters needed characters left characters exceeded