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 |
Time stamp with accuracy precise to a millisecond |
| TIMESTAMP WITH LOCAL TIME ZONE |
Time stamp which considers the session time zone |
| VARCHAR(n) |
1 ≤ n ≤ 2,000,000 |
