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

HASHTYPE[(n BYTE | m BIT)]

1 ≤ n ≤ 1024 BYTE
8 ≤ m ≤ 8192 BIT

When specifying the size in bits, the number of bits m must always be a multiple of 8.