Boolean data type

The SQL standard data type BOOLEAN is directly supported in Exasol.

Data type Range Note

BOOLEAN

TRUE, FALSE, NULL (unknown)

Integers or strings (case-insensitive) can be interpreted as well as boolean literals:

TRUE, 1, '1', 'T', 't', 'TRUE' , 'true'

FALSE, 0, '0', 'F', 'f', 'FALSE' , 'false'