Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

wrong currency symbol

SVARDec 5 2012 — edited Dec 10 2012

Guys,

We are loading the data from a csv file in oracle table.
We are using odi procedure which invlokes sqlloader through shell
script and loads the data.The only issue iam finding is in the file
we have a record like
GBP,DEBENHAMS,GREAT BRITAIN POUND STERLING,£,A,,,,
where you can see pound symbol clearly.
When we load the data into oracle table
it will becomes like ¿.
In the nls_session_parameters table we have like:-
NLS_CURRENCY £
NLS_LANGUAGE ENGLISH
NLS_ISO_CURRENCY UNITED KINGDOM
NLS_TERRITORY UNITED KINGDOM
Why it is loading like ¿. ?

Any ideas?
Cheers
Sri

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 7 2013

Added on Dec 5 2012

#database-key-features, #globalization-support

11 comments

3,075 views