Pseudo Type Mappings (deprecated in 16.20)

ODBC Driver for Teradata® User Guide

prodname
ODBC Driver for Teradata
vrm_release
16.20
category
User Guide
featnum
B035-2526-108K

A number of pseudo SQL type names are deprecated as of 16.20. The names are not used in Teradata SQL and are not required in ODBC. They were introduced in the Teradata ODBC driver to facilitate migration of early applications from non-Teradata environments.

The names could be used in table column definitions and in certain type casts. The ODBC parser changed the pseudo-type to a suitable Teradata SQL data type. The following table summarizes the deprecated pseudo-types.

Instead of this pseudo SQL data type Use the following Teradata SQL Data Type
BINARY[(n)] BYTES[(n)]
BIT BYTEINT FORMAT ‘9’
DOUBLE FLOAT or DOUBLE PRECISION
LONG VARBINARY VARBYTE(32000)
TINYINT BYTEINT
VARBINARY(n) VARBYTE(n)