loading Chinese data

ayan · Post by **ayan** » Sun Jan 17, 2010 4:24 am

I will have to create a simple job which reads from a delimited file and load in oracle (using OCI stage).Only thing is that data is in Chinese language.Oracle DB character set is UTF8.What configuration do I have to do at datastage level?One I can think of is to set up NLS as UTF8 at job level.Request your suggestion.

ArndW · Post by **ArndW** » Sun Jan 17, 2010 6:23 am

You don't really need to do much, if anything, in DataStage. Tell DS that the source file is UTF-8 and ensure that your environment Oracle variables are correctly entered and the data will load correctly (the "view data" won't show correctly, but that is a known restriction in DataStage)

ayan · Post by **ayan** » Mon Jan 18, 2010 3:11 am

What are the environment Oracle variables you are referring here?

ayan · Post by **ayan** » Mon Jan 18, 2010 3:27 am

What are the environment Oracle variables you are referring here?

ArndW · Post by **ArndW** » Mon Jan 18, 2010 4:21 am

Specifically for Oracle you should ensure that NLS_LANG is set to the correct character set.

ayan · Post by **ayan** » Mon Jan 18, 2010 8:01 am

Yes..did just that..working...Thanks.