SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Language Elements
HP NonStop SQL/MX Reference Manual—523725-004
6-4
Restrictions on Using Character Set Data
In SQL/MP, a character data type has an associated character set and collation that
can be implicitly or explicitly specified. Internally, the ISO88591 character set is
implemented as an 8-bit data type, while the UCS2, KANJI, and KSC5601 character
sets are implemented as 16-bit data types. The CHAR data type can be associated
with any of the character sets. The NCHAR data type is typically associated with the
UCS2 character set.
You can insert into and update NCHAR columns in an SQL/MP table. See Character
String Literals on page 6-62. You can query SQL/MP tables that have columns
associated with the KANJI or KSC5601 character sets.