SQL$HELP72.HLB  —  Supported Character Sets, Default Character Sets
    The default character set is the character set that SQL uses for
    the following elements:

    o  Database columns with a character data type that does not
       explicitly specify a character set

    o  Parameters that are not qualified by a character set

    You can specify the default character set at the session and
    database level. See the Oracle Rdb Introduction to SQL and Oracle
    Rdb Guide to Database Design and Definition for more detail about
    session and database character sets.

    You can specify the database default character set only when
    you create the database. You cannot change the database default
    character set after you have created the database.

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

    To specify the default character set, use one of the character
    set names listed in Supported Character Sets.

    The default character set does not affect the setting of the
    currency sign.

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

    o  The DEFAULT CHARACTER SET clause in the DECLARE ALIAS
       statement specifies the default character set of the alias
       at compile time. At run time, SQL uses the default character
       set of the attached database. At run time, you must ensure
       that the database default character set is identical to the
       default character set specified in the DECLARE ALIAS clause.

    o  The DEFAULT 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 DEFAULT 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.
Close Help