SMALLINT Data Type Usage Notes - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
  • Storage

    SMALLINT values are stored as two bytes, with the least significant byte first.

  • External Representation of SMALLINT

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

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

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

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