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

text longvarchar

numeric numeric

real real

smallint smallint

datetime,smalldatetime timestamp

tinyint tinyint

varbinar,timestamp varbinay

nvarchar,varchar ,sysname varchar