On: First Contact with SQLite

[_dain_]

>SQLite doesn’t have data types on columns. Data types (and there are only five) are on values only, so anything can go anywhere.

You can use CREATE TABLE STRICT[1] to get a typed table.

[1] https://www.sqlite.org/stricttables.html

[frizlab → _dain_]

The article mention that too.