Software Internationalization Guide

The HP Internationalization Subsystem
Software Internationalization Guide—526225-002
4-12
Internationalization Functions and HP NonStop
SQL/MX
A default Guardian character set can be established, separate from that of the OSS
locale in use; the Guardian default character set can be determined by calling the
MBCS_DEFAULTCHARSET_ procedure.
Collating sequences for Guardian procedure calls are not affected by OSS locale or by
the use of the Guardian multibyte character-set procedures. Individual procedure call
features provide the only control over data collation.
Date-Time Formats
Date and time information returned or displayed by Guardian procedure calls are not
affected by locale. Individual procedure call features provide the only format controls
for both kinds of data.
Message Text
Run-time diagnostic messages do not vary by locale.
Internationalization Functions and HP NonStop SQL/MX
SQL/MX is not locale-sensitive and does not use the OSS internationalization features.
Character Sets and Collating Sequences
SQL/MX supports a subset of the character sets supported by OSS. For more
information about SQL/MX character sets, see the SQL/MX Reference Manual. For
information about using character sets in SQL/MX applications, see the SQL/MX
Programming Manual for Java and the SQL/MX Programming Manual for C and
COBOL.
Unlike SQL/MP, you cannot create collations for SQL/MX tables and cannot use
SQL/MP collations on SQL/MX tables. SQL/MX Release 2.0 supports only the
DEFAULT collation. The DEFAULT collation is based on binary ordering and is the
default collating sequence for CHAR and NCHAR data types.
Each column of character data in an SQL/MX database is permanently associated with
a character set when the column is created. You can specify a different character set
for different columns in a table, but you cannot change the character set associated
with a column after the column is created.
Single-Byte Character Sets
SQL/MX supports ISO88591. For more information, see the SQL/MX Reference
Manual.
Double-Byte Character Sets
SQL/MX allows you to define a character column with UCS2 and to associate UCS2
with a string literal or host variable. If you are using SQL/MP tables with SQL/MX
Release 2.0, you can also use KANJI and KSC5601 for string literals, host variables, or