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