NuoDB Migrator Mappings for Unsupported Types

Database

Data type

Range

NuoDB Data type

Range

MySQL

Enum

65,535

CHAR(n)

65,535

DB2

LongVarBinary

VARCHAR (n)

Long Varchar for Bit data

VARCHAR (n)

DecFloat

DECIMAL[(p,s)]

XML

CLOB

Current Date

NOW

Current Time

NOW

Current Timestamp

NOW

Oracle

Current_Date

NOW

SysDate

NOW

RowID

STRING

Long

CLOB

XMLDATA

STRING

ANYDATA

STRING

MS SQL Server

GetDate()

NOW

Current_Timestamp

NOW

Now()

NOW

PostgreSQL

Current_Timestamp

NOW

Now()

NOW