Database Administration (MOSC)

MOSC Banner

How to set NLS_CHARACTERSET = UTF8 in Oracle 11gR1?

edited Sep 26, 2011 1:36PM in Database Administration (MOSC) 2 commentsAnswered ✓
Hi all,
I try to replicate a customer's environment for Oracle 11g on AIX.  Customer gave us the NLS settings as follow:

SQL> select * from NLS_DATABASE_PARAMETERS
PARAMETER                      VALUE                                    
------------------------------ ---------------------------------------- 
NLS_NCHAR_CHARACTERSET         UTF8                                     
NLS_LANGUAGE                   AMERICAN                                 
NLS_TERRITORY                  AMERICA                                  
NLS_CURRENCY                   $                                        
NLS_ISO_CURRENCY               AMERICA                                  
NLS_NUMERIC_CHARACTERS         .,                                       
NLS_CHARACTERSET               UTF8                                     
NLS_CALENDAR                   GREGORIAN                                
NLS_DATE_FORMAT           

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center