title: Liquibase
permalink: SQLNotes/Liquibase
category: SQLNotes
parent: SQLNotes
layout: default
has_children: false
share: true
shortRepo:

• sqlnotes
• default

@Grab('org.liquibase:liquibase-core:3.5.1')            
            
import liquibase.database.core.*            
import liquibase.datatype.core.*            
            
def            
        datatypes = [BooleanType, TinyIntType, IntType, MediumIntType, BigIntType, FloatType, DoubleType, DecimalType, NumberType, BlobType, DatabaseFunctionType, UnknownType, DateTimeType, TimeType, TimestampType, DateType, CharType, VarcharType, NCharType, NVarcharType, ClobType, CurrencyType, UUIDType]            
def            
        databases = [MySQLDatabase, SQLiteDatabase, H2Database, PostgresDatabase, UnsupportedDatabase, DB2Database, MSSQLDatabase, OracleDatabase, HsqlDatabase, FirebirdDatabase, DerbyDatabase, InformixDatabase, SybaseDatabase, SybaseASADatabase]            
datatypes.each {            
    def datatype = it.newInstance()            
    datatype.finishInitialization("")            
    println datatype.name            
    databases.each { println "$it.simpleName: ${datatype.toDatabaseDataType(it.newInstance())}" }            
    println ''            
}             

MySQLDatabase : BIT(1)

SQLiteDatabase : BOOLEAN

H2Database : BOOLEAN

PostgresDatabase : BOOLEAN

UnsupportedDatabase : BOOLEAN

DB2Database : SMALLINT

MSSQLDatabase : [bit]

OracleDatabase : NUMBER(1)

HsqlDatabase : BOOLEAN

FirebirdDatabase : SMALLINT

DerbyDatabase : SMALLINT

InformixDatabase : BOOLEAN

SybaseDatabase : BIT

SybaseASADatabase : BIT

MySQLDatabase : TINYINT

SQLiteDatabase : TINYINT

H2Database : TINYINT

PostgresDatabase : SMALLINT

UnsupportedDatabase : TINYINT

DB2Database : SMALLINT

MSSQLDatabase : [tinyint]

OracleDatabase : NUMBER(3)

HsqlDatabase : TINYINT

FirebirdDatabase : SMALLINT

DerbyDatabase : SMALLINT

InformixDatabase : TINYINT

SybaseDatabase : TINYINT

SybaseASADatabase : TINYINT

MySQLDatabase : INT

SQLiteDatabase : INTEGER

H2Database : INT

PostgresDatabase : INT

UnsupportedDatabase : INT

DB2Database : INTEGER

MSSQLDatabase : [int]

OracleDatabase : INTEGER

HsqlDatabase : INT

FirebirdDatabase : INT

DerbyDatabase : INTEGER

InformixDatabase : INT

SybaseDatabase : INT

SybaseASADatabase : INT

MySQLDatabase : MEDIUMINT

SQLiteDatabase : MEDIUMINT

H2Database : MEDIUMINT

PostgresDatabase : MEDIUMINT

UnsupportedDatabase : MEDIUMINT

DB2Database : MEDIUMINT

MSSQLDatabase : [int]

OracleDatabase : MEDIUMINT

HsqlDatabase : MEDIUMINT

FirebirdDatabase : MEDIUMINT

DerbyDatabase : MEDIUMINT

InformixDatabase : MEDIUMINT

SybaseDatabase : MEDIUMINT

SybaseASADatabase : MEDIUMINT

MySQLDatabase : BIGINT

SQLiteDatabase : BIGINT

H2Database : BIGINT

PostgresDatabase : BIGINT

UnsupportedDatabase : BIGINT

DB2Database : BIGINT

MSSQLDatabase : [bigint]

OracleDatabase : NUMBER(38, 0)

HsqlDatabase : BIGINT

FirebirdDatabase : BIGINT

DerbyDatabase : BIGINT

InformixDatabase : INT8

SybaseDatabase : BIGINT

SybaseASADatabase : BIGINT

MySQLDatabase : FLOAT

SQLiteDatabase : FLOAT

H2Database : FLOAT

PostgresDatabase : FLOAT

UnsupportedDatabase : FLOAT

DB2Database : FLOAT

MSSQLDatabase : float

OracleDatabase : FLOAT

HsqlDatabase : FLOAT

FirebirdDatabase : FLOAT

DerbyDatabase : FLOAT

InformixDatabase : FLOAT

SybaseDatabase : FLOAT

SybaseASADatabase : FLOAT

MySQLDatabase : DOUBLE

