java-Mysql-SQLServer数据类型匹配速查表

java-Mysql-SQLServer数据类型匹配速查表
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
***********************************
0:  java.lang.Integer     ColumnType:4     11      int identity
1:  java.lang.Long     ColumnType:-5   20      bigint
2:  byte[]            ColumnType:-2   100      binary
3:  java.lang.Boolean     ColumnType:-7   1       bit
4:  java.lang.String      ColumnType:1     10      char
5:  java.sql.Timestamp    ColumnType:93   23      datetime
6:  java.sql.Timestamp   ColumnType:93   23      datetime
7:  java.math.BigDecimal  ColumnType:3     20      decimal
8:  java.lang.Double     ColumnType:6     22      float
9:   byte[]           ColumnType:-4   2147483647 image
10:  java.math.BigDecimal  ColumnType:3     21       money
11:  java.lang.String     ColumnType:1     10       nchar
12:  java.lang.String     ColumnType:-1   1073741823 ntext
13:  java.math.BigDecimal  ColumnType:2     20      numeric
14:  java.lang.String     ColumnType:12   50      nvarchar
15:  java.lang.Float     ColumnType:7     13      real
16:  java.sql.Timestamp   ColumnType:93   16      smalldatetime
17:  java.lang.Integer     ColumnType:5     6       smallint
18:  java.math.BigDecimal  ColumnType:3     12       smallmoney
19:  java.lang.String     ColumnType:12   8000     sql_variant
20:  java.lang.String     ColumnType:-1   2147483647 text
21:  byte[]           ColumnType:-2  16  timestamp
22:  java.lang.Integer     ColumnType:-6  3  tinyint
23:  java.lang.String  ColumnType:1  36  uniqueidentifier
24:  byte[]      ColumnType:-3  100  varbinary
25:  java.lang.String  ColumnType:12  50  varchar

  

java-Mysql-SQLServer数据类型匹配速查表,布布扣,bubuko.com

java-Mysql-SQLServer数据类型匹配速查表

上一篇:vue引入echarts报错:Error in mounted hook: "TypeError: Cannot read property 'init' of undefined"


下一篇:System Center 2012 R2 POC部署之数据库SQL2012部署