What is your NLS setting ?
Try writing the value into a sequential file and check.
Euro Symbol not populating in Oracle
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
This is a common question resulting from NLS and incorrect settings. Most likely your Oracle environment variable NLS_LANG is not set correctly at runtime. What value do you have and what NLS setting does your Oracle instance have?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Euro Symbol not populating in Oracle
In Datastage the NLS is set in dsenv as below:
export NLS_LANG=american_america.WE8ISO8859P15
In Oracle the Character set used is = "UTF - 8"
export NLS_LANG=american_america.WE8ISO8859P15
In Oracle the Character set used is = "UTF - 8"
typing in the Euro explicitly should be OK. What method are you using in your Oracle stage - insert/upsert or table load, that might be where the problem is creeping in.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Euro Symbol not populating in Oracle
Writing on behalf of Rohan:-
I had used below options:-
1:
Write Method : Load
Write Mode : Replace
Result: All records are loaded but without the Euro symbol. With below warning:-
Oracle_Enterprise_3,1: Invalid character(s) ([x20AC]) found converting Unicode string (code point(s): ROUNDING DISCOUNT ( [x20AC].81 )) to codepage ISO-8859-1, substituting.
2:
Write Method : Upsert
Upsert Order: Insert then Update
Upsert mode: user defined Update & Insert
Result: All records are rejected. Zero records loaded. Below is the warning:-
Oracle_Enterprise_3,1: Invalid character(s) ([x20AC]) found converting Unicode string (code point(s): ROUNDING DISCOUNT ( [x20AC].81 )) to codepage ISO-8859-1, substituting.
I had used below options:-
1:
Write Method : Load
Write Mode : Replace
Result: All records are loaded but without the Euro symbol. With below warning:-
Oracle_Enterprise_3,1: Invalid character(s) ([x20AC]) found converting Unicode string (code point(s): ROUNDING DISCOUNT ( [x20AC].81 )) to codepage ISO-8859-1, substituting.
2:
Write Method : Upsert
Upsert Order: Insert then Update
Upsert mode: user defined Update & Insert
Result: All records are rejected. Zero records loaded. Below is the warning:-
Oracle_Enterprise_3,1: Invalid character(s) ([x20AC]) found converting Unicode string (code point(s): ROUNDING DISCOUNT ( [x20AC].81 )) to codepage ISO-8859-1, substituting.
Euro Symbol not populating in Oracle
I am still having this issue.
Can anybody please help.
Regards
Rohan
Can anybody please help.
Regards
Rohan
Since the UNIX level NLS_LANG setting is correct, I would look into your ORACLE setting. From SqlPlus or the tool of your choice, execute "SELECT * FROM NLS_SESSION_PARAMETERS;" to see what your database is set up as.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>