Skip to Main Content
Forums

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!

Cannot Store Greek Characters in NVARCHAR2 columns

922854Apr 13 2012 — edited Apr 20 2012
Can someone please help.

I have a table TEST with one column A of type NVARCHAR2(20) and when I try to insert the greek character Ω(Omega) - it gets stored as O instead.

I am inserting using SQL Developer using the 'N' prefix and my environment is as follows:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
NLS_CHARACTERSET = WE8MSWIN1252
NLS_NCHAR_CHARACTERSET = AL16UTF16

NLS_LANG setting on client side is ENGLISH_UNITED KINGDOM.WE8MSWIN1252.

Why can I not insert greek characters with the above setup and what do I need to do/change in order to be able to insert greek characters in a database using the national characterset for storing unicode data ?
This post has been answered by orafad on Apr 16 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 18 2012
Added on Apr 13 2012
#database-key-features, #globalization-support
7 comments
1,721 views