Data Types

Table 86. Teradata Data Types
Teradata	ODBC
Blob¹	SQL_LONGVARBINARY
Bigint²	SQL_BIGINT
Byte	SQL_BIT
Byteint	SQL_TINYINT
Char	SQL_CHAR
Clob³	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
Numeric	SQL_NUMERIC
Real	SQL_REAL
Smallint	SQL_SMALLINT
Time	SQL_TYPE_TIME
Timestamp	SQL_TYPE_TIMESTAMP
Varchar	SQL_VARCHAR

¹ If no LOB support, VARBYTE(32000).

² Supported only on Teradata 6.2 and higher.

³ If no LOB support, LONGVARCHAR.

⁴ Precision of 18 unless on a Teradata 6.2 or higher server that supports large decimal types.

⁵ Supported only on Teradata 6.2 and higher when EnableExtendedStmtInfo is enabled.

⁶ Supported only on Teradata 6.2 and higher when EnableExtendedStmtInfo is enabled.