JAVA数据类型与DB2、Oracle、Sybase以及SQL Server对应关系

0 0

java.sql.Types	Java	IBM DB2	Oracle	Sybase	SQL-SERVER	MySql
bigint	java.lang.long	bigint	number(38, 0)	bigint	bigint	bigint
binary	byte[]	CHAR FOR BIT DATA	raw	binary	image	binary
bit	java.lang.Boolean	N/A	bit	bit	bit	bit
blob	byte[]	blob	blob	blob	blob	blob,mediumblob
char	java.lang.String	char , graphic	char	char	char	enum,set,char
clob	java.lang.String	clob, dbclob	clob	clob	clob
date	java.sql.Date	date	date	date	date	date,year
decimal	java.math.BigDecimal	decimal	number	decimal, money, smallmoney	decimal	decimal,numeric
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	mediumint,int
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	float
smallint	java.lang.Integer	smallint	smallint	smallint	smallint	smallint
time	java.sql.Time	time	date	time	time	time
timestamp	java.sql.Timestamp	timestamp	date	datetime , smalldatetime	datetime	timestamp,datetime
tinyint	java.lang.Bute	SMALLINT	tinyint	tinyint	tinyint	tinyint
varbinary	byte[]	varchar for bit data	raw	varbinary	image	varbinary,binary
varchar	java.lang.String	varchar, VARGRAPHIC	varchar	varchar	varchar	varchar,tinytext,text