hi
I am trying to load UMF file from DataStage to Oracle database 11g. French characters are messed up in Oracle database.It shows correctly in Linux.
DataStage column : UStringToString('UMF TAGS'),"ISO_8859-1:1987")
code page is UTF_8
Database Oracle :NLS_LANG - AMERICAN_AMERICA.AL32UTF8
What do I have to fix in DataStage in order to work correctly?
thks
NLS CODE PAGE ISSUE
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Let's start by asking what you mean by "messed up in Oracle", why you believe this, and how this may have occurred.
Some idea of your DataStage job design might be useful too.
Some idea of your DataStage job design might be useful too.
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.