Hi,
has anyone tried loading data with multi-lingual characters like japanese or chinese through DataStage jobs into Oracle DB. the data should be in a dat file. rcommend procedures to create multilingual data and loading it in DB.
thnx
loading japanese characters through DS jobs
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The only things you need to do are:
(a) get the NLS setting right (for example UTF-8, SHIFT-JIS)
(b) get the corresponding environment variables set correctly for Oracle
Note that you can do Japanese OR Chinese (as your question implied). Except for those characters common to the two, you can not do both in the same data field (if that's what you mean by "multi-lingual"). DataStage does provide for using a different NLS map for each field, but Oracle does not.
(a) get the NLS setting right (for example UTF-8, SHIFT-JIS)
(b) get the corresponding environment variables set correctly for Oracle
Note that you can do Japanese OR Chinese (as your question implied). Except for those characters common to the two, you can not do both in the same data field (if that's what you mean by "multi-lingual"). DataStage does provide for using a different NLS map for each field, but Oracle does not.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If you're using TextPad to create the DAT file, for what purpose are you using DataStage? Are the Oracle environment variables, especially NLS_LANG, correctly set? If you are using TextPad it is unlikely that the characters are encoded using SHIFT-JIS - it is far more likely that some form of Unicode, probably some UTF-8 encoding - has been used.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.