java中常见数据库字段类型与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