SQLite/SQL standard divergences

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

Types[edit | edit source]

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 | edit source]

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