There is no native boolean data type for SQLite. Per the Datatypes doc:
SQLite does not have a separate Boolean storage class. Instead, Boolean values are stored as integers 0 (false) and 1 (true).
More Related Contents:
- How do I rename a column in a SQLite database table?
- How do I check in SQLite whether a table exists?
- Accessing an SQLite Database in Swift
- Import CSV to SQLite
- Difference between 2 dates in SQLite
- Select random row from a sqlite table
- How to get Top 5 records in SqLite?
- Insert new column into table in sqlite?
- Sqlite primary key on multiple columns
- SQLite Schema Information Metadata
- How to create custom functions in SQLite
- SQLite: How do I save the result of a query as a CSV file?
- What is the difference between SQLite integer data types like int, integer, bigint, etc.?
- is there a limit to the size of a SQLite database?
- How to generate all dates between two dates
- SQLITE_BUSY The database file is locked (database is locked) in wicket
- Does it matter what extension is used for SQLite database files?
- SQLite “INSERT OR REPLACE INTO” vs. “UPDATE … WHERE”
- How do I DROP a constraint from a sqlite (3.6.21) table?
- Sqlite over a network share [closed]
- SQLite table constraint – unique on multiple columns
- Is there a boolean literal in SQLite?
- Modify a Column’s Type in sqlite3
- Case sensitive and insensitive like in SQLite
- Will SQLite performance degrade if the database size is greater than 2 gigabytes?
- SQLite for large data sets?
- sql query – how to apply limit within group by
- SQLite database supporting Unicode data
- Creating stored procedure in SQLite
- SQLITE3 VACUUM, “database or disk is full”