Boolean Data Type

The ANSIClosed American National Standards Institute SQL standard data type BOOLEAN is directly supported in Exasol.

Exasol Type (ANSI type) Range Note
BOOLEAN TRUE, FALSE NULL/UNKNOWN

Instead of Boolean literals, the following numbers and strings can be interpreted: 

TRUE: 1, '1', 'T', 't', 'TRUE' (case insensitive)

FALSE: 0,'0','F','f','FALSE' (case insensitive)