Friday, December 11, 2015

SQLite no concept of boolean - stored as 0 or 1

A simple but useful

SQLite does not have a separate Boolean storage class. Instead, Boolean values are stored as integers 0 (false) and 1 (true).

select * from table where deleted='false' which is wrong instead you have to write 
select * from table where deleted=0

No comments:

Post a Comment