Data Type | Preferred Data Type | Other Allowed Native Types |
BIGINT | BIGINT [12, 13] CHAR(20) | DECIMAL(19+,0), VARCHAR(20+) |
BINARY(n) | BYTE(n), BLOB [if n > 32,000] | BYTE(n+) |
BIT | BYTEINT | DECIMAL(1+,0), larger INTEGER types |
BLOB | BLOB | |
BOOLEAN | BYTEINT | SMALLINT, INTEGER |
CHAR(n) | CHAR(n); CLOB [if n > 32,000] | CHAR(n+), GRAPHIC(n+), VARCHAR(n+), CLOB |
CLOB | CLOB | Teradata 15 JDBC driver does not support CLOB column with NULL values when caching to Teradata 15. |
DATE | DATE | VARCHAR(10+) |
DECIMAL(p,s) | DECIMAL(p,s); CLOB [if p > 18] | DECIMAL(p+,s+), VARCHAR(p+3+), GRAPHIC(p+3+), CLOB |
DOUBLE | FLOAT | VARCHAR(24+) |
FLOAT | FLOAT | VARCHAR(24+) |
INTEGER | INTEGER | DECIMAL(10+,0), VARCHAR(20+), GRAPHIC(20+), , VARGRAPHIC(20+) |
NUMERIC(p,s) | DECIMAL(p,s); CLOB [if p > 18] | DECIMAL(p+,s+), VARCHAR(p+3+), GRAPHIC(p+3+), CLOB |
OTHER | [cannot be cached] | |
SMALLINT | SMALLINT | DECIMAL(5+,0), larger INTEGER types, VARCHAR(20+), VARGRAPHIC(20+) |
TIME | VARCHAR(15) | VARCHAR(15+) |
TIMESTAMP | TIMESTAMP | VARCHAR(26+) |
TINYINT | BYTEINT | DECIMAL(3+,0), larger INTEGER types, VARCHAR(20+), VARGRAPHIC(20+) |
VARBINARY(n) | VARBYTE(n); BLOB [if n > 32,000] | VARBYTE(n+) |
VARCHAR(n) | VARCHAR(n); CLOB [if n > 32,000] | VARCHAR(n+), VARGRAPHIC(n+) |
XML | CLOB | VARCHAR(*) [Truncates data if column too small] |