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:

    “To write it, it took three months; to conceive it three minutes; to collect the data in it—all my life.”
    —F. Scott Fitzgerald (1896–1940)

    “Our major universities are now stuck with an army of pedestrian, toadying careerists, Fifties types who wave around Sixties banners to conceal their record of ruthless, beaverlike tunneling to the top.”
    —Camille Paglia (b. 1947)