---

Table of contents

1. Available DataTypes
   1. CODE USED TO GET TYPES
   2. BOOLEAN
      1. MySQLDatabase : BIT(1)
      2. SQLiteDatabase : BOOLEAN
      3. H2Database : BOOLEAN
      4. PostgresDatabase : BOOLEAN
      5. UnsupportedDatabase : BOOLEAN
      6. DB2Database : SMALLINT
      7. MSSQLDatabase : bit
      8. OracleDatabase : NUMBER(1)
      9. HsqlDatabase : BOOLEAN
      10. FirebirdDatabase : SMALLINT
      11. DerbyDatabase : SMALLINT
      12. InformixDatabase : BOOLEAN
      13. SybaseDatabase : BIT
      14. SybaseASADatabase : BIT
   3. TINYINT
      1. MySQLDatabase : TINYINT
      2. SQLiteDatabase : TINYINT
      3. H2Database : TINYINT
      4. PostgresDatabase : SMALLINT
      5. UnsupportedDatabase : TINYINT
      6. DB2Database : SMALLINT
      7. MSSQLDatabase : tinyint
      8. OracleDatabase : NUMBER(3)
      9. HsqlDatabase : TINYINT
      10. FirebirdDatabase : SMALLINT
      11. DerbyDatabase : SMALLINT
      12. InformixDatabase : TINYINT
      13. SybaseDatabase : TINYINT
      14. SybaseASADatabase : TINYINT
   4. INT
      1. MySQLDatabase : INT
      2. SQLiteDatabase : INTEGER
      3. H2Database : INT
      4. PostgresDatabase : INT
      5. UnsupportedDatabase : INT
      6. DB2Database : INTEGER
      7. MSSQLDatabase : int
      8. OracleDatabase : INTEGER
      9. HsqlDatabase : INT
      10. FirebirdDatabase : INT
      11. DerbyDatabase : INTEGER
      12. InformixDatabase : INT
      13. SybaseDatabase : INT
      14. SybaseASADatabase : INT
   5. MEDIUMINT
      1. MySQLDatabase : MEDIUMINT
      2. SQLiteDatabase : MEDIUMINT
      3. H2Database : MEDIUMINT
      4. PostgresDatabase : MEDIUMINT
      5. UnsupportedDatabase : MEDIUMINT
      6. DB2Database : MEDIUMINT
      7. MSSQLDatabase : int
      8. OracleDatabase : MEDIUMINT
      9. HsqlDatabase : MEDIUMINT
      10. FirebirdDatabase : MEDIUMINT
      11. DerbyDatabase : MEDIUMINT
      12. InformixDatabase : MEDIUMINT
      13. SybaseDatabase : MEDIUMINT
      14. SybaseASADatabase : MEDIUMINT
   6. BIGINT
      1. MySQLDatabase : BIGINT
      2. SQLiteDatabase : BIGINT
      3. H2Database : BIGINT
      4. PostgresDatabase : BIGINT
      5. UnsupportedDatabase : BIGINT
      6. DB2Database : BIGINT
      7. MSSQLDatabase : bigint
      8. OracleDatabase : NUMBER(38, 0)
      9. HsqlDatabase : BIGINT
      10. FirebirdDatabase : BIGINT
      11. DerbyDatabase : BIGINT
      12. InformixDatabase : INT8
      13. SybaseDatabase : BIGINT
      14. SybaseASADatabase : BIGINT
   7. FLOAT
      1. MySQLDatabase : FLOAT
      2. SQLiteDatabase : FLOAT
      3. H2Database : FLOAT
      4. PostgresDatabase : FLOAT
      5. UnsupportedDatabase : FLOAT
      6. DB2Database : FLOAT
      7. MSSQLDatabase : FLOAT(53)
      8. OracleDatabase : FLOAT
      9. HsqlDatabase : FLOAT
      10. FirebirdDatabase : FLOAT
      11. DerbyDatabase : FLOAT
      12. InformixDatabase : FLOAT
      13. SybaseDatabase : FLOAT
      14. SybaseASADatabase : FLOAT
   8. DOUBLE
      1. MySQLDatabase : DOUBLE
      2. SQLiteDatabase : DOUBLE
      3. H2Database : DOUBLE
      4. PostgresDatabase : DOUBLE PRECISION
      5. UnsupportedDatabase : DOUBLE
      6. DB2Database : DOUBLE
      7. MSSQLDatabase : FLOAT(53)
      8. OracleDatabase : FLOAT(24)
      9. HsqlDatabase : DOUBLE
      10. FirebirdDatabase : DOUBLE PRECISION
      11. DerbyDatabase : DOUBLE
      12. InformixDatabase : DOUBLE PRECISION
      13. SybaseDatabase : DOUBLE
      14. SybaseASADatabase : DOUBLE
   9. DECIMAL
      1. MySQLDatabase : DECIMAL
      2. SQLiteDatabase : DECIMAL
      3. H2Database : DECIMAL
      4. PostgresDatabase : DECIMAL
      5. UnsupportedDatabase : DECIMAL
      6. DB2Database : DECIMAL
      7. MSSQLDatabase : DECIMAL(18, 0)
      8. OracleDatabase : DECIMAL
      9. HsqlDatabase : DECIMAL
      10. FirebirdDatabase : DECIMAL
      11. DerbyDatabase : DECIMAL
      12. InformixDatabase : DECIMAL
      13. SybaseDatabase : DECIMAL
      14. SybaseASADatabase : DECIMAL
   10. NUMBER
       1. MySQLDatabase : numeric
       2. SQLiteDatabase : NUMBER
       3. H2Database : NUMBER
       4. PostgresDatabase : numeric
       5. UnsupportedDatabase : NUMBER
       6. DB2Database : numeric
       7. MSSQLDatabase : numeric(18, 0)
       8. OracleDatabase : NUMBER
       9. HsqlDatabase : numeric
       10. FirebirdDatabase : numeric
       11. DerbyDatabase : numeric
       12. InformixDatabase : numeric
       13. SybaseDatabase : numeric
       14. SybaseASADatabase : numeric
   11. BLOB
       1. MySQLDatabase : LONGBLOB
       2. SQLiteDatabase : BLOB
       3. H2Database : BLOB
       4. PostgresDatabase : BYTEA
       5. UnsupportedDatabase : BLOB
       6. DB2Database : BLOB
       7. MSSQLDatabase : varbinary(MAX)
       8. OracleDatabase : BLOB
       9. HsqlDatabase : BLOB
       10. FirebirdDatabase : BLOB
       11. DerbyDatabase : BLOB
       12. InformixDatabase : BLOB
       13. SybaseDatabase : IMAGE
       14. SybaseASADatabase : LONG BINARY
   12. FUNCTION
       1. MySQLDatabase : FUNCTION
       2. SQLiteDatabase : FUNCTION
       3. H2Database : FUNCTION
       4. PostgresDatabase : FUNCTION
       5. UnsupportedDatabase : FUNCTION
       6. DB2Database : FUNCTION
       7. MSSQLDatabase : function
       8. OracleDatabase : FUNCTION
       9. HsqlDatabase : FUNCTION
       10. FirebirdDatabase : FUNCTION
       11. DerbyDatabase : FUNCTION
       12. InformixDatabase : FUNCTION
       13. SybaseDatabase : FUNCTION
       14. SybaseASADatabase : FUNCTION
   13. UNKNOWN
       1. MySQLDatabase : UNKNOWN
       2. SQLiteDatabase : UNKNOWN
       3. H2Database : UNKNOWN
       4. PostgresDatabase : UNKNOWN
       5. UnsupportedDatabase : UNKNOWN
       6. DB2Database : UNKNOWN
       7. MSSQLDatabase : UNKNOWN
       8. OracleDatabase : UNKNOWN
       9. HsqlDatabase : UNKNOWN
       10. FirebirdDatabase : UNKNOWN
       11. DerbyDatabase : UNKNOWN
       12. InformixDatabase : UNKNOWN
       13. SybaseDatabase : UNKNOWN
       14. SybaseASADatabase : UNKNOWN
   14. DATETIME
       1. MySQLDatabase : datetime
       2. SQLiteDatabase : TEXT
       3. H2Database : TIMESTAMP
       4. PostgresDatabase : TIMESTAMP WITHOUT TIME ZONE
       5. UnsupportedDatabase : datetime
       6. DB2Database : TIMESTAMP
       7. MSSQLDatabase : datetime
       8. OracleDatabase : TIMESTAMP
       9. HsqlDatabase : TIMESTAMP
       10. FirebirdDatabase : TIMESTAMP
       11. DerbyDatabase : TIMESTAMP
       12. InformixDatabase : DATETIME YEAR TO FRACTION(5)
       13. SybaseDatabase : datetime
       14. SybaseASADatabase : datetime
   15. TIME
       1. MySQLDatabase : time
       2. SQLiteDatabase : time
       3. H2Database : time
       4. PostgresDatabase : TIME WITHOUT TIME ZONE
       5. UnsupportedDatabase : time
       6. DB2Database : time
       7. MSSQLDatabase : time(7)
       8. OracleDatabase : DATE
       9. HsqlDatabase : time
       10. FirebirdDatabase : time
       11. DerbyDatabase : time
       12. InformixDatabase : INTERVAL HOUR TO FRACTION(5)
       13. SybaseDatabase : time
       14. SybaseASADatabase : time
   16. TIMESTAMP
       1. MySQLDatabase : timestamp
       2. SQLiteDatabase : TEXT
       3. H2Database : TIMESTAMP
       4. PostgresDatabase : TIMESTAMP WITHOUT TIME ZONE
       5. UnsupportedDatabase : timestamp
       6. DB2Database : timestamp
       7. MSSQLDatabase : datetime
       8. OracleDatabase : TIMESTAMP
       9. HsqlDatabase : TIMESTAMP
       10. FirebirdDatabase : TIMESTAMP
       11. DerbyDatabase : TIMESTAMP
       12. InformixDatabase : DATETIME YEAR TO FRACTION(5)
       13. SybaseDatabase : datetime
       14. SybaseASADatabase : timestamp
   17. DATE
       1. MySQLDatabase : date
       2. SQLiteDatabase : date
       3. H2Database : date
       4. PostgresDatabase : date
       5. UnsupportedDatabase : date
       6. DB2Database : date
       7. MSSQLDatabase : date
       8. OracleDatabase : date
       9. HsqlDatabase : date
       10. FirebirdDatabase : date
       11. DerbyDatabase : date
       12. InformixDatabase : date
       13. SybaseDatabase : date
       14. SybaseASADatabase : date
   18. CHAR
       1. MySQLDatabase : CHAR
       2. SQLiteDatabase : CHAR
       3. H2Database : CHAR
       4. PostgresDatabase : CHAR
       5. UnsupportedDatabase : CHAR
       6. DB2Database : CHAR
       7. MSSQLDatabase : char(1)
       8. OracleDatabase : CHAR
       9. HsqlDatabase : CHAR
       10. FirebirdDatabase : CHAR
       11. DerbyDatabase : CHAR
       12. InformixDatabase : CHAR
       13. SybaseDatabase : CHAR
       14. SybaseASADatabase : CHAR
   19. VARCHAR
       1. MySQLDatabase : VARCHAR
       2. SQLiteDatabase : VARCHAR
       3. H2Database : VARCHAR
       4. PostgresDatabase : VARCHAR
       5. UnsupportedDatabase : VARCHAR
       6. DB2Database : VARCHAR
       7. MSSQLDatabase : varchar(1)
       8. OracleDatabase : VARCHAR2
       9. HsqlDatabase : VARCHAR
       10. FirebirdDatabase : VARCHAR
       11. DerbyDatabase : VARCHAR
       12. InformixDatabase : VARCHAR
       13. SybaseDatabase : VARCHAR
       14. SybaseASADatabase : VARCHAR
   20. NCHAR
       1. MySQLDatabase : NCHAR
       2. SQLiteDatabase : NCHAR
       3. H2Database : NCHAR
       4. PostgresDatabase : NCHAR
       5. UnsupportedDatabase : NCHAR
       6. DB2Database : NCHAR
       7. MSSQLDatabase : nchar(1)
       8. OracleDatabase : NCHAR
       9. HsqlDatabase : CHAR
       10. FirebirdDatabase : NCHAR
       11. DerbyDatabase : NCHAR
       12. InformixDatabase : NCHAR
       13. SybaseDatabase : NCHAR
       14. SybaseASADatabase : NCHAR
   21. NVARCHAR
       1. MySQLDatabase : NVARCHAR
       2. SQLiteDatabase : NVARCHAR
       3. H2Database : NVARCHAR
       4. PostgresDatabase : VARCHAR
       5. UnsupportedDatabase : NVARCHAR
       6. DB2Database : NVARCHAR
       7. MSSQLDatabase : nvarchar(1)
       8. OracleDatabase : NVARCHAR2
       9. HsqlDatabase : VARCHAR
       10. FirebirdDatabase : NVARCHAR
       11. DerbyDatabase : VARCHAR
       12. InformixDatabase : NVARCHAR
       13. SybaseDatabase : NVARCHAR
       14. SybaseASADatabase : NVARCHAR
   22. CLOB
       1. MySQLDatabase : LONGTEXT
       2. SQLiteDatabase : TEXT
       3. H2Database : CLOB
       4. PostgresDatabase : TEXT
       5. UnsupportedDatabase : CLOB
       6. DB2Database : CLOB
       7. MSSQLDatabase : varchar(MAX)
       8. OracleDatabase : CLOB
       9. HsqlDatabase : CLOB
       10. FirebirdDatabase : BLOB SUB_TYPE TEXT
       11. DerbyDatabase : CLOB
       12. InformixDatabase : CLOB
       13. SybaseDatabase : TEXT
       14. SybaseASADatabase : LONG VARCHAR
   23. CURRENCY
       1. MySQLDatabase : DECIMAL
       2. SQLiteDatabase : REAL
       3. H2Database : DECIMAL
       4. PostgresDatabase : DECIMAL
       5. UnsupportedDatabase : DECIMAL
       6. DB2Database : DECIMAL(19, 4)
       7. MSSQLDatabase : money
       8. OracleDatabase : NUMBER(15, 2)
       9. HsqlDatabase : DECIMAL
       10. FirebirdDatabase : DECIMAL(18, 4)
       11. DerbyDatabase : DECIMAL
       12. InformixDatabase : MONEY
       13. SybaseDatabase : MONEY
       14. SybaseASADatabase : MONEY
   24. UUID
       1. MySQLDatabase : char(36)
       2. SQLiteDatabase : TEXT
       3. H2Database : UUID
       4. PostgresDatabase : UUID
       5. UnsupportedDatabase : char(36)
       6. DB2Database : char(36)
       7. MSSQLDatabase : uniqueidentifier
       8. OracleDatabase : RAW(16)
       9. HsqlDatabase : char(36)
       10. FirebirdDatabase : char(36)
       11. DerbyDatabase : char(36)
       12. InformixDatabase : char(36)
       13. SybaseDatabase : UNIQUEIDENTIFIER
       14. SybaseASADatabase : UNIQUEIDENTIFIER

---

---

Available DataTypes

CODE USED TO GET TYPES

@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 ''
}

BOOLEAN

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

TINYINT

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

INT

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

MEDIUMINT

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

BIGINT

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

FLOAT

MySQLDatabase : FLOAT

SQLiteDatabase : FLOAT

H2Database : FLOAT

PostgresDatabase : FLOAT

UnsupportedDatabase : FLOAT

DB2Database : FLOAT

MSSQLDatabase : FLOAT(53)

OracleDatabase : FLOAT

HsqlDatabase : FLOAT

FirebirdDatabase : FLOAT

DerbyDatabase : FLOAT

InformixDatabase : FLOAT

SybaseDatabase : FLOAT

SybaseASADatabase : FLOAT

DOUBLE

MySQLDatabase : DOUBLE

SQLiteDatabase : DOUBLE

H2Database : DOUBLE

PostgresDatabase : DOUBLE PRECISION

UnsupportedDatabase : DOUBLE

DB2Database : DOUBLE

MSSQLDatabase : FLOAT(53)

OracleDatabase : FLOAT(24)

HsqlDatabase : DOUBLE

FirebirdDatabase : DOUBLE PRECISION

DerbyDatabase : DOUBLE

InformixDatabase : DOUBLE PRECISION

SybaseDatabase : DOUBLE

