The BOOL type stores simple Boolean (true/false) values and is used for simple query filtering.
Additional information
Use this table to determine how integer and string values are represented when added to a Boolean column.
data
value
bool
integer
0
0
integer > 0
1
1
string
empty, 0, f, false
0
string
other string values
1
Examples
CREATE TABLE with all data types
createtableallcoltypes(_idid,intcolintmin0max10000,boolcolbool,timestampcoltimestamptimeunit'ms',decimalcoldecimal(2),stringcolstring,stringsetcolstringset,stringsetcolqstringsetqtimequantum'YMD'ttl'24h',idcolid,idsetcolidset,idsetcolqidsetqtimequantum'YMD'ttl'24h')comment'table containing all column types';