Specifies the default character set for the SQL session.
1 – Environment
You can use the SET DEFAULT CHARACTER SET statement:
o In interactive SQL
o Embedded in host language programs to be precompiled
o As part of a procedure in an SQL module
o In dynamic SQL as a statement to be dynamically executed
2 – Format
(B)0[m[1;4mSET[m[1m [1;4mDEFAULT[m[1m [1;4mCHARACTER[m[1m [1;4mSET[m[1m qqq> runtime-options qqqqq> [m [1m [m (B)0[m[1mruntime-options [m [1m [m [1mqqwqqq> 'string-literal' qqqqqqwqqqqq> [m [1m tqqq> parameter qqqqqqqqqqqqqu [m [1m mqqq> parameter-marker qqqqqqj [m
3 – Arguments
3.1 – parameter
Specifies the default character set for your session. The value
of runtime-options must be a valid character set. For a list of
allowable character set names and option values, see Oracle Rdb
SQL Reference Manual.
3.2 – parameter-marker
Specifies the default character set for your session. The value
of runtime-options must be a valid character set. For a list of
allowable character set names and option values, see the Oracle
Rdb SQL Reference Manual.
3.3 – 'string-literal'
Specifies the default character set for your session. The value
of runtime-options must be a valid character set. For a list of
allowable character set names and option values, see the Oracle
Rdb SQL Reference Manual.
4 – Example
Example 1: Setting the default character set of an interactive
session
SQL> show character sets;
Default character set is DEC_MCS
National character set is DEC_MCS
Identifier character set is SHIFT_JIS
Literal character set is SHIFT_JIS
Display character set is SHIFT_JIS
SQL> set default character set 'DEC_KANJI';
SQL> show character sets;
Default character set is DEC_KANJI
National character set is DEC_MCS
Identifier character set is SHIFT_JIS
Literal character set is SHIFT_JIS
Display character set is SHIFT_JIS