HP Driver for JDBC User's Manual

Chapter 5 45
ALLBASE/SQL Specifics
ALLBASE/SQL to JDBC Data Type Conversions
ALLBASE/SQL to JDBC Data Type
Conversions
Table 5-2 shows the supported data type conversions between
ALLBASE/SQL and JDBC. For conversions from JDBC to Java, please
refer to a JDBC book or the Java JDBC documentation. Those
conversions are generic to all JDBC Drivers.
A description of each ALLBASE/SQL and JDBC data type can be found
in Appendix A , “Data Types.”
Suggested conversions are denoted by a capital letter “X” in the
conversion grid. Conversions which are supported, but which may
result in a loss of precision, overflow, or rounding, are denoted by a
lowercase letter “x” in the conversion grid.
Table 5-2 Data Type Conversions
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 X X XXXXXXxXXXxxx
INTEGER (32-bits) x x X X xxxXXxXXXxxx
REAL x x x x XXXXXXXXXxxx
FLOAT(1...24) x x x xxxXXXXXXXxxx
FLOAT(25...53) x x x xxxXXXXxxxxxx
DOUBLE
PRECISION
xxxxxxXXXxXXXxxx
DECIMAL x x x xxxxXXxXXXxxx
NUMERIC x x x xxxxXXxXXXxxx
CHAR x x x xxxxxxxXXXxxx
VARCHAR x x x xxxxxxxXXXxxx
DATE XXX x x x X x
TIME XXXxxx Xx
DATETIME X X X x x xxxX
INTERVAL X X X x x x