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