17.20 - Pseudo Type Mappings (deprecated in 16.20) - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2022-06-21
dita:mapPath
uqj1639470627591.ditamap
dita:ditavalPath
nkw1500504256726.ditaval

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)