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 children evaluate themselves based on the opinions we have of them. When we use harsh words, biting comments, and a sarcastic tone of voice, we plant the seeds of self-doubt in their developing minds.... Children who receive a steady diet of these types of messages end up feeling powerless, inadequate, and unimportant. They start to believe that they are bad, and that they can never do enough.
    Stephanie Martson (20th century)