SQLite/SQL standard divergences

From Wikibooks, open books for an open world
Jump to navigation Jump to search


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]


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