16.20 - Data Storage of Byte and BLOB Types - Teradata Vantage NewSQL Engine

Teradata Vantage™ Data Types and Literals

Teradata Database
Teradata Vantage NewSQL Engine
March 2019
Programming Reference

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.