문서유형ㅣ기술정보
분야ㅣ관리/환경설정
문서번호ㅣTIITS011
개요
티베로 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.- 조회문 2
select * from _vt_nls_character_set; CHARACTERSET_NAME NCHAR_CHARACTERSET_NAME ----------------- ----------------------- MSWIN949 UTF16 1 row selected.
컨트롤파일 백업을 통한 조회
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 ;