Teradata Database supports byte data type conversions according to the following table.
Source Data Type | Target Data Type | Allowable Conversions |
---|---|---|
BYTE |
|
|
VARBYTE | ||
BLOB | ||
BYTE | UDT |
|
VARBYTE | ||
BLOB | ||
UDT |
|
Data type conversions involving UDTs require appropriate cast definitions for the UDTs. To define a cast for a UDT, use the CREATE CAST statement. For more information on CREATE CAST, see Teradata Vantageā¢ - SQL Data Definition Language Syntax and Examples, B035-1144. |