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

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-25
dita:mapPath
fxv1527114222338.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

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)