JDBC Type 2 Driver Programmer's Reference for SQL/MX Release 3.1 (H06.23+, J06.12+)

Java applications using the JDBC/MX driver can specify the Java file.encoding property to set the default
encoding to any character set supported by Java if no SQL literals exist in the program. If the program has
SQL literals, the program should use only the Java encoding sets that correspond to SQL/MX supported
sets.
The JDBC/MX driver supports the reading and writing of SQL CHAR, VARCHAR, VARCHAR_LONG, and
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.