HP Driver for JDBC User's Manual

44 Chapter5
ALLBASE/SQL Specifics
ALLBASE/SQL to JDBC Data Type Mapping
ALLBASE/SQL to JDBC Data Type Mapping
Table 5-1 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)
T
I
N
Y
I
N
T
S
M
A
L
L
I
N
T
I
N
T
E
G
E
R
B
I
G
I
N
T
R
E
A
L
F
L
O
A
T
D
O
U
B
L
E
D
E
C
I
M
A
L
N
U
M
E
R
I
C
B
I
T
C
H
A
R
V
A
R
C
H
A
R
L
O
N
G
V
A
R
C
H
A
R
B
I
N
A
R
Y
V
A
R
B
I
N
A
R
Y
L
O
N
G
V
A
R
B
I
N
A
R
Y
D
A
T
E
T
I
M
E
T
I
M
E
S
T
A
M
P
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