Data Type | Native Type |
BIGINT | INT8 |
BINARY | BYTE(n) BLOB |
BIT | BOOLEAN |
BLOB | BLOB |
CHAR | CHAR(n) TEXT |
CLOB | TEXT |
DATE | DATE |
DECIMAL | DECIMAL(p,s) |
DOUBLE | DOUBLE PRECISION |
FLOAT | REAL |
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 | NUMERIC(p,s) |
REAL | REAL |
SMALLINT | SMALLINT |
TIMESTAMP | DATETIME |
TINYINT | SMALLINT |
VARBINARY(n) | BYTE(n) BLOB |
VARCHAR(n) | VARCHAR(n) TEXT |