SybaseASADatabase : DOUBLE

DECIMAL

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

NUMBER

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

BLOB

MySQLDatabase : LONGBLOB

SQLiteDatabase : BLOB

H2Database : BLOB

PostgresDatabase : BYTEA

UnsupportedDatabase : BLOB

DB2Database : BLOB

MSSQLDatabase : varbinary(MAX)

OracleDatabase : BLOB

HsqlDatabase : BLOB

FirebirdDatabase : BLOB

DerbyDatabase : BLOB

InformixDatabase : BLOB

SybaseDatabase : IMAGE

SybaseASADatabase : LONG BINARY

FUNCTION

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

UNKNOWN

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

DATETIME

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

TIME

MySQLDatabase : time

SQLiteDatabase : time

H2Database : time

PostgresDatabase : TIME WITHOUT TIME ZONE

UnsupportedDatabase : time

DB2Database : time

MSSQLDatabase : time(7)

OracleDatabase : DATE

HsqlDatabase : time

FirebirdDatabase : time

DerbyDatabase : time

InformixDatabase : INTERVAL HOUR TO FRACTION(5)

SybaseDatabase : time

SybaseASADatabase : time

TIMESTAMP

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

DATE

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

CHAR

MySQLDatabase : CHAR

SQLiteDatabase : CHAR

