Skip to Main Content
Forums

Oracle Database Discussions

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!

Euro Symbol display

573174Apr 18 2007 — edited Apr 20 2007
My 10g2 db is using the character set WE8MSWIN1252 and I even set NLS_CHARACTERSET to this value before launching my Windows application that uses the thin java client to connect to my Oracle db. The column is NCHAR and I can see the proper Euro symbol if I insert CHR(128) every time I want to use this symbol. But, it is not practice for me to parse all user input.

Is there a database mechanism so that the Euro symbol (hex AC) is displayed properly without additional SQL on the insert?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 18 2007
Added on Apr 18 2007
#general-database-discussions
11 comments
1,908 views