SAP special german characters(umlaut) like ü, ö, ä not displayed properly in XML output

[Former Member]

Hello Team,

Here we are facing issues while converting SAP tables data to XML file.

the description is not converting properly for the special German characters like ü, ö, ä.

Actual output should be :Überprüfung nach § 29 STVZO

Output Displayed :Ã#berprüfung nach § 29 STVZO

Can you please look into and help me in this to get correct output .

Thank you.

[volker_borowski2]

Hi,

Unicode or Non-Unincode System ?

Displayed where ? SAPGUI ? Print Preview ? Spool-Display ?

And how is the XML file written ?  OPEN DATASET ? BAPI ?

At all of these stages it might be either that it is only a display system, like the selected display CHARSET in SAPGUI, when it is a non-unicode system, or simply not coded correctly like OPEN DATASET without specifying the cdepage when necessary.

And it might even be, that even "displaying" the XML File is simply done with the incorrect codepage while the data inside the file is correct.

If you are on Windows, you might even face funny results when saving a simple textfile from notepad with ANSI/DOS and both Unicode variants and then go to CMD.EXE ans simply "type" the content.

All 4 results will be different, allthough notepad will display the same stuff.

So first of all, makes sure which codepage is relevant at all stages from DB-table to "display"

- DB-Charset

- SAP system type (unicode/non-unicode)

- SAP codepage (1100 / 410x )

- crosscheck the test from report RSCPINST

- Codepage on Windows running SAPGUI

- Selected codpage for Sapgui

:

:

Good hunting

Volker

[thanga_prakash]

Hello Rajasekhar,

There seems to be problem in encoding, use any of the encoding function modules to convert the coding page before passing it to XML file creation.

Regards,

Thanga

[nils_buerckel]

Hi,

you are likely using a display tool which expects Latin-1 (Non-Unicode) data, while your XML file is based on UTF-8 (Unicode). The  typical behaviour for this is e.g the display of "ü" instead of "ü". As utf-8 is the standard encoding, I would recommend to use a different display tool or change the settings (if possible). Please also have a look at the following SAP note:

1150217 Showcase ENCODING: Editor bug - or - Codepage issue?

Best regards,

Nils Buerckel