| Liquibase类型 | 别名 |
| boolean | {“java.sql.Types.BOOLEAN”, “java.lang.Boolean”, “bit”, “bool”} |
| tinyint | java.sql.Types.TINYINT |
| smallint | {“java.sql.Types.SMALLINT”, “int2”} |
| mediumint | 无 |
| int | { “integer”, “java.sql.Types.INTEGER”, “java.lang.Integer”, “serial”, “int4”, “serial4” } |
| bigint | {“java.sql.Types.BIGINT”, “java.math.BigInteger”, “java.lang.Long”, “integer8”, “bigserial”, “serial8”, “int8”} |
| decimal | { “java.sql.Types.DECIMAL”, “java.math.BigDecimal” } |
| number | {“numeric”, “java.sql.Types.NUMERIC”} |
| float | {“java.sql.Types.FLOAT”, “java.lang.Float”, “real”, “java.sql.Types.REAL”} |
| double | {“java.sql.Types.DOUBLE”, “java.lang.Double”} |
| currency | {“money”, “smallmoney”} |
| nchar | { “java.sql.Types.NCHAR”, “nchar2”} |
| nvarchar | {“java.sql.Types.NVARCHAR”, “nvarchar2”, “national”} |
| char | {“java.sql.Types.CHAR”, “bpchar”} |
| varchar | {“java.sql.Types.VARCHAR”, “java.lang.String”, “varchar2”, “character varying”} |
| clob | {“longvarchar”, “text”, “longtext”, “java.sql.Types.LONGVARCHAR”, “java.sql.Types.CLOB”, “nclob”, “longnvarchar”, “ntext”, “java.sql.Types.LONGNVARCHAR”, “java.sql.Types.NCLOB”, “tinytext”, “mediumtext”} |
| blob | {“longblob”, “longvarbinary”, “java.sql.Types.BLOB”, “java.sql.Types.LONGBLOB”, “java.sql.Types.LONGVARBINARY”, “java.sql.Types.VARBINARY”, “java.sql.Types.BINARY”, “varbinary”, “binary”, “image”, “tinyblob”, “mediumblob”} |
| date | {“java.sql.Types.DATE”, “java.sql.Date”} |
| time | {“java.sql.Types.TIME”, “java.sql.Time”, “timetz”} |
| datetime | 无 |
| timestamp | {“java.sql.Types.TIMESTAMP”, “java.sql.Types.TIMESTAMP_WITH_TIMEZONE”, “java.sql.Timestamp”, “timestamptz”} |
| uuid | { “uniqueidentifier”, “java.util.UUID” } |
| xml | { “xmltype”, “java.sql.Types.SQLXML” } |
| function | liquibase.statement.DatabaseFunction |
原创文章，作者：huoxiaoqiang，如若转载，请注明出处：https://www.huoxiaoqiang.com/experience/javae/8675.html
微信扫一扫 
支付宝扫一扫