Page 1 of 1
Posted: Tue Oct 21, 2008 10:36 am
by ArndW
How are you looking at the data (hint: don't use "view data"). What is your source file NLS setting, your project default NLS setting and what is your Oracle NLS setting.
Posted: Wed Oct 22, 2008 6:48 am
by harshkohli
I looked at data in the input file from Unix (vi) as well as from view data from DataSatge and the french characters are displayed correctly. The input file as well as the output file has the default project NLS settings which is ISO8859-1. The Oracle's NLS setting is WE8ISO8859P1.
I tried changing the NLS setting of the output Oracle table in DataStage to the following but none of them work :
UTF8
EBCDIC=037
ISO8859-1+MARKS
ISO8859-1-CS
ISO8859-15-CS
MNEMONICS
Posted: Wed Oct 22, 2008 5:50 pm
by ray.wurlod
Try ISO8859-1 as your DataStage NLS map.
Posted: Wed Oct 22, 2008 7:03 pm
by stevenzhangshen
Please check the NLS_LANG variable value in your DataStage Server machine, and add DataStage environment variable in that job.
Posted: Thu Nov 06, 2008 1:39 pm
by harshkohli
We added a new environmental variable NLS_LANG with value : AMERICAN_AMERICA.WE8ISO8859P1 at the project level for each project and the issue is fixed.
Posted: Wed Nov 12, 2008 11:23 pm
by stevenzhangshen
harshkohli wrote:We added a new environmental variable NLS_LANG with value : AMERICAN_AMERICA.WE8ISO8859P1 at the project level for each project and the issue is fixed.
OK.