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
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"
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