French Characters are not converted correctlly in Oracle tbl
Moderators: chulett, rschirm, roy
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 31
- Joined: Wed Feb 04, 2004 2:04 pm
- Location: Canada
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
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
Harsh Kohli
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 32
- Joined: Fri Sep 26, 2003 3:45 am
-
- Participant
- Posts: 31
- Joined: Wed Feb 04, 2004 2:04 pm
- Location: Canada
-
- Premium Member
- Posts: 32
- Joined: Fri Sep 26, 2003 3:45 am