Data Type | Native Type |
BINARY(n) | BINARY(n) |
BIGINT | INT8 |
BIT | BOOLEAN |
BLOB | VARBINARY(n) |
BOOL | BOOLEAN |
BOOLEAN | BOOLEAN |
CHAR | CHAR(n) |
CLOB | VARBINARY(n) |
DATE | DATE |
DECIMAL | DECIMAL(p,s) |
DOUBLE | DOUBLE PRECISION |
FLOAT | FLOAT |
INTEGER | INTEGER |
INTERVAL | VARCHAR |
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) |
LONG | BIGINT |
NCLOB | VARBINARY(n) |
NUMERIC | NUMERIC(p,s) |
REAL | REAL |
SMALLINT | SMALLINT |
TIME | TIME, TIMEZ |
TIMESTAMP | TIMESTAMP |
TINYINT | TINYINT |
VARBINARY(n) | VARBINARY(n) |
VARCHAR | VARCHAR(n) |