Skip to main content

Search

Welcome to Tibero GTS!

How to Check Tibero Character Set

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 
;

 

 

 

Related to