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)

    “The American man is a very simple and cheap mechanism. The American woman I find a complicated and expensive one. Contrasts of feminine types are possible. I am not absolutely sure that there is more than one American man.”
    —Henry Brooks Adams (1838–1918)