BIGINT Data Type Usage Notes - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
  • Storage

    BIGINT values are stored as eight bytes with the least significant byte first.

  • External Representation of BIGINT

    The following table lists the client representations for the Teradata BIGINT data type.

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

    Client CPU Architecture Client Representation
    IBM mainframe Eight byte 64-bit signed 2’s complement binary number, most significant byte first.
    • UTS
    • RISC
    • Motorola 68000
    • WE 32000
    Eight byte 64-bit signed 2’s complement binary number, most significant byte first.
    Intel Eight byte 64-bit signed 2’s complement binary number, least significant byte first.
  • Format

    For information on the default display format, see Data Type Default Formats.