Loading Chinese Character to SAP System(Unicode)

[Former Member]

Hello Experts,

I am trying to Extract Chinese Character Data from Old Sap System and Stage it then Load to ECC 6.0 which is an Unicode System.

But i am not able to and its loading something  ??????????????????????? like this.

I have 3 Datastore- DS_Source(SAP 4.2), DS_Stage(Oracle), DS_Load(SAP 6.0)

I have tried some combination-

DS_Source- utf-8

DS_Stage-utf-8

DS_Load-utf-8

DS_Source- utf-8

DS_Stage-utf-16

DS_Load-utf-8

But the data has not loading correctly.

Please let me know if there is any correct Procedure to do that

Thanks

Ashiq

[Former Member]

Hi,

At what stage do you see the garbled characters  "????? "... at source, staging, target, or in all?

If you click view sample data for each datastore you can see how characters are displayed.

Please let me know . Thanks

[Former Member]

Hi Nawfal,

I am seeing those in all the stages.

Basically my requirement is to extract Chinese data from the source sap system and stage in oracle and then load to upgraded SAP System.

Can you guide me what should be the configuration for the datastore

i tried cp936,utf-8,utf-16

But the source and target  datastore does not have an option for unicode.

Please let me know how to achieve this.

[Former Member]

Hi,

Since you have already tired different encoding UTF8 in the datastore and that didn't work, can you now add the Oracle NLS_LANG environment variable  on your DS job server machine as well as on the client DS designer machine. See how it's done here. At first use American_America.UTF8 as stated in the example, you can then change it after the test to a specific territory one.

thanks

[Former Member]

Hi Nawfal,

Tried as you suggested, still the output is coming same.

My source SAP system is not an Unicode system and target is Unicode system, can you please tell me the general procedure to handle this Chinese character?

First i want to try that properly

[former_member182007]

Can you try doing below, in your target template table change nvarchar proprty to "Yes"

Best | Deep.

[Former Member]

Thanks deepak.

I double clicked the target-- clicked Options-- then under Miscellaneous

Use Changing the NVARCHAR or VARCHAR columns in supported databases to "Yes" helped.

Regards,

Hameed

[former_member182007]

Please close the thread, Thanks.

[former_member182007]

Just try to change the Language as Chinese, Code page: Unicode, Server Code page: Unicode

This should give you desired output.

Best | Deep.

[Former Member]

Hi Deepak,

My Source and Target Datastore are of SAP type and it does not have an option 'Unicode'

The Staging Data Store is Oracle so i made it as you instructed.

Please let me know what should be the config for the Source and Target Datastore.

Thanks

Ashiq