Data Types Table 23-2 shows how the Teradata data types map to the standard ODBC data types. Table 23-2. Teradata Data Types Teradata ODBC Blob 1 SQL_LONGVARBINARY Bigint 2 SQL_BIGINT Byte SQL_BIT Byteint SQL_TINYINT Char SQL_CHAR Clob 3 SQL_LONGVARCHAR Date SQL_TYPE_DATE Decimal 4 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 5 SQL_INTERVAL_MINUTE Interval minute to second SQL_INTERVAL_MINUTE_TO_SECOND Interval month 5 SQL_INTERVAL_MONTH Interval second SQL_INTERVAL_SECOND Interval year SQL_INTERVAL_YEAR Interval year to month SQL_INTERVAL_YEAR_TO_MONTH 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 Supported only on Teradata 6.2 and higher. 3 If no LOB support, LONGVARCHAR. 4 Precision of 18 unless on a Teradata 6.2 or higher server that supports large decimal types. 5 Supported only on Teradata 6.2 and higher when EnableExtendedStmtInfo is enabled. See “Retrieving Data Type Information” for information about retrieving data types.