SQLiteDatabase : DOUBLE

H2Database : DOUBLE

PostgresDatabase : DOUBLE PRECISION

UnsupportedDatabase : DOUBLE

DB2Database : DOUBLE

MSSQLDatabase : float

OracleDatabase : FLOAT(24)

HsqlDatabase : DOUBLE

FirebirdDatabase : DOUBLE PRECISION

DerbyDatabase : DOUBLE

InformixDatabase : DOUBLE PRECISION

SybaseDatabase : DOUBLE

SybaseASADatabase : DOUBLE

MySQLDatabase : DECIMAL

SQLiteDatabase : DECIMAL

H2Database : DECIMAL

PostgresDatabase : DECIMAL

UnsupportedDatabase : DECIMAL

DB2Database : DECIMAL

MSSQLDatabase : [decimal](18, 0)

OracleDatabase : DECIMAL

HsqlDatabase : DECIMAL

FirebirdDatabase : DECIMAL

DerbyDatabase : DECIMAL

InformixDatabase : DECIMAL

SybaseDatabase : DECIMAL

SybaseASADatabase : DECIMAL

MySQLDatabase : numeric

SQLiteDatabase : NUMBER

H2Database : NUMBER

PostgresDatabase : numeric

UnsupportedDatabase : NUMBER

DB2Database : numeric

MSSQLDatabase : [numeric](18, 0)

OracleDatabase : NUMBER

HsqlDatabase : numeric

FirebirdDatabase : numeric

DerbyDatabase : numeric

InformixDatabase : numeric

SybaseDatabase : numeric

SybaseASADatabase : numeric

MySQLDatabase : LONGBLOB

SQLiteDatabase : BLOB

H2Database : BLOB

PostgresDatabase : BYTEA

UnsupportedDatabase : BLOB

DB2Database : BLOB

MSSQLDatabase : varbinary

OracleDatabase : BLOB

HsqlDatabase : BLOB

FirebirdDatabase : BLOB

DerbyDatabase : BLOB

InformixDatabase : BLOB

SybaseDatabase : IMAGE

SybaseASADatabase : LONG BINARY

MySQLDatabase : FUNCTION

SQLiteDatabase : FUNCTION

H2Database : FUNCTION

PostgresDatabase : FUNCTION

UnsupportedDatabase : FUNCTION

DB2Database : FUNCTION

MSSQLDatabase : [function]

OracleDatabase : FUNCTION

HsqlDatabase : FUNCTION

FirebirdDatabase : FUNCTION

DerbyDatabase : FUNCTION

InformixDatabase : FUNCTION

SybaseDatabase : FUNCTION

SybaseASADatabase : FUNCTION

MySQLDatabase : UNKNOWN

SQLiteDatabase : UNKNOWN

H2Database : UNKNOWN

PostgresDatabase : UNKNOWN

UnsupportedDatabase : UNKNOWN

DB2Database : UNKNOWN

MSSQLDatabase : [UNKNOWN]

OracleDatabase : UNKNOWN

HsqlDatabase : UNKNOWN

FirebirdDatabase : UNKNOWN

DerbyDatabase : UNKNOWN

InformixDatabase : UNKNOWN

SybaseDatabase : UNKNOWN

SybaseASADatabase : UNKNOWN

MySQLDatabase : datetime

SQLiteDatabase : TEXT

H2Database : TIMESTAMP

PostgresDatabase : TIMESTAMP WITHOUT TIME ZONE

UnsupportedDatabase : datetime

DB2Database : TIMESTAMP

MSSQLDatabase : [datetime]

OracleDatabase : TIMESTAMP

HsqlDatabase : TIMESTAMP

FirebirdDatabase : TIMESTAMP

DerbyDatabase : TIMESTAMP

InformixDatabase : DATETIME YEAR TO FRACTION(5)

SybaseDatabase : datetime

SybaseASADatabase : datetime

MySQLDatabase : time

SQLiteDatabase : time

H2Database : time

PostgresDatabase : TIME WITHOUT TIME ZONE

UnsupportedDatabase : time

DB2Database : time

MSSQLDatabase : time

OracleDatabase : DATE

HsqlDatabase : time

FirebirdDatabase : time

DerbyDatabase : time

InformixDatabase : INTERVAL HOUR TO FRACTION(5)

SybaseDatabase : time

SybaseASADatabase : time

MySQLDatabase : timestamp

SQLiteDatabase : TEXT

H2Database : TIMESTAMP

PostgresDatabase : TIMESTAMP WITHOUT TIME ZONE

UnsupportedDatabase : timestamp

