The following table shows how the Teradata data types map to the standard ODBC data types.

Table 1. Teradata Data Types
Teradata ODBC
Blob1 SQL_LONGVARBINARY
Bigint SQL_BIGINT
Byte SQL_BIT
Byteint SQL_TINYINT
Char SQL_CHAR
Clob2 SQL_LONGVARCHAR
Date SQL_TYPE_DATE
Decimal SQL_DECIMAL
Double SQL_DOUBLE
Float SQL_FLOAT
Integer SQL_INTEGER
Interval day SQL_INTERVAL_DAY
Interval day to hour SQL_INTERVAL_DAY_TO_HOUR
Interval day to minute SQL_INTERVAL_DAY_TO_MINUTE
Interval day to second SQL_INTERVAL_DAY_TO_SECOND
Interval hour SQL_INTERVAL_HOUR
Interval hour to minute SQL_INTERVAL_HOUR_TO_MINUTE
Interval hour to second SQL_INTERVAL_HOUR_TO_SECOND
Interval minute SQL_INTERVAL_MINUTE
Interval minute to second SQL_INTERVAL_MINUTE_TO_SECOND
Interval month SQL_INTERVAL_MONTH
Interval second SQL_INTERVAL_SECOND
Interval year SQL_INTERVAL_YEAR
Interval year to month SQL_INTERVAL_YEAR_TO_MONTH
Number SQL_DOUBLE
Number (p) SQL_BIGINT | SQL_DECIMAL3
Number (p, s) SQL_DECIMAL
Numeric SQL_NUMERIC
Real SQL_REAL
Smallint SQL_SMALLINT
Time SQL_TYPE_TIME
Timestamp SQL_TYPE_TIMESTAMP
Varchar SQL_VARCHAR
1 If no LOB support, VARBYTE(32000).
2 If no LOB support, LONGVARCHAR.
3 When precision is less than or equal to 19, Number maps to SQL_BIGINT. When precision is greater than 19, it maps to Decimal.