Liquibase - list of available generic datatypes

Question

I need a list of the generic data types available in Liquibase. Where can I find these in the documentation.

I need them when adding columns to my table:

<changeSet author="liquibase-docs" id="addColumn-example">
    <addColumn catalogName="cat"
            schemaName="public"
            tableName="person">
        <column name="address" type="varchar(255)"/>
    </addColumn>
</changeSet>

Answer 1

Liquibase uses the standard JDBC datatypes - here is one reference, from http://db.apache.org/ojb/docu/guides/jdbc-types.html

DBC Type      Java Type
CHAR          String
VARCHAR       String
LONGVARCHAR   String
NUMERIC       java.math.BigDecimal
DECIMAL       java.math.BigDecimal
BIT           boolean
BOOLEAN       boolean
TINYINT       byte
SMALLINT      short
INTEGER       int
BIGINT        long
REAL          float
FLOAT         double
DOUBLE        double
BINARY        byte[]
VARBINARY     byte[]
LONGVARBINARY byte[]
DATE          java.sql.Date
TIME          java.sql.Time
TIMESTAMP     java.sql.Timestamp
CLOB          Clob
BLOB          Blob
ARRAY         Array
DISTINCT      mapping of underlying type
STRUCT        Struct
REF           Ref
DATALINK      java.net.URL
JAVA_OBJECT   underlying Java class