Lecture 9: SQLite

Question 1

Datatypes in SQLite can be broadly divided
into five categories:

Answer 1

– INTEGER
– TEXT (CHAR, VARCHAR, TEXT, …)
– NONE
– REAL (REAL, DOUBLE, FLOAT, …)
– NUMERIC (BOOLEAN, DATETIME, NUMERIC, …)

Later on (and according to https://www.sqlite.org/datatype3.html):
- NULL. The value is a NULL value.
- INTEGER. The value is a signed integer, stored in 0, 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.
- REAL. The value is a floating point value, stored as an 8-byte IEEE floating point number.
- TEXT. The value is a text string, stored using the database encoding (UTF-8, UTF-16BE or UTF-16LE).
- BLOB. The value is a blob of data, stored exactly as it was input.