Data Types
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)]
|
|
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
|
Timestamp with accuracy precise to a millisecond |
TIMESTAMP
|
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 |
You can find further details about data types in the below pages: