storage class
In SQLite, the actual kind of a stored value: NULL, INTEGER, REAL, TEXT or BLOB.
In more detail
Every value in a SQLite database belongs to one of these five classes, whatever type its column declares. REAL means a floating-point number. The typeof function reports a value's storage class, and an empty cell reports null, which is a class of its own rather than zero or empty text.
Related terms
- type affinity — SQLite's rule that a column's declared type is only a preference: values are converted when sensible and otherwise stored as they are.
- typeof() — A SQLite function that returns the storage class of a value: integer, real, text, blob or null.
- BLOB — A storage class and column type for raw binary data, such as an image, stored exactly as given.
- floating-point number — A number with a fractional part stored in binary, which can only approximate most decimal values.
- NULL — SQL's marker for a missing or unknown value, which is not zero, not empty text and not equal to anything, even another NULL.
Taught in
- Data Types And What To Choose — PostgreSQL, Indexing & Relational Data Modeling