数据库和java.sql.Types之间的对应

数据库和java.sql.Types之间的对应

Oracle与java.sql.Types的对应

Oracle                                java.sql.Types
blob                                     blob
char                                     char
clob                                     clob
date                                    date
number                               decimal
long                                     varbinary
nclob,nvarchar2                   other
smallint                                smallint
timestamp                            timstamp
raw                                      varbinary
varchar2                               varchar

Sql server与java.sql.Types的对应

Sql server                           java.sql.Types
bigint (2005,2008)                bigint
timstamp,binary                    binary
bit                                         bit
char,nchar,unqualified          char
datetime                               date
money,smallmoney,decimal  decimal
float (2005,2008)                  double
float(2000)                            float
int                                          integer
image                                    longvarbinary
text,ntext,xml                        longvarchar

numeric                                 numeric
real                                       real
smallint                                smallint
datetime,smalldatetime       timestamp
tinyint                                  tinyint
varbinary                             varbinay
nvarchar,varchar                 varchar

DB2与java.sql.Types的对应

bigint                                       bigint
blob                                      blob
character,graphic                 char
clob                                      clob
date                                     date
decimal                                decimal
double                                 double
integer                               integer
longvargraphic                   longvarchar
longvarchar

real                                        real
smallint                                 smallint
time                                      time
timestamp                            timestamp
vargraphic                            varchar
varchar

MySQL与java.sql.Types的对应

MySQL                          java.sql.Types
bigint                              bigint
tinyblob                         binary
bit                                  bit
enum,set,char               char
date,year                      date
decimal,numeric            decimal
double,real                   double
mediumint,int                integer
blob,mediumblob           blob
longblob
float                               real

smallint                           smallint
time                             time
timestamp,datetime     timestamp
tinyint                           tinyint
varbinary,binary           varbinay
varchar,tinytext,text     varchar
Sybase与java.sql.Types的对应

Sybase                            java.sql.Types
binary                                 binary
bit                                       bit
char,nchar,                            char
money,smallmoney,decimal    decimal
float                                     double
int                                       integer
image                                    longvarbinary
text                                      longvarchar
numeric                                   numeric
real                                     real
smallint                              smallint
datetime,smalldatetime     timestamp
tinyint                                 tinyint
varbinar,timestamp            varbinay
nvarchar,varchar ,sysname   varchar