SQLite Forum

Bug when converting string to boolean?
Login
> What is the meaning of = in SQLite?

In SQL, `=` means the same as `==` does in most programming languages, and sqlite allows `==` as an alias for `=`. The `IS` keyword, however, works differently:

```
NULL == NULL // ==> NULL
NULL IS NULL // ==> 1 (true)
```

That's an SQL thing, not specific to sqlite.