BYTEINT Data Type - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantage™ Data Types and Literals

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

Purpose

Represents a signed binary integer value in the range -128 to 127.

Syntax



attributes
Appropriate data type attributes, column storage attributes, or column constraint attributes.
See Core Data Type Attributes and Storage and Constraint Attributes for specific information.

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.
  • UTS
  • RISC
  • Motorola 68000
  • WE 32000
  • Intel
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);