Data Type | Preferred Native Type | Other Allowed Native Types |
BIGINT | BIGINT | DECIMAL(19+,0), larger INTEGER types, VARCHAR(20+) |
BINARY(n) | BLOB | |
BIT | SMALLINT | DECIMAL(1+,0), larger INTEGER types |
BLOB | BLOB | |
BOOLEAN | SMALLINT | INTEGER, BIGINT |
CHAR(n) | CHAR(n); CLOB [if n > 254] | CHAR(n+), GRAPHIC(n+), VARCHAR(n+), VARGRAPHIC(n+), CLOB |
CLOB | CLOB | LONG VARGRAPHIC |
DATE | DATE | VARCHAR(10+) |
DECIMAL(p,s) | DECIMAL(p,s); CLOB [if p > 31] | DECIMAL(p+,s+), VARCHAR(p+3+), VARGRAPHIC(p+3+), CLOB, LONG VARGRAPHIC |
DOUBLE | DOUBLE | VARCHAR(24+) |
FLOAT | DOUBLE | VARCHAR(24+) |
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) | DECIMAL(p,s); CLOB [if p > 31] | DECIMAL(p+,s+), VARCHAR(p+3+), GRAPHIC(p+3+), CLOB |
OTHER | [cannot be cached] | |
REAL | REAL | |
SMALLINT | SMALLINT | DECIMAL(5+,0), larger INTEGER types, VARCHAR(20+) |
TIME | TIME | VARCHAR(15+) |
TIMESTAMP | TIMESTAMP | VARCHAR(26+) |
TINYINT | SMALLINT | DECIMAL(3+,0), larger INTEGER types, VARCHAR(20+) |
VARBINARY(n) | BLOB | |
VARCHAR(n) | VARCHAR(n); CLOB [if n > 254] | VARCHAR(n+), VARGRAPHIC(n+), CLOB, LONG VARGRAPHIC |
XML | CLOB | VARCHAR(*) [truncates data if column is too small], VARGRAPHIC(*), LONG VARGRAPHIC |