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