NuoDB Migrator Mappings for Unsupported Types

Source

Maps to...

Database Data type Range NuoDB Data type Range
MySQL Enum 65,535 CHAR(n) 65,535
TinyInt (signed) -128 to 127 SMALLINT -32768 to 32767
TinyInt (unsigned) 0 to 255    
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