American National Standards Institute SQL standard data type BOOLEAN is directly supported in Exasol. The ANSI 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) |