Represents a signed binary integer value in the range -128 to 127.
Syntax
BYTEINT [ attributes [...] ]
- attributes
- Appropriate data type attributes, column storage attributes, or column constraint attributes.
ANSI Compliance
BYTEINT is a Teradata extension to the ANSI SQL:2011 standard.
Storage
BYTEINT is stored as one byte.
External Representation of BYTEINT
The following table lists the client representations for the BYTEINT data type.
Determining the application definitions and client data types is the responsibility of the application programmer.
| Client CPU Architecture | Client Representation |
|---|---|
| IBM mainframe | One byte 8-bit signed 2’s complement binary number. |
|
One byte 8-bit signed 2’s complement binary number. |
Format
BYTEINT format is described in Data Type Default Formats.
Example: BYTEINT Data Type
In the following table definition, column EdLev is a BYTEINT data type:
CREATE TABLE Education (Id CHAR(9) ,LastName CHAR(26) ,EdLev BYTEINT FORMAT 'Z9' CHECK (EdLev BETWEEN 0 AND 22) NOT NULL);