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

ManualsBrandsHP ManualsServerHP NonStop G-Series

591

592

593

594

595

596

597

598

599

600

SQL/MX Language Elements

HP NonStop SQL/MX Reference Manual—523725-004

6-3

Character Sets

When you install NonStop SQL/MX, you are prompted to set the character set default

to UCS2 or ISO88591. If you do not specify a character set, the default is UCS2. Once

it is set, you cannot change it.

After you have set the character set default, when you create SQL/MX tables, NCHAR

data type fields use this character set as the default.

Within programs, NonStop SQL/MX allows you to associate one of these character

sets with a literal or host variable:

KANJI and KSC5601 are valid only for SQL/MP tables.

Restrictions on Using Character Set Data

For SQL/MX tables, only ISO88591 characters are allowed in these fields:

In addition, user data fields must use either ISO88591 or UCS2. KANJI and KSC5601

are not allowed.

ISO88591 Default single-byte 8-bit character set for character data types, which

supports English and other Western European languages.

UCS2 Double-byte Unicode character set in UTF16 big-endian encoding. All

Basic Multilingual Plan (BMP) characters are included. Surrogate

characters are treated as two double-byte characters.

KANJI Double-byte character set widely used on Japanese mainframes. It is a

subset of Shift JIS (the double character portion). Its encoding is

big-endian.

KSC5601 Double-byte character set required on systems used by government

and banking within Korea. Its encoding is big-endian.

ISO88591 Field Where Found

BY partitioning-column CREATE INDEX, CREATE TABLE statements

FIRST KEY values CREATE TABLE, CREATE INDEX statements; MODIFY TABLE

utility.

CHECK constraint text CREATE TABLE and ALTER TABLE statements

Column HEADING

text

CREATE TABLE and ALTER TABLE statement

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