Liquibase映射类型一览表

huoxiaoqiang • 2022年8月2日 10:07 • Java经验 • 阅读 625

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

Liquibase映射类型一览表

相关推荐

JDBC数据库编程详解

Java程序的两种运行方式

Maven构建工具的安装步骤

发表回复