H2Database : CHAR

PostgresDatabase : CHAR

UnsupportedDatabase : CHAR

DB2Database : CHAR

MSSQLDatabase : char(1)

OracleDatabase : CHAR

HsqlDatabase : CHAR

FirebirdDatabase : CHAR

DerbyDatabase : CHAR

InformixDatabase : CHAR

SybaseDatabase : CHAR

SybaseASADatabase : CHAR

VARCHAR

MySQLDatabase : VARCHAR

SQLiteDatabase : VARCHAR

H2Database : VARCHAR

PostgresDatabase : VARCHAR

UnsupportedDatabase : VARCHAR

DB2Database : VARCHAR

MSSQLDatabase : varchar(1)

OracleDatabase : VARCHAR2

HsqlDatabase : VARCHAR

FirebirdDatabase : VARCHAR

DerbyDatabase : VARCHAR

InformixDatabase : VARCHAR

SybaseDatabase : VARCHAR

SybaseASADatabase : VARCHAR

NCHAR

MySQLDatabase : NCHAR

SQLiteDatabase : NCHAR

H2Database : NCHAR

PostgresDatabase : NCHAR

UnsupportedDatabase : NCHAR

DB2Database : NCHAR

MSSQLDatabase : nchar(1)

OracleDatabase : NCHAR

