Is there a boolean literal in SQLite?

boolean, literals, sqlite

Solution

From section 1.1 Boolean Datatype of the docs:

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

So it looks like you are stuck with `0` and `1`.

Problem

I know about the `boolean` column type, but is there a `boolean` literal in SQLite? In other languages, this might be `true` or `false`. Obviously, I can use `0` and `1`, 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.)

Original source