Document Type | Technical Information
Category | Administration
Document Number | TIITS011
Overview
This explains how to check the character sets supported by the Tibero DBMS server.
Method
DD Query
- Query 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.- Query 2
select * from _vt_nls_character_set; CHARACTERSET_NAME NCHAR_CHARACTERSET_NAME ----------------- ----------------------- MSWIN949 UTF16 1 row selected.
Check via Control File Backup
alter database backup controlfile to trace as 'a.ctl';Check "CHARACTER SET" and "NATIONAL CHARACTER SET" inside the a.ctl file.
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 ;