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. |