SQLite/SQL standard divergences

Types edit

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.[1]

References edit

  1. Result Values From A Query sqlite.org, SQLite C Interface, visited 7 May 2019