French Characters are not converted correctlly in Oracle tbl

ArndW · Post by **ArndW** » Tue Oct 21, 2008 10:36 am

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.

harshkohli · Post by **harshkohli** » Wed Oct 22, 2008 6:48 am

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

ray.wurlod · Post by **ray.wurlod** » Wed Oct 22, 2008 5:50 pm

Try ISO8859-1 as your DataStage NLS map.

stevenzhangshen · Post by **stevenzhangshen** » Wed Oct 22, 2008 7:03 pm

Please check the NLS_LANG variable value in your DataStage Server machine, and add DataStage environment variable in that job.

harshkohli · Post by **harshkohli** » Thu Nov 06, 2008 1:39 pm

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.

stevenzhangshen · Post by **stevenzhangshen** » Wed Nov 12, 2008 11:23 pm

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.