Communicator e3000 MPE/iX Release 6.5 (Non-Platform Software Release C.65.00 (30216-90291)

156 Chapter5
Internet and Interoperability
HP Driver for JDBC
indicates the data type mapping.
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.
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
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