15.10 - BYTE Data Type - Teradata Database

Represents a fixed-length binary string.

where:

Syntax element …	Specifies …
n	the number of bytes in the string. The maximum value for n is 64000.
attributes	appropriate data type, column storage, or column constraint attributes. See “Core Data Type Attributes” on page 17 and “Storage and Constraint Attributes” on page 18 for specific information.

BYTE is a Teradata extension to the ANSI SQL:2011 standard.

The following table lists the client representations for the BYTE data type.

Determining the application definitions and client data types is the responsibility of the application programmer.

Client CPU Architecture	Client Internal Data Format
IBM mainframe	n bytes.
UTS RISC Motorola 68000 WE 32000 Intel	n bytes.

If no value is specified for n, the default is BYTE(1).

In the following example, the column named BinaryData is assigned the BYTE data type and has an upper limit of 1200 bytes:

   CREATE TABLE DocTable

     (DocType INTEGER

     ,DocName CHAR(26)

     ,BinaryData BYTE(1200));