Table 5-1 “Data Type Mapping” shows what the HP Driver for JDBC
will report as the JDBC data type for each ALLBASE/SQL data type.
These are the java.sql.Types values that will be returned from the
java.sql.ResultSetMetaData.getColumnType method. An "X" in the column
indicates the data type mapping.
A description of each ALLBASE/SQL and JDBC data type can be
found in Appendix A “Data Types”
Table 5-1 Data Type Mapping
JDBC DATA TYPES (vertical) | TINYINT | SMALLINT | INTEGER | BIGINT | REAL | FLOAT | DOUBLE | DECIMAL | NUMERIC | BIT | CHAR | VARCHAR | LONGVARCHAR | BINARY | VARBINARY | LONGVARBINARY | DATE | TIME | TIMESTAMP |
ALLBASE/SQL DATA TYPES (horizontal) |
SMALLINT (16-bits) | | X | | | | | | | | | | | | | | | | | |
INTEGER (32-bits) | | | X | | | | | | | | | | | | | | | | |
REAL | | | | | X | | | | | | | | | | | | | | |
FLOAT(1...24) | | | | | X | | | | | | | | | | | | | | |
FLOAT(25...53) | | | | | | | X | | | | | | | | | | | | |
DOUBLE PRECISION | | | | | | | X | | | | | | | | | | | | |
DECIMAL | | | | | | | | X | | | | | | | | | | | |
NUMERIC | | | | | | | | | X | | | | | | | | | | |
CHAR | | | | | | | | | | | X | | | | | | | | |
VARCHAR | | | | | | | | | | | | X | | | | | | | |
DATE | | | | | | | | | | | | | | | | | X | | |
TIME | | | | | | | | | | | | | | | | | | X | |
DATETIME | | | | | | | | | | | | | | | | | | | X |
INTERVAL | | | | | | | | | | | X | | | | | | | | |