typeof()

A SQLite function that returns the storage class of a value: integer, real, text, blob or null.

In more detail

It is the quickest way to see what SQLite actually stored, which can differ from the column's declared type in a table that is not STRICT. Asking for the type of an empty cell returns null, which is a storage class of its own.

Example

SELECT n, typeof(n) FROM loose;

Related terms

Taught in

References