JDBC Driver for SQL/MX Programmer's Reference

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, see "Data Types" in the SQL/MX Reference Manual.