SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
M-43
Multibyte Character Sets

This summary information is displayed if either LISTALL or NO LISTALL is
specified:
Summary Information:
nnn catalog(s) registered.
nnn catalog(s) not registered.

For a comprehensive example, see the MODIFY LABEL on page M-20.
Multibyte Character Sets
SQL supports two multibyte character sets:

Kanji

KSC5601
Multibyte character sets are described under the entry Character Sets and can be
associated with columns, literals, host variables, and parameters. (You cannot use
multibyte character sets in collations. SQL always collates multibyte character values
according to the binary representation of the characters.)
System Default National Character Set
Each node in a network that runs NonStop SQL/MP has a system default national
character set associated with it. SQL uses the system default national character set
when your SQL statements specify the data type NATIONAL CHARACTER or NCHAR,
or when you use the national character form of a string literal.
The released system default national character set is Kanji, but your site can change
the default to one of the other multibyte character sets during a SYSGEN. You can use
the system procedure MBCS_DEFAULTCHARSET (described in the Guardian
Procedure Calls Reference Manual) to determine the current system default national
character set for a node.
SQL returns an error if you try to create an SQL column with a NATIONAL
CHARACTER or NCHAR data type on a node with a system default multibyte
character set that SQL does not support. The same error occurs if you use a string
literal with the prefix N (indicating the system default multibyte character set) on such a
node.
If you run SQL DDL or DML statements that use the national character data type to
create tables or manipulate data on a node with a different system default multibyte
character set, the character set used is the default on the node that runs the command,
not the node on which the tables reside.