Data Type | Native Type |
BIGINT | DECIMAL(20,0) |
BINARY | LONGBINARY |
BIT | BIT |
BLOB | LONGBINARY |
CHAR | VARCHAR(n) |
CLOB | LONGCHAR |
DATE | DATETIME |
DECIMAL | DECIMAL(p,s) |
DOUBLE | DOUBLE |
FLOAT | FLOAT |
INTEGER | INTEGER |
INTERVAL DAY | VARCHAR(30) |
INTERVAL DAY TO HOUR | VARCHAR(30) |
INTERVAL DAY TO MINUTE | VARCHAR(30) |
INTERVAL DAY TO SECOND | VARCHAR(30) |
INTERVAL HOUR | VARCHAR(30) |
INTERVAL HOUR TO MINUTE | VARCHAR(30) |
INTERVAL HOUR TO SECOND | VARCHAR(30) |
INTERVAL MINUTE | VARCHAR(30) |
INTERVAL MINUTE TO SECOND | VARCHAR(30) |
INTERVAL MONTH | VARCHAR(9) |
INTERVAL SECOND | VARCHAR(30) |
INTERVAL YEAR | VARCHAR(9) |
INTERVAL YEAR TO MONTH | VARCHAR(12) |
NUMERIC | DECIMAL(p,s) |
REAL | FLOAT |
SMALLINT | SMALLINT |
TIMESTAMP | DATETIME |
TINYINT | BYTE |
VARBINARY | LONGBINARY |
VARCHAR | VARCHAR(n) |