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)

    The wider the range of possibilities we offer children, the more intense will be their motivations and the richer their experiences. We must widen the range of topics and goals, the types of situations we offer and their degree of structure, the kinds and combinations of resources and materials, and the possible interactions with things, peers, and adults.
    Loris Malaguzzi (1920–1994)