首页 > 代码库 > 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