Export to .CSV from web query uses wrong codepage (scrambled chinese chars)

[Jan_van_Ansem]

Hi,

I am running a BEx query in the web environment. The web browser shows the chinese text correctly.

When I export to .csv the chinese text is no longer recognisable.

System: BI7 - Unicode enabled.

There are no problems with displaying chinese text in BEx Analyzer (Excel) or BEx web. Only with the export to CSV.

When I open the file in a text editor I get a warning that the file is in codepage 1521 (latin-1) and contains characters which are not supported by that codepage.

Is there a system setting where I can specify what codepage should be used for an export to CSV?

The export to MS Excel seems to automatically use the right codepage.

The export to CSV is required because not all web query users have Excel or the right version of Excel.

Thanks,

Jan.

[Former Member]

Hello,

per default the codepage of the exported csv file is UTF-8; it can be configured in the web application designer. Can you try to change the codepage in the editor manually to the one you have configured in WAD and check if the display is correct then? In this case I would assume that it is a limitation of your editor that is not able to recognize or display the codepage correctly.

Best regards,

Ralf

[Jan_van_Ansem]

Hi, Thanks for the suggestion, however I am not using WAD.

When I create a report in QD I execute the query in a web browser. I simply bookmark that page so I can run it next time without opening up QD.....

Any other suggestions?