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