HsqlDatabase : CHAR

FirebirdDatabase : NCHAR

DerbyDatabase : NCHAR

InformixDatabase : NCHAR

SybaseDatabase : NCHAR

SybaseASADatabase : NCHAR

NVARCHAR

MySQLDatabase : NVARCHAR

SQLiteDatabase : NVARCHAR

H2Database : NVARCHAR

PostgresDatabase : VARCHAR

UnsupportedDatabase : NVARCHAR

DB2Database : NVARCHAR

MSSQLDatabase : nvarchar(1)

OracleDatabase : NVARCHAR2

HsqlDatabase : VARCHAR

FirebirdDatabase : NVARCHAR

DerbyDatabase : VARCHAR

InformixDatabase : NVARCHAR

SybaseDatabase : NVARCHAR

SybaseASADatabase : NVARCHAR

CLOB

MySQLDatabase : LONGTEXT

SQLiteDatabase : TEXT

H2Database : CLOB

PostgresDatabase : TEXT

UnsupportedDatabase : CLOB

DB2Database : CLOB

MSSQLDatabase : varchar(MAX)

OracleDatabase : CLOB

HsqlDatabase : CLOB

FirebirdDatabase : BLOB SUB_TYPE TEXT

DerbyDatabase : CLOB

InformixDatabase : CLOB

SybaseDatabase : TEXT

SybaseASADatabase : LONG VARCHAR

CURRENCY

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

UUID

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