Character Set

. Character set : 한글만 입력한다면  KO16MSWIN949 로 설정 한글과 다른 언어를 혼용 해서 사용 한다면 AL32UTF8 를 설정 하는 것을 권고. 해당 셋이 정렬도 완벽하다. 그리고 꼭 해야 하는 한글 입력 시 ORA-01756: quoted string not properly terminated 발생 하면 클라이언트의 NS_LANG 설정이 잘 먹히지 않은 것. . .bash_profile 적용 하기.  --> 이 부분 이 잘 안 된 것 같음.

 

 

SQL> col value$ format a40 SQL> set line 150 SQL> col name format a25 SQL> col value$ format a40 SQL> col comment$ format a40 SQL> select * from sys.props$ where name like '%CHARACTER%';   NAME                          VALUE$                                   COMMENT$ ------------------------- ---------------------------------------- ---------------------------------------- NLS_NCHAR_CHARACTERSET          AL16UTF16                                   NCHAR Character set NLS_CHARACTERSET          KO16MSWIN949                                   Character set NLS_NUMERIC_CHARACTERS          .,                                           Numeric characters   SQL> select * from sys.props$ where name like 'NLS_%';   NAME                          VALUE$                                   COMMENT$ ------------------------- ---------------------------------------- ---------------------------------------- NLS_RDBMS_VERSION          12.1.0.2.0                                   RDBMS version for NLS parameters NLS_NCHAR_CHARACTERSET          AL16UTF16                                   NCHAR Character set NLS_NCHAR_CONV_EXCP          FALSE                                    NLS conversion exception NLS_LENGTH_SEMANTICS          BYTE                                           NLS length semantics NLS_COMP                  BINARY                                   NLS comparison NLS_DUAL_CURRENCY          $                                           Dual currency symbol NLS_TIMESTAMP_TZ_FORMAT   DD-MON-RR HH.MI.SSXFF AM TZR                   Timestamp with timezone format NLS_TIME_TZ_FORMAT          HH.MI.SSXFF AM TZR                           Time with timezone format NLS_TIMESTAMP_FORMAT          DD-MON-RR HH.MI.SSXFF AM                   Time stamp format NLS_TIME_FORMAT           HH.MI.SSXFF AM                           Time format     NAME                          VALUE$                                   COMMENT$ ------------------------- ---------------------------------------- ---------------------------------------- NLS_DATE_LANGUAGE          AMERICAN                                   Date language NLS_DATE_FORMAT           DD-MON-RR                                   Date format NLS_CALENDAR                  GREGORIAN                                   Calendar system NLS_CHARACTERSET          KO16MSWIN949                                   Character set NLS_NUMERIC_CHARACTERS          .,                                           Numeric characters NLS_ISO_CURRENCY          AMERICA                                   ISO currency NLS_CURRENCY                  $                                           Local currency NLS_TERRITORY                  AMERICA                                   Territory NLS_LANGUAGE                  AMERICAN                                   Language   20 rows selected.     SQL> set pagesize 30 SQL> col parameter for a30 SQL> col value for a30 SQL>     SQL> select * from v$nls_parameters;   PARAMETER                       VALUE                                  CON_ID ------------------------------ ------------------------------ ---------- NLS_LANGUAGE                       AMERICAN                                0 NLS_TERRITORY                       AMERICA                                       0 NLS_CURRENCY                       $                                       0 NLS_ISO_CURRENCY               AMERICA                                       0 NLS_NUMERIC_CHARACTERS               .,                                       0 NLS_CALENDAR                       GREGORIAN                               0 NLS_DATE_FORMAT                DD-MON-RR                               0 NLS_DATE_LANGUAGE               AMERICAN                                0 NLS_CHARACTERSET               KO16MSWIN949                               0 NLS_SORT                       BINARY                                       0 NLS_TIME_FORMAT                HH.MI.SSXFF AM                               0 NLS_TIMESTAMP_FORMAT               DD-MON-RR HH.MI.SSXFF AM                0 NLS_TIME_TZ_FORMAT               HH.MI.SSXFF AM TZR                       0 NLS_TIMESTAMP_TZ_FORMAT        DD-MON-RR HH.MI.SSXFF AM TZR               0 NLS_DUAL_CURRENCY               $                                       0 NLS_NCHAR_CHARACTERSET               AL16UTF16                               0 NLS_COMP                       BINARY                                       0 NLS_LENGTH_SEMANTICS               BYTE                                       0 NLS_NCHAR_CONV_EXCP               FALSE                                       0   19 rows selected.   SQL> select  '보라' d from dual; ERROR: ORA-01756: quoted string not properly terminated

 

export NLS_LANG=American_America.KO16MSWIN949

export LANG=C

export EDITOR=vi