Data Storage of Byte and BLOB Types | Data Types and Literals | Teradata Vantage - 17.10 - Data Storage of Byte and BLOB Types - Advanced SQL Engine - Teradata Database

Teradata Vantageâ„¢ - Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1143-171K
Language
English (United States)

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

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.