SQLite Forum

Using coalesce in where clause
> it is indeed defined as char, but trying '7' did not help

Note that "defined as" (in the column declaration) means next to nothing in sqlite. sqlite will happily store any type in any column, and may store different types for the same column of different rows. What's significant is whether the data are actually saved as numbers or strings, not whether they're *declared* as such. See the "manifest typing" section of [this page](https://www.sqlite.org/different.html) for details.