loading Chinese data
Moderators: chulett, rschirm, roy
loading Chinese data
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.
Ayan
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)
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Specifically for Oracle you should ensure that NLS_LANG is set to the correct character set.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>