DB2Database : timestamp

MSSQLDatabase : [datetime]

OracleDatabase : TIMESTAMP

HsqlDatabase : TIMESTAMP

FirebirdDatabase : TIMESTAMP

DerbyDatabase : TIMESTAMP

InformixDatabase : DATETIME YEAR TO FRACTION(5)

SybaseDatabase : datetime

SybaseASADatabase : timestamp

MySQLDatabase : date

SQLiteDatabase : date

H2Database : date

PostgresDatabase : date

UnsupportedDatabase : date

DB2Database : date

MSSQLDatabase : [date]

OracleDatabase : date

HsqlDatabase : date

FirebirdDatabase : date

DerbyDatabase : date

InformixDatabase : date

SybaseDatabase : date

SybaseASADatabase : date

MySQLDatabase : CHAR

SQLiteDatabase : CHAR

H2Database : CHAR

PostgresDatabase : CHAR

UnsupportedDatabase : CHAR

DB2Database : CHAR

MSSQLDatabase : char

OracleDatabase : CHAR

HsqlDatabase : CHAR

FirebirdDatabase : CHAR

DerbyDatabase : CHAR

InformixDatabase : CHAR

SybaseDatabase : CHAR

SybaseASADatabase : CHAR

MySQLDatabase : VARCHAR

SQLiteDatabase : VARCHAR

H2Database : VARCHAR

PostgresDatabase : VARCHAR

UnsupportedDatabase : VARCHAR

DB2Database : VARCHAR

MSSQLDatabase : varchar

OracleDatabase : VARCHAR2

HsqlDatabase : VARCHAR

FirebirdDatabase : VARCHAR

DerbyDatabase : VARCHAR

InformixDatabase : VARCHAR

SybaseDatabase : VARCHAR

SybaseASADatabase : VARCHAR

MySQLDatabase : NCHAR

SQLiteDatabase : NCHAR

H2Database : NCHAR

PostgresDatabase : NCHAR

UnsupportedDatabase : NCHAR

DB2Database : NCHAR

MSSQLDatabase : nchar

OracleDatabase : NCHAR

HsqlDatabase : CHAR

FirebirdDatabase : NCHAR

DerbyDatabase : NCHAR

InformixDatabase : NCHAR

SybaseDatabase : NCHAR

SybaseASADatabase : NCHAR

MySQLDatabase : NVARCHAR

SQLiteDatabase : NVARCHAR

H2Database : NVARCHAR

PostgresDatabase : VARCHAR

UnsupportedDatabase : NVARCHAR

DB2Database : NVARCHAR

MSSQLDatabase : nvarchar

OracleDatabase : NVARCHAR2

HsqlDatabase : VARCHAR

FirebirdDatabase : NVARCHAR

DerbyDatabase : VARCHAR

InformixDatabase : NVARCHAR

SybaseDatabase : NVARCHAR

SybaseASADatabase : NVARCHAR

MySQLDatabase : LONGTEXT

SQLiteDatabase : TEXT

H2Database : CLOB

PostgresDatabase : TEXT

UnsupportedDatabase : CLOB

DB2Database : CLOB

MSSQLDatabase : varchar

OracleDatabase : CLOB

HsqlDatabase : CLOB

FirebirdDatabase : BLOB SUB_TYPE TEXT

DerbyDatabase : CLOB

InformixDatabase : CLOB

SybaseDatabase : TEXT

SybaseASADatabase : LONG VARCHAR

MySQLDatabase : DECIMAL

SQLiteDatabase : REAL

H2Database : DECIMAL

PostgresDatabase : DECIMAL

UnsupportedDatabase : DECIMAL

DB2Database : DECIMAL(19, 4)

MSSQLDatabase : [money]

OracleDatabase : NUMBER(15, 2)

HsqlDatabase : DECIMAL

FirebirdDatabase : DECIMAL(18, 4)

DerbyDatabase : DECIMAL

InformixDatabase : MONEY

SybaseDatabase : MONEY

SybaseASADatabase : MONEY

MySQLDatabase : char(36)

SQLiteDatabase : TEXT

H2Database : UUID

PostgresDatabase : UUID

UnsupportedDatabase : char(36)

DB2Database : char(36)

MSSQLDatabase : [uniqueidentifier]

OracleDatabase : RAW(16)

HsqlDatabase : char(36)

FirebirdDatabase : char(36)

DerbyDatabase : char(36)

InformixDatabase : char(36)

SybaseDatabase : UNIQUEIDENTIFIER

SybaseASADatabase : UNIQUEIDENTIFIER`