DSXchange

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

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.