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

Standard SQL and SQL/MX
HP NonStop SQL/MX Reference Manual—540440-003
E-7
Character Set Support
Character Set Support
NonStop SQL/MX supports a limited number of national, international, and
vendor-specific encoded character set standards: ISO88591, UCS2, KANJI and
KSC5601.
Unicode is a universal encoded character set that lets you store information from any
language using a single character set. Modern standards, such as XML, Java, Java
Script, and LDAP, require Unicode. Unicode complies with ISO/IEC standard 10646. To
obtain a copy of ISO/IEC standard 10646, see the Web sites listed under ISO
Standards on page E-2.
SQL/MX Release 2.x complies fully with the Unicode 2.1 standard. For more
information about this standard, see the Web site of the Unicode Consortium:
http://www.unicode.org
NonStop SQL/MX uses UTF-16BE (16-bit) encoding for the Unicode (UCS2) character
set. The full range of UTF-16 characters is allowed, but surrogate pairs are not
recognized as characters. NonStop SQL/MX uses single-byte encoding for ISO88591
character set and permits wide-character KANJI and KSC5601 character set host
variables in embedded applications that query SQL/MP tables.
NonStop SQL/MX relaxes SQL:1999's data type matching rule for UCS2 character set
host variables for ease of use and better performance. A UCS2 host variable is
assignment and comparison compatible with an ISO88591 value expression.
NonStop SQL/MX allows various SQL:1999's NATIONAL CHARACTER syntax to
denote a predesignated character set. The default NATIONAL character set is UCS2.
You can specify a different default character set during SQL/MX installation.
NonStop SQL/MX uses binary collation (that is, comparison of binary code values) to
compare character strings.
NonStop SQL/MX complies fully with SQL:1999 for these character data type
subfeatures: character string data type declaration, character value expression, search
condition, string functions and predicates, string literals and host variables in C/COBOL
embedded programs.
T211 Basic trigger capability (except for T211-07 Trigger privilege)
T212 Enhanced trigger capability
T441 ABS and MOD functions
T621 Enhanced numeric functions
Note. KANJI and KSC5601 are valid character sets for SQL/MP tables but not SQL/MX tables.
If you attempt to create an SQL/MX table with KANJI, KSC5601, or other unsupported
character sets, you get an SQL error and the operation fails.
ID Feature