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)
“Science is intimately integrated with the whole social structure and cultural tradition. They mutually support one other—only in certain types of society can science flourish, and conversely without a continuous and healthy development and application of science such a society cannot function properly.”
—Talcott Parsons (1902–1979)