SQL$HELP72.HLB  —  Supported Character Sets, Identifier Character Set
    The identifier character set is the character set SQL uses for
    database object names, such as table names and column names.
    You can specify the identifier character set at the session and
    database level. The choice of identifier character set is limited
    to those character sets that include ASCII characters. This is
    necessary so that the object names for the Oracle Rdb system
    metadata, which is in ASCII, can be stored.

    You can specify the identifier character set for the database
    only when you create the database. You cannot alter the
    identifier character set of a database after creation.

    Following is a list of the character sets used for the identifier
    character set:

    o  ASCII

    o  AL24UTFFSS

    o  DEC_MCS

    o  DOS_LATIN1

    o  DOS_LATINUS

    o  DEVANAGARI

    o  DEC_SICGCC

    o  DEC_HANYU

    o  DEC_HANZI

    o  GB18030

    o  ISOLATINARABIC

    o  ISOLATINCYRILLIC

    o  ISOLATIN1

    o  ISOLATIN9

    o  ISOLATINGREEK

    o  ISOLATINHEBREW

    o  DEC_KANJI

    o  KATAKANA

    o  DEC_KOREAN

    o  SHIFT_JIS

    o  UTF8

    o  UNSPECIFIED

    o  TACTIS

    o  WIN_ARABIC

    o  WIN_GREEK

    o  WIN_CYRILLIC

    o  WIN_HEBREW

    When you compile SQL programs (either SQL module language or
    precompiled SQL), SQL uses the following to derive the identifier
    character set:

    o  The IDENTIFIER 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 IDENTIFIER 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.

    SQL uses DEC_MCS as the identifier character set, unless you have
    set the dialect to MIA or specified an identifier character set
    at the session level. You can override any identifier character
    set by specifying another identifier character set when creating
    a database.
Close Help