java.sql.types |
java |
 IBM DB2 |
oracle |
sybase |
sql-server |
bigint |
JAVA.LANG.LONG  |
BIGINT  |
number (0) |
bigint |
BIGINT  |
binary |
byte[] |
char for BIT DATA |
raw |
Span style= "font-family:"comic sans ms", Sans-serif; font-size:15px ">binary |
image |
bit |
Span style= "font-family:"comic sans ms", Sans-serif; font-size:15px ">java.lang.boolean |
n/a |
bit |
bit |
bit |
blob |
Span style= "font-family:"comic sans ms", Sans-serif; font-size:15px ">BYTE[]  |
BLOB  |
blob |
BLOB |
blob |
CHAR  |
java.lang.string |
char, GRAPHIC |
char |
char |
char |
clob |
Span style= "font-family:"comic sans ms", Sans-serif; font-size:15px ">JAVA.LANG.STRING  |
clob, Dbclob |
clob |
CLOB  |
CLOB  |
date |
Span style= "font-family:"comic sans ms", Sans-serif; font-size:15px ">java.sql.date |
date |
date |
DATE |
date |
decimal |
java.math.bigdecimal |
DECIMAL  |
number |
decimal, Money, smallmoney |
decimal |
double |
java.lang.double |
double |
double PRECISION |
double precision |
double PRECISION |
float |
java.lang.double |
float |
float |
FLOAT  |
FLOAT  |
integer |
java.lang.integer |
integer |
integer |
int |
INTEGER  |
java_object |
Java.lang.Object |
Java_object |
Java_object |
Java_object |
Java_object |
longvarbinary |
byte[] |
long VARCHAR for BIT DATA |
LONG RAW |
image |
image |
longvarchar |
java.lang.string |
long VARCHAR, LONG vargraphic |
long |
text |
text |
numeric |
java.math.bigdecimal |
numeric |
numeric |
numeric |
numeric |
other |
java.lang.object |
other |
other |
other |
 OTHER  |
real |
java.lang.float |
real |
real |
real |
real |
smallint |
java.lang.integer |
smallint |
smallint |
smallint |
smallint |
time |
java.sql.time |
time |
date |
time |
time |
timestamp |
java.sql.timestamp |
timestamp |
date |
datetime, smalldatetime |
datetime |
tinyint |
java.lang.bute |
smallint |
tinyint |
tinyint |
tinyint |
varbinary |
byte[" |
varchar for BIT DATA |
raw |
varbinary |
image |
VARCHAR |
Java.lang.String |
VARCHAR, Vargraphic |
VARCHAR |
VARCHAR |
VARCHAR |
Java data types correspond to DB2, Oracle, Sybase, and SQL Server