JDBC Driver for SQL/MP 3.0

Compatible Java and SQL/MP Data Types
This table shows which Java data types can hold which SQL/MP data types. Use this table to determine which get()
method to call to read a particular type of data from a result set or which set() method to call to define the data type
of a prepared statement's input parameter. For example, if you select CHAR data from a database, use getString() to
retrieve the CHAR data from the result set.
Compatible Java and SQL/MP Data Types
SQL Data Types
S
M
A
L
L
I
N
T
I
N
T
E
G
E
R
L
A
R
G
E
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
C
H
A
R
V
A
R
C
H
A
R
D
A
T
E
T
I
M
E
T
I
M
E
S
T
A
M
P
D
A
T
E
T
I
M
E
J
a
v
a
D
a
t
a
T
y
p
e
s
Byte
R s s s s s s s s s n n n n
Short
R s s s s s s s s s n n n n
Int
s R s s s s s s s s n n n n
Long
s s R s s s s s s s n n n n
Float
s s s R s s s s s s n n n n
Double
s s s s s R s s s s n n n n
BigDecimal
s s s s s s R s s s n n n n
BigInteger
s s s s s s s s R s n n n n
Boolean
R s s s s s s s s s n n n n
String
s s s s s s s s R R n n n n
Bytes
n n n n n n n n n n n n n n
Date
n n n n n n n n n n R n n s
Time
n n n n n n n n n n n R n s
Timestamp
n n n n n n n n n n n n R R
AsciiStream
n n n n n n s n R R n n n n
UnicodeStream
n n n n n n n n n n n n n n
BinaryStream
n n n n n n n n n n n n n n
Object
s s s s s s s s s s n n n n