Insert boolean value into sqlite table
SQLite does not have a separate Boolean storage class.Boolean values are stored as integers 0 and 1. source
Yes, the BOOL type is synonymous to a BIT in many databases, including SQLite and SQL Server. Other databases, like Oracle, do not even have a boolean type and a NUMBER(1) field is used to store boolean values by convention.