This section explains the data types and aliases supported by Exasol.
Besides the standard ANSI
American National Standards Institute SQL data types, some additional data types are implemented that ensure compatibility with other databases.
Overview of Exasol Data Types
The following table provides an overview of the defined data types in Exasol.
| Exasol Type (ANSI type) | Note |
|---|---|
| BOOLEAN |
|
| CHAR(n) |
1 ≤ n ≤ 2,000 |
| DATE |
|
| DECIMAL (p,s) |
s ≤ p ≤ 36 p ≥ 1; s ≥ 0 |
| DOUBLE PRECISION |
|
| GEOMETRY[(srid)] |
srid defines the coordinate system. For more information, see EXA_SPATIAL_REF_SYS. |
| INTERVAL DAY [(p)] TO SECOND [(fp)] |
1 ≤ p ≤ 9, 0 ≤ fp ≤ 9, accuracy precise to a millisecond |
| INTERVAL YEAR [(p)] TO MONTH |
1 ≤ p ≤ 9 |
| TIMESTAMP(3) |
Timestamp with accuracy precise to a millisecond |
| TIMESTAMP(3) WITH LOCAL TIME ZONE |
Timestamp that considers the session time zone |
| VARCHAR(n) |
1 ≤ n ≤ 2,000,000 |
| HASHTYPE[(n BYTE | m BIT)] |
1 ≤ n ≤ 1024 BYTE When specifying the size in bits, the number of bits m must always be a multiple of 8. |
You can find further details about data types in the below pages:
