Skip to Content

Date Services Code page set with Oracle WE8DEC

The Oracle Database parameter table shows charset is WE8DEC.

Which kind of code page should I use in Data Services 4.2 SP10?

I have tried all kinds of code page listed in Datastore configruation, but all Chinese characters are still sempreroma...


The ECC version is 4.7 with non-unicode environment.

Locale Selector uses defalut database locale.

oracle.png (79.9 kB)
code.png (125.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Apr 27 at 03:58 AM

    Thomas Lu

    Check what is the value of NLS_LANG on the Oracle Client

    Kindly follow SAP Note

    2020160 - Chinese character is garbled in Data Services

    The Code which you have chosen is correct i.e gb18030

    Regards

    Arun Sasi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 25 at 08:54 AM

    From your list the closest match to WE8DEC is ISO-8859-1;
    both were designed for Western European languages, and are quite similar.
    For details have a look at:
    https://en.wikipedia.org/wiki/Multinational_Character_Set
    https://en.wikipedia.org/wiki/ISO/IEC_8859-1

    On the other hand, I can't fancy Chinese characters neither in a WE8DEC nor in an ISO-8859-1 database.
    If they are really there, this must be due to NLS_NCHAR_CHARACTERSET = UTF8.
    So my second choice would be UTF-8.
    https://en.wikipedia.org/wiki/UTF-8

    hope this helps

    Add comment
    10|10000 characters needed characters exceeded

    • I have tried all kinds of pairs with server code page ISO-8859-1/Default, but it still doesn't work...

      However, I can fetch correct data from Sap Application side in DS.

      I am just doubt about the speed and stability by Sap Application.