개요
티베로 DBMS 서버에서 지원하는 캐릭터 셋 (character set)을 확인하는 방법을 설명합니다.
방법
DD 조회문
•
조회문 1
SELECT name, value FROM _dd_props WHERE name in ('NLS_CHARACTERSET' ,
'NLS_NCHAR_CHARACTERSET');
NAME VALUE
------------------------------ --------------------
NLS_CHARACTERSET MSWIN949
NLS_NCHAR_CHARACTERSET UTF16
2 rows selected.
SQL
복사
•
조회문 2
select * from _vt_nls_character_set;
CHARACTERSET_NAME NCHAR_CHARACTERSET_NAME
----------------- -----------------------
MSWIN949 UTF16
1 row selected.
SQL
복사
컨트롤파일 백업을 통한 조회
alter database backup controlfile to trace as 'a.ctl';
a.ctl 파일 내 "CHARACTER SET", "NATIONAL CHARACTER SET" 을 확인합니다.
CREATE CONTROLFILE REUSE DATABASE "tibero"
LOGFILE
GROUP 0 '/home/tibero/tbdata/redo01.redo' SIZE 50M,
GROUP 1 '/home/tibero/tbdata/redo11.redo' SIZE 50M,
GROUP 2 '/home/tibero/tbdata/redo21.redo' SIZE 50M
NORESETLOGS
DATAFILE
'/home/tibero/tbdata/system001.dtf',
'/home/tibero/tbdata/undo001.dtf',
'/home/tibero/tbdata/usr001.dtf',
'/home/tibero/tbdata/apm_ts.dtf'
NOARCHIVELOG
MAXLOGFILES 100
MAXLOGMEMBERS 8
MAXDATAFILES 4096
CHARACTER SET MSWIN949
NATIONAL CHARACTER SET UTF16
;
SQL
복사