Is there a boolean literal in SQLite?
Share this page | Read it later using CloudBreak Wallabag
From my question on StackOverflow (CC BY-SA 3.0):
I know about the
booleancolumn type, but is there abooleanliteral in SQLite? In other languages, this might betrueorfalse. Obviously, I can use `` and1, but I tend to avoid so-called “magic numbers” where possible.From this list, it seems like it might exist in other SQL implementations, but not SQLite. (I’m using SQLite 3.6.10, for what it’s worth.)