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)
“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)