NuoDB Migrator Mappings for Supported Types

Bit, newSize(0)

BOOLEAN

Bit, newSize(1)

BOOLEAN

Enum

CHAR( n )

Integer

INTEGER

BigInt

BIGINT

Numeric

NUMERIC( p, s )

Decimal

DECIMAL( p, s )

Real

REAL

Float

FLOAT

Double

DOUBLE

Char

CHAR( n )

Varchar

VARCHAR( n )

LongVarchar

VARCHAR( n )

Date

DATE

Time, newScale(0)

TIME

Time

TIME( s )

TimeStamp, newScale(0)

TIMESTAMP

TimeStamp

TIMESTAMP( s )

Binary

BINARY( n )

VarBinary

VARBINARY( n )

LongVarBinary

VARBINARY( n )

Null

NULL

NCLOB

NCLOB

VarChar

STRING

SmallInt

INTEGER

SmallInt Unsigned

INTEGER

Int Unsigned

BIGINT

BigInt Unsigned

NUMERIC( n , 1 )