1  SET_DISPLAY_CHARACTER_SET
   Specifies the display character set.
 

2  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

 SET DISPLAY CHARACTER SET ---> runtime-options -->



 runtime-options
 
 --+---> 'string-literal' ------+----->
   +---> parameter -------------+
   +---> parameter-marker ------+

 

2  Arguments
 

3  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  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  '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.
 

2  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