JDBC/MX 5.0 Driver for SQL/MX Programmer's Reference (SQL/MX 2.x)

VARCHAR_WITH_LENGTH data types only when using the SQL/MX supported character sets listed in the
subsequent table.
The JDBC/MX driver encodes and decodes String data types as a function of the associated character set name for the
particular SQL database column independent of the default encoding.
The format of the Java file.encoding property is:
-Dfile.encoding=encoding
Note: SQL/MX supports a subset of encoding sets supported by NonStop Server for Java 4.
Corresponding SQL/MX Character Sets and Java Encoding Sets
SQL/MX
Character Set
Corresponding
Java Encoding
Set—Canonical
Name for java.io
API
Corresponding Java
Encoding Set—
Canonical Name for
java.io and java.lang API
Description
ISO88591 ISO-8859-1 ISO8859_1
Single-character, 8-bit,
character set for
character-data type. It
supports English and
other Western European
languages.
UCS2 UTF-16BE UnicodeBigUnmarked
Universal Character Set
encoded in 2 bytes.
Double-character
Unicode character set in
UTF16 big-endian
encoding.
NOTE: UCS2 is
supported in SQL/MX
tables only.
KANJI Shift_JIS SJIS
The multibyte character
set widely used on
Japanese mainframes. It
is composed for a
single-byte character set
and a double-byte
character set. It is a
subset of Shift JIS (the
double character
portion). Its encoding is
big-endian.
NOTE: KAJNI is
supported in SQL/MP
tables only.
Double-character
character set required on