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) |