Multilingual Option in Oracle (NLS)
Here are some often asked questions about Oracle NLS.
Show characterset the database was initially built ?
column name format a25
SELECT name,value$ FROM sys.props$;
Show valid NLS parameters (TERRITORY, CHARACTERSET)
COLUMN parameter format A15
Uses for the National Character Set
When you create the database, you the possibility to create an alternate character set, the so called national character set. In the following example, the default character set is UTF8 and the national character set is WE8ISO8859P1. The national character set is for example used in Eastern Europe countries, where we want to support the national language besides the "official" language.
CREATE DATABASE ARK1
Oracle uses the default database character set for these items:
Oracle uses the national character set for these items
How to change the character set in Oracle 8i ?
Under certain circumstances you have the possibility to change the database or national character set in Oracle 8i. The current character set must be a strict subset of the character set to which you change. That is, each character represented by a codepoint value in the source character set must be represented by the same codepoint value in the target character set. The following example changes to character set from WE8ISO8859P1 to UTF8.
SVRMGR> connect sys as sysdba;