SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Language Elements
HP NonStop SQL/MX Reference Manual—540440-003
6-4
Restrictions on Using Character Set Data
In addition, user data fields in SQL/MX tables must use either ISO88591 or UCS2.
KANJI and KSC5601 are not allowed.
In SQL/MP tables, 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-60. You can query SQL/MP tables that have columns
associated with the KANJI or KSC5601 character sets.
View text CREATE VIEW statement
$volume specification CREATE CATALOG, CREATE TABLE, CREATE INDEX, CREATE
PROCEDURE, CREATE VIEW, DUP, and PURGEDATA
statements; MODIFY and RESTORE utilities
SQL/MX names Names of catalogs, columns, constraints, indexes, schemas,
stored procedures, tables, and views
ISO88591 Field Where Found