SQL Reference Guide > SQL Reference Guide > Understanding SQL Data Types
Was this helpful?
Understanding SQL Data Types
SQL Data Types
Ingres supports the following data types:
Class
Data Type
Description
Character
CHAR
CHAR(size)
Fixed-length character string having maximum length size bytes up to 32,000.
 
VARCHAR
VARCHAR(size)
Variable-length character string having maximum length size bytes up to 32,000.
 
LONG VARCHAR
LONG VARCHAR(size)
CLOB(size)
Variable-length character string having maximum length size bytes up to 2 GB.
 
NCHAR
NCHAR(size)
Fixed-length Unicode string having maximum length size characters up to 16,000.
 
NVARCHAR
NVARCHAR(size)
Variable-length Unicode string having maximum length size characters up to 16,000.
 
LONG NVARCHAR
LONG NVARCHAR(size)
NCLOB(size)
Variable-length Unicode string having maximum length size characters up to 2 GB.
 
C
C(size)
(Deprecated) Fixed-length character string supported for backward compatibility. CHAR is the preferred type.
 
TEXT
TEXT(size)
(Deprecated) Variable-length character string supported for backward compatibility. VARCHAR is the preferred type.
Numeric
INTEGER1
INTEGER1
TINYINT
Exact number that requires one byte.
 
INTEGER2
INTEGER2
SMALLINT
Exact number that requires two bytes.
 
INTEGER4
INTEGER4
INTEGER
Exact number that requires four bytes.
 
INTEGER8
INTEGER8
BIGINT
Exact number that requires eight bytes.
 
DECIMAL
DECIMAL(p,s)
Exact number with precision p and scale s.
 
FLOAT
FLOAT[(n)]
FLOAT8[(n)]
Approximate number that requires eight bytes with optional minimum required binary precision of n (24 to 53).
 
FLOAT4
FLOAT4[(n)]
REAL[(n)]
Approximate number that requires four bytes with optional minimum required binary precision of n (0 to 23).
Date and time
ANSIDATE
ANSIDATE
Year, month, day in the format yyyy-mm-dd.
 
TIME WITHOUT TIME ZONE
TIME[(n)]
Hour, minutes, seconds with n digits of precision in the fractions of seconds.
 
TIME WITH TIME ZONE
TIME[(n)] WITH TIME ZONE
Hour, minutes, seconds with n digits of precision in the fractions of seconds, at the specified time zone.
 
TIME WITH LOCAL TIME ZONE
TIME[(n)] WITH LOCAL TIME ZONE
Hour, minutes, seconds with n digits of precision in the fractions of seconds, in local time zone.
 
TIIMESTAMP WITHOUT TIME ZONE
TIMESTAMP[(n)]
Year, month, day, time with n digits of precision in the fractions of seconds.
 
TIMESTAMP WITH TIME ZONE
TIMESTAMP[(n)] WITH TIME ZONE
Hour, minutes, seconds with n digits of precision in the fractions of seconds, at the specified time zone.
 
TIMESTAMP WITH LOCAL TIMEZONE
TIMESTAMP[(n)] WITH LOCAL TIME ZONE
Hour, minutes, seconds with n digits of precision in the fractions of seconds, in local time zone.
 
INTERVAL YEAR TO MONTH
INTERVAL YEAR TO MONTH
An interval of years and months.
 
INTERVAL DAY TO SECOND
INTERVAL DAY TO SECOND[(n)]
An interval of days and seconds with n digits of precision in the fractions of seconds.
 
INGRESDATE
Absolute date, absolute time, combined date and time, or interval. Input formats vary.
 
DATE
DATE
An alias configured to either ANSIDATE or INGRESDATE on date_alias parameter.
Abstract
MONEY
MONEY
Monetary amount in the range -999,999,999,999.99 to 999,999,999,999.99
 
LOGICAL_KEY
A unique key value assigned to each row by the DBMS Server or application.
 
IPV4
IPV4
An IPv4 host address.
4-byte, network address in dotted-decimal notation (four decimal numbers, each ranging from 0 to 255, separated by dots). For example: 172.16.254.1
 
IPV6
IPV6
An IPv6 host address.
16-byte, network address in eight groups of four hexadecimal digits separated by colons. For example: 2001:0db8:85a3:0042:1000:8a2e:0370:7334
 
UUID
UUID
A unique 128-bit integer.
Binary
BYTE
BYTE(size)
Fixed length binary object having maximum length size bytes.
 
VARBYTE
VARBYTE(size)
Varying length binary object having maximum length size bytes.
 
LONG BYTE
LONG BYTE(size)
Varying length binary large object having maximum length size bytes, up to 2 GB.
Boolean
BOOLEAN
BOOLEAN
Literal values TRUE or FALSE, strings 'TRUE' or 'FALSE'
Spatial
 
See the Geospatial User Guide.
Last modified date: 08/29/2024