Specifies the national character set for the module or
interactive SQL session.
1 – Environment
You can use the SET NATIONAL 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;4mNATIONAL[m[1m [1;4mCHARACTER[m[1m [1;4mSET[m[1m qq> runtime-options qqqq> [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 national character set for your session. The value
of runtime-options must be a valid character set. See the Oracle
Rdb SQL Reference Manual for more information about the supported
character sets.
3.2 – parameter-marker
Specifies the national character set for your session. The value
of runtime-options must be a valid character set. See the Oracle
Rdb SQL Reference Manual for more information about the supported
character sets.
3.3 – 'string-literal'
Specifies the national character set for your session. The value
of runtime-options must be a valid character set. See the Oracle
Rdb SQL Reference Manual for more information about the supported
character sets.
4 – Example
Example 1: Setting the national character set for an interactive
session
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
SQL> set national character set 'DEC_KANJI';
SQL> show character sets;
Default character set is DEC_KANJI
National character set is DEC_KANJI
Identifier character set is SHIFT_JIS
Literal character set is SHIFT_JIS
Display character set is SHIFT_JIS