The default character set is the character set that SQL uses for
the following elements:
o Database columns with a character data type that does not
explicitly specify a character set
o Parameters that are not qualified by a character set
You can specify the default character set at the session and
database level. See the Oracle Rdb Introduction to SQL and Oracle
Rdb Guide to Database Design and Definition for more detail about
session and database character sets.
You can specify the database default character set only when
you create the database. You cannot change the database default
character set after you have created the database.
SQL uses DEC_MCS as the default character set, unless you have
set the dialect to MIA or specified a default character set
at the session level. You can override any default character
set by specifying another default character set when creating a
database.
To specify the default character set, use one of the character
set names listed in Supported Character Sets.
The default character set does not affect the setting of the
currency sign.
When you compile SQL programs (either SQL module language or
precompiled SQL), SQL uses the following to derive the default
character set:
o The DEFAULT CHARACTER SET clause in the DECLARE ALIAS
statement specifies the default character set of the alias
at compile time. At run time, SQL uses the default character
set of the attached database. At run time, you must ensure
that the database default character set is identical to the
default character set specified in the DECLARE ALIAS clause.
o The DEFAULT CHARACTER SET clause of the SQL module header or
the DECLARE MODULE statement specifies the character set for
parameters that are not qualified by a character set.
o In dynamic SQL, the SET DEFAULT CHARACTER SET statement
specifies, at run time, the character set for parameters that
are not qualified by a character set.
o The RDB$CHARACTER_SET logical name. However, the logical name
is deprecated and will not be supported in a future release.