首页 > 代码库 > java-Mysql-SQLServer数据类型匹配速查表
java-Mysql-SQLServer数据类型匹配速查表
java-Mysql-SQLServer数据类型匹配速查表Mysql************************************当前列 ClassName ColumnType DisplaySize TypeName0: java.lang.Integer ColumnType:4 11 INTEGER1: java.lang.Integer ColumnType:-6 4 TINYINT2: java.lang.String ColumnType:12 0 UNKNOWN3: java.lang.Boolean ColumnType:-7 1 TINYINT4: java.lang.Integer ColumnType:5 6 SMALLINT5: java.lang.Integer ColumnType:4 9 MEDIUMINT6: java.lang.Integer ColumnType:4 11 INTEGER7: java.lang.Long ColumnType:-5 20 BIGINT8: java.lang.Double ColumnType:8 22 DOUBLE9: java.lang.Double ColumnType:8 22 DOUBLE10: java.lang.Float ColumnType:7 12 FLOAT11: java.lang.String ColumnType:12 11 UNKNOWN12: java.lang.String ColumnType:12 11 UNKNOWN13: java.lang.String ColumnType:1 300 CHAR14: java.lang.String ColumnType:12 300 VARCHAR15: java.sql.Date ColumnType:91 10 DATE16: java.sql.Time ColumnType:92 8 TIME17: java.sql.Date ColumnType:91 4 YEAR18: java.sql.Timestamp ColumnType:93 19 TIMESTAMP19: java.sql.Timestamp ColumnType:93 19 DATETIME20: [B ColumnType:-3 255 TINYBLOB21: [B ColumnType:-4 65535 BLOB22: [B ColumnType:-4 16777215 MEDIUMBLOB23: [B ColumnType:-4 -1 BLOB24: java.lang.String ColumnType:12 255 TINYBLOB25: java.lang.String ColumnType:-1 65535 TEXT26: java.lang.String ColumnType:-1 16777215 MEDIUMBLOB27: java.lang.String ColumnType:-1 -1 TEXT28: java.lang.String ColumnType:1 3 CHAR29: java.lang.String ColumnType:1 3 CHARSQLServer***********************************0: java.lang.Integer ColumnType:4 11 int identity1: java.lang.Long ColumnType:-5 20 bigint2: byte[] ColumnType:-2 100 binary3: java.lang.Boolean ColumnType:-7 1 bit4: java.lang.String ColumnType:1 10 char5: java.sql.Timestamp ColumnType:93 23 datetime6: java.sql.Timestamp ColumnType:93 23 datetime7: java.math.BigDecimal ColumnType:3 20 decimal8: java.lang.Double ColumnType:6 22 float9: byte[] ColumnType:-4 2147483647 image10: java.math.BigDecimal ColumnType:3 21 money11: java.lang.String ColumnType:1 10 nchar12: java.lang.String ColumnType:-1 1073741823 ntext13: java.math.BigDecimal ColumnType:2 20 numeric14: java.lang.String ColumnType:12 50 nvarchar15: java.lang.Float ColumnType:7 13 real16: java.sql.Timestamp ColumnType:93 16 smalldatetime17: java.lang.Integer ColumnType:5 6 smallint18: java.math.BigDecimal ColumnType:3 12 smallmoney19: java.lang.String ColumnType:12 8000 sql_variant20: java.lang.String ColumnType:-1 2147483647 text21: byte[] ColumnType:-2 16 timestamp22: java.lang.Integer ColumnType:-6 3 tinyint23: java.lang.String ColumnType:1 36 uniqueidentifier24: byte[] ColumnType:-3 100 varbinary25: java.lang.String ColumnType:12 50 varchar
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。