1
常见数据库字段类型与 java.sql.Types
的对应
2
3
Oracle 与 java.sql.Types
的对应
4
5
Oracle java.sql.Types
6
7
blob blob
8
char
char
9
clob clob
10
date date
11
number decimal
12
long
varbinary
13
nclob,nvarchar2 other
14
smallint smallint
15
timestamp timstamp
16
raw varbinary
17
varchar2 varchar
18
19
Sql server 与 java.sql.Types
的对应
20
21
Sql server java.sql.Types
22
bigint (
2005
,
2008
) bigint
23
timstamp,binary binary
24
bit bit
25
char
,nchar,unqualified
char
26
datetime date
27
money,smallmoney,decimal decimal
28
float
(
2005
,
2008
)
double
29
float
(
2000
)
float
30
int
integer
31
image longvarbinary
32
text,ntext,xml longvarchar
33
numeric numeric
34
real real
35
smallint smallint
36
datetime,smalldatetime timestamp
37
tinyint tinyint
38
varbinary varbinay
39
nvarchar,varchar varchar
40
41
DB2 与 java.sql.Types
的对应
42
43
bigint bigint