Data Type | Preferred Native Type | Other Allowed Native Types |
BIGINT | BIGINT | DECIMAL(19+,0), larger INTEGER types, VARCHAR(20+) |
BINARY(n) | BINARY(n) BLOB | BINARY(n+), BLOB |
BIT | BIT | DECIMAL(1+,0), larger INTEGER types |
BLOB | BLOB | |
CHAR(n) | CHAR(n) CLOB | CHAR(n+), CLOB |
CLOB | CLOB | |
DATE | DATE | VARCHAR(10+) |
DECIMAL(p,s) | DECIMAL(p,s) | DECIMAL(p+,s+), VARCHAR(p+3+), CLOB, INTEGER types with enough resolution |
DOUBLE | DOUBLE | VARCHAR(24+) |
FLOAT | FLOAT | DOUBLE |
INTEGER | INTEGER | DECIMAL(10+,0), larger INTEGER types, VARCHAR(20+) |
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(p,s) | NUMERIC(p,s) | DECIMAL(p+,s+), VARCHAR(p+3+), CLOB, INTEGER types with enough resolution |
OTHER | [cannot be cached] | |
REAL | REAL | |
SMALLINT | SMALLINT | DECIMAL(5+0), larger INTEGER types, VARCHAR(20+) |
TIME | TIME | VARCHAR(15+) |
TIMESTAMP | TIMESTAMP | |
TINYINT | TINYINT | DECIMAL(3+,0), larger INTEGER types, VARCHAR(20+) |
VARBINARY(n) | VARBINARY(n) BLOB | VARBINARY(n+), BLOB |
VARCHAR(n) What is PROMOTE threshold for this data type in file caches? | VARCHAR(n) CLOB | VARCHAR(n+), CLOB |
XML | CLOB | VARCHAR(*) Truncates data if column is too small. |