Bora.Choi

. 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