15.10 - Pseudo Type Mappings - ODBC Driver for Teradata

ODBC Driver for Teradata User Guide

prodname
ODBC Driver for Teradata
vrm_release
15.10
category
User Guide
featnum
B035-2509-035K

A number of pseudo SQL type names will be deprecated in a future release. 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)