Skip to main content

오라클클라이언트(sqlplus 등)에서 한글이 깨어질 경우..

오라클에 로그인 후 아래 쿼리를 입력하고 붉은색으로 표시해둔 값을 알아둔다. SQL> select * from nls_database_parameters; PARAMETER                            VALUE —————————— —————————- NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY                AMERICA NLS_NUMERIC_CHARACTERS    ., NLS_CHARACTERSET KO16KSC5601 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 […]

Read More