SQLite/SQL standard divergences
SQLite is dynamically typed. This means that as you fill columns the affinity depends on the content. Four data types exist except NULL: BLOB, INTEGER, REAL (aka FLOAT) and TEXT.
- ↑ Result Values From A Query sqlite.org, SQLite C Interface, visited 7 May 2019