SQLite/SQL standard divergences

Types
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.