오라클 nls_character

한글지원 캐릭터 셋

K016KSC5601         --> 한글 2350자
K016MSWIN949      --> 한글 11172자
UTF8                    --> 유니코드(과거버전)
AL32UTF8              --> 유니코드(오라클 11g버전)
                                 (한글 많이 사용하지만 영어도 많이 사용함)

 

*national character set

 

UTF8
AL16UTF16

 

select * from nls_database_parameters;

 

PARAMETER                                VALUE
---------------------------------------- ------------------------------
NLS_LANGUAGE                           AMERICAN
NLS_TERRITORY                            AMERICA
NLS_CURRENCY                            $
NLS_ISO_CURRENCY                      AMERICA
NLS_NUMERIC_CHARACTERS            .,
NLS_CHARACTERSET                      KO16MSWIN949
NLS_CALENDAR                            GREGORIAN
NLS_DATE_FORMAT                       DD-MON-RR
NLS_DATE_LANGUAGE                    AMERICAN
NLS_SORT                                    BINARY
NLS_TIME_FORMAT                        HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT               DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT                    HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT           DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY                     $
NLS_COMP                                    BINARY
NLS_LENGTH_SEMANTICS                 BYTE
NLS_NCHAR_CONV_EXCP                  FALSE
NLS_NCHAR_CHARACTERSET             AL16UTF16
NLS_RDBMS_VERSION                      11.2.0.1.0