| 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