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:
“Mental health data from the 1950’s on middle-aged women showed them to be a particularly distressed group, vulnerable to depression and feelings of uselessness. This isn’t surprising. If society tells you that your main role is to be attractive to men and you are getting crow’s feet, and to be a mother to children and yours are leaving home, no wonder you are distressed.”
—Grace Baruch (20th century)
“If there is nothing new on the earth, still the traveler always has a resource in the skies. They are constantly turning a new page to view. The wind sets the types on this blue ground, and the inquiring may always read a new truth there.”
—Henry David Thoreau (1817–1862)