Liquibase类型 | 别名 |
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”} |
currency | {“money”, “smallmoney”} |
float | {“java.sql.Types.FLOAT”, “java.lang.Float”, “real”, “java.sql.Types.REAL”} |
double | {“java.sql.Types.DOUBLE”, “java.lang.Double”} |
boolean | {“java.sql.Types.BOOLEAN”, “java.lang.Boolean”, “bit”, “bool”} |
date | {“java.sql.Types.DATE”, “java.sql.Date”} |
time | {“java.sql.Types.TIME”, “java.sql.Time”, “timetz”} |
datetime | {“java.sql.Types.DATETIME”, “java.util.Date”, “smalldatetime”, “datetime2”} |
timestamp | {“java.sql.Types.TIMESTAMP”, “java.sql.Types.TIMESTAMP_WITH_TIMEZONE”, “java.sql.Timestamp”, “timestamptz”} |
char | {“java.sql.Types.CHAR”, “bpchar”, “character”} |
nchar | { “java.sql.Types.NCHAR”, “nchar2”} |
varchar | {“java.sql.Types.VARCHAR”, “java.lang.String”, “varchar2”, “character varying”} |
nvarchar | {“java.sql.Types.NVARCHAR”, “nvarchar2”, “national”} |
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”} |
uuid | { “uniqueidentifier”, “java.util.UUID” } |
xml | { “xmltype”, “java.sql.Types.SQLXML” } |
function | liquibase.statement.DatabaseFunction |
unknown | 无 |
原创文章,作者:huoxiaoqiang,如若转载,请注明出处:https://www.huoxiaoqiang.com/experience/javae/8675.html