Specifies the display character set.
1 – Environment
You can use the SET DISPLAY 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;4mDISPLAY[m[1m [1;4mCHARACTER[m[1m [1;4mSET[m[1m qqq>[m [1mruntime-options qq>[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 display character set used for the automatic
translation of text values before the values are returned to
the user application. See the Oracle Rdb SQL Reference Manual for
a list of allowable character sets and option values.
3.2 – parameter-marker
Specifies the display character set used for the automatic
translation of text values before the values are returned to
the user application. See the Oracle Rdb SQL Reference Manual for
a list of allowable character sets and option values.
3.3 – 'string-literal'
Specifies the display character set used for the automatic
translation of text values before the values are returned to
the user application. See the Oracle Rdb SQL Reference Manual for
a list of allowable character sets and option values.
4 – Examples
Example 1: Setting the display 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 DEC_MCS
Literal character set is DEC_MCS
Display character set is UNSPECIFIED
SQL> set display character set 'SHIFT_JIS';
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