There is some japanese data to be loaded to oracle 9i database ( UTF-8 ) .
Data looks like junk after its loaded through datastage to oracle tables.
what are the settings that I need to take care to load japanese chars to oralce.
Note : My source is SAP BW....using extract pack to pull data...
Please advise.
Japanese charecters looks like junk when loaded to oracle 9i
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There are at least 14 different ways that Japanese characters are encoded, including Shift-JIS. You need to find out how the data are encoded, and set the DataStage NLS map to that. You may also need to set environment variables such as NLS_LANG.
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: 41
- Joined: Wed Mar 05, 2003 1:28 am