Chinese character issue, MDMP system

dataservices administration
1

Hi all,

We have an issue where we are extracting data from an old legacy SAP 4.6C system which uses MDMP rather than Unicode pages and as such has a combination of English and Simplified Chinese characters, often in the same field. We are currently using the RFC streaming method used to extract the table but are having problems being able to see any of the Chinese characters and instead bring them through as ‘±£¼à»á»üºËϵͳÊý¾Ý±¨ËÍϵͳ’. This is also how we see the data as the standard character set when we log into the legacy system, however the business user in China use the simplified Chinese character set to view the data in the correct format.

The question is for a system that seemingly does not support Unicode, any recommendations how to extract the data with the Chinese characters intact into the database?

(Source datastore for legacy SAP connection is utf-8, Target datastore for SQL server is also utf-8 and the db does accept Chinese characters when testing values manually. We have tried numerous combinations of code pages without success)

Thanks

Matt

mattgale (BOB member since 2015-04-30)

2

I have no experience with SAP database connectivity but, have had problems with mismatched DataStore codepages, etc.

What is the underlying database connectivity using for the codepage - your DataStore needs to match it.

Perhaps I’ve misunderstood?

Simple Simon :uk: (BOB member since 2007-09-07)

3

Thanks for the reply,

The database connection is a simple ODBC connection to a SQL server database. We know this database accept Chinese characters and the codepage matches that of the datastore. I think the issue stems from the system being set-up as MDMP (due to the age of the system) and as such means we cannot read both English and Chinese in the same text.

When logging into SAP using the standard code-page from here in the UK it shows the language and the rubbish shown above and only change to be able to view the Chinese character once changed in the ‘options’ button

I have a sinking feeling that unless somebody has a Chinese logon id then we cannot extract the Chinese characters as is.

Thanks

mattgale (BOB member since 2015-04-30)