Ingres (database) - Data Types

Data Types

Ingres supports the conventional data types such as:

  • integers (1 byte, 2 byte, 4 byte and 8 byte)
  • floats (4 byte, 8 byte)
  • fixed precision numbers (numeric/decimal)
  • characters (fixed and variable length)
  • binary (fixed and variable length)
  • dates and times (ANSI date, time, and timestamp)

Ingres supports Unicode with types:

  • nchar
  • nvarchar

Ingres supports large objects with:

  • long varchar
  • long byte

Ingres supports proprietary types such as:

  • ingres date
  • money

Ingres supports geospatial data types (version 10S and later):

  • point, multipoint
  • linestring, multilinestring
  • polygon, multipolygon
  • geometry, geometrycollection

Read more about this topic:  Ingres (database)

Famous quotes containing the words data and/or types:

    “This city is neither a jungle nor the moon.... In long shot: a cosmic smudge, a conglomerate of bleeding energies. Close up, it is a fairly legible printed circuit, a transistorized labyrinth of beastly tracks, a data bank for asthmatic voice-prints.”
    —Susan Sontag (b. 1933)

    “He types his laboured column—weary drudge!
    Senile fudge and solemn:
    Spare, editor, to condemn
    These dry leaves of his autumn.”
    —Robertson Davies (b. 1913)