JDBC Type 2 Driver 3.0 Programmer's Reference (SQL/MX 3.x)

Types.VARCHAR
Yes
VARCHAR(n)
* See Floating Point Support.
** For details about maximum length, see the
SQL/MX Reference
Manual
.
The JDBC/MX driver maps the following SQL/MX data types to the JDBC data type
Types.OTHER:
DATETIME YEAR
DATETIME YEAR TO MONTH
DATETIME YEAR TO DAY
DATETIME YEAR TO HOUR
DATETIME YEAR TO MINUTE
DATETIME MONTH
DATETIME MONTH TO DAY
DATETIME MONTH TO HOUR
DATETIME MONTH TO SECOND
DATETIME DAY
DATETIME DAY TO HOUR
DATETIME DAY TO MINUTE
DATETIME DAY TO SECOND
DATETIME HOUR
DATETIME HOUR TO MINUTE
DATETIME MINUTE
DATETIME MINUTE TO SECOND
DATETIME SECOND
DATETIME FRACTION
INTERVAL YEAR(p)
INTERVAL YEAR(p) TO MONTH
INTERVAL MONTH(p)
INTERVAL DAY(p)
INTERVAL DAY(p) TO HOUR
INTERVAL DAY(p) TO MINUTE
INTERVAL DAY(p) TO SECOND
INTERVAL HOUR(p)
INTERVAL HOUR(p) TO MINUTE
INTERVAL HOUR(p) TO SECOND
INTERVAL MINUTE(p)
INTERVAL MINUTE(p) TO SECOND
INTERVAL SECOND(p)
Floating-Point Support
The JDBC/MX driver and the NonStop Server for Java pass any FLOAT (32-bit) number or DOUBLE (64-bit)
number in the IEEE
754 floating-point format.
Floating-point values are stored in SQL/MX tables as IEEE 754 values.
Floating-point values are stored in SQL/MP tables in Tandem format (called TNS format in OSS terminology.
For floating-point values stored in SQL/MP tables in the Tandem format, SQL/MX performs the conversion
from the IEEE 754 format to the Tandem format when storing the values and from the Tandem format to
the IEEE 754 format when retrieving and passing the values.
Since SQL/MX tables store IEEE 754 floating-point values, JDBC applications accessing floating-point data
do not receive floating-point exceptions. The JDBC applications should check for plus (
+) or minus (-)
infinity conditions to determine if an overflow or underflow has occurred. Applications can also encounter a
not-a-number value being passed back, for example, for numbers divided by zero. This processing is done
according to the IEEE 754 standard.
SQL/MP tables can generate floating-point exceptions.
For the range of floating-point values and double-precision values for IEEE 754 format and TNS format,
see
the NonStop Server for Java Programmer's Reference
. For information on floating-point formats in SQL/MX,