Data Storage of Byte and BLOB Types

Teradata Vantageâ„¢ Data Types and Literals

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1143-162K

The BYTE, VARBYTE, and BLOB data types are stored in the client system format—they are never translated by Teradata Database.

The BYTE, VARBYTE, and BLOB data types store raw data as logical bit streams. For any machine, BYTE, VARBYTE, and BLOB data is transmitted directly from the memory of the client system. The sort order is logical, and values are compared as if they were n-byte, unsigned binary integers suitable for digitized images.

Logical bit streams are not translated. However, the interpretation of a hexadecimal string in EBCDIC form depends on the client system from which that string is submitted.

BLOB is ANSI SQL:2011 compliant. BYTE and VARBYTE are Teradata extensions to the ANSI standard.