88
bit bit
89
char
,nchar,
char
90
money,smallmoney,decimal decimal
91
float
double
92
int
integer
93
image longvarbinary
94
text longvarchar
95
numeric numeric
96
real real
97
smallint smallint
98
datetime,smalldatetime timestamp
99
tinyint tinyint
100
varbinar,timestamp varbinay
101
nvarchar,varchar ,sysname varchar
Mysql/SQLServer 数据类型对应的 JDBC 类型、JAVA
类型,数据类型长度 速查表
2010 年 05 月 14
日 星期五 11:16
Mysql
************************************
当前列 ClassName
ColumnType DisplaySize TypeName
0:
java.lang.Integer ColumnType:4 11 INTEGER
1:
java.lang.Integer ColumnType:-6 4 TINYINT
2:
java.lang.String
ColumnType:12 0 UNKNOWN
3:
java.lang.Boolean ColumnType:-7 1 TINYINT
4:
java.lang.Integer ColumnType:5
6 SMALLINT
5:
java.lang.Integer ColumnType:4
9 MEDIUMINT
6:
java.lang.Integer ColumnType:4 11 INTEGER
7:
java.lang.Long
ColumnType:-5
20 BIGINT
8:
java.lang.Double
ColumnType:8 22 DOUBLE
9:
java.lang.Double
ColumnType:8 22 DOUBLE
10: java.lang.Float ColumnType:7 12 FLOAT
11: java.lang.String
ColumnType:12
11 UNKNOWN
12: java.lang.String
ColumnType:12
11 UNKNOWN
13: java.lang.String
ColumnType:1
300 CHAR
14: java.lang.String
ColumnType:12 300 VARCHAR
15: java.sql.Date ColumnType:91
10 DATE
16: java.sql.Time ColumnType:92 8 TIME
17: java.sql.Date ColumnType:91 4 YEAR
18: java.sql.Timestamp
ColumnType:93
19 TIMESTAMP
19: java.sql.Timestamp
ColumnType:93
19 DATETIME
20: [B
ColumnType:-3 255
TINYBLOB
21: [B
ColumnType:-4 65535
BLOB
22: [B
ColumnType:-4 16777215 MEDIUMBLOB
23: [B
ColumnType:-4 -1
BLOB
24: java.lang.String ColumnType:12 255
TINYBLOB
25: java.lang.String ColumnType:-1 65535 TEXT
26: java.lang.String ColumnType:-1 16777215 MEDIUMBLOB
27: java.lang.String ColumnType:-1 -1
TEXT
28: java.lang.String ColumnType:1
3
CHAR
29: java.lang.String ColumnType:1
3
CHAR
SQLServer