SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Metadata Tables

HP NonStop SQL/MX Reference Manual—544517-008

10-50

National Character Set

This attribute determines the default for the national character set:

For more information about the use of the N'string' literal, see Character String

Literals on page 6-61.

For more information about the use of the NCHAR keyword, see Character String Data

Types on page 6-20.

For a description of available character sets, see Character Sets on page 6-4.

Nonaudited Tables

This attribute enables NonStop SQL/MX to handle inserts, updates, and deletes

against nonaudited SQL/MP tables:

Attribute Setting

NATIONAL_CHARSET Displays the national character set ISO88591, UCS2,

KANJI, or KSC5601 used in NCHAR and NCHAR

VARYING columns. The national character set also

governs the interpretation of the character string literal

N'string.'

You select the national character set when you install

NonStop SQL/MX by using the -n option of the

InstallSqlmx script. If you specify KANJI or

KSC5601 and later attempt to create an SQL/MX table

with an NCHAR column, you will receive an error

message because SQL/MX tables do not support the

KANJI or KSC5601 character sets. If you do not specify

a value for the -n option, the national character set

defaults to UCS2.

For more information about setting the national

character set from the InstallSqlmx script, see the

SQL/MX Installation and Management Guide.

Caution. If the IUD_NONAUDITED_INDEX_MAINT is set to ON, NonStop SQL/MX allows

DML operations on nonaudited tables without error or warning. Before you set this attribute,

see the SQL/MX Comparison Guide for SQL/MP Users to understand index maintenance of

nonaudited tables.