NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
M-25
Multibyte Character Sets
•
For a comprehensive example, see the MODIFY LABEL Command on page M-11.
Multibyte Character Sets
SQL supports two multibyte character sets:
•
Kanji
•
KS C5601
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 execute 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 executes the
command, not the node on which the tables reside.