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!

How to set NLS_NCHAR_CHARACTERSET as UTF8

827996Jan 3 2011 — edited Jun 30 2012

HI All,

I am going to install oracle 11g with characters set setting as

NLS_NCHAR_CHARACTERSET is UTF8
NLS_CHARACTERSET AL32UTF8

But during the the installation with OUI, the only setting I can choose is Character Set AL32UTF8 and the language that the oracle product run on， which I chose English, Simplified Chinese and Traditional Chinese. So I cannot never choose the NLS_NCHAR_CHARACTERSET during the entire installation process. Every time after installation of database, show by selecting database_properties, I can see that NLS_NCHAR_CHARACTERSET is always AL16UTF16. Can you help me to know how I can set the NLS_NCHAR_CHARACTERSET as UTF8.

Clay Wai

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 28 2012

Added on Jan 3 2011

#9i, #general-database-discussions

6 comments

2,509 views