Library /sys$common/syshlp/SQL$HELP72.HLB  —  Supported Character Sets, Literal Character Sets
    The literal character set is the character set SQL uses for
    unqualified character string literals.

    You can specify the literal character set only for a session
    or a module by using the SET LITERAL CHARACTER SET statement or
    the LITERAL CHARACTER SET clause of the SQL module header, the
    DECLARE MODULE statement, or the DECLARE ALIAS statement.

    When inserting data into a column, you must qualify the literal
    with the same character set with which you defined the column.

    For example, suppose that the literal character set of the
    module is DEC_MCS. If the column ENGLISH is defined as data type
    DEC_MCS, SQL returns an error when you execute the following
    statement:

    SQL> INSERT INTO COLOURS
    cont>    (ENGLISH)
    cont> VALUES
    cont>    (_DEC_KANJI'Black');
    %SQL-F-INCCSASS, Incompatible character set assignment between ENGLISH and
    <value expression>
    SQL>
Close Help