TEXT

The column type for character strings such as names, cities and, in SQLite, dates written as text.

In more detail

A text value in SQL is written between single quotes. Text sorts character by character, which is why dates stored as text must be written year first to sort in date order.

Related terms

Taught in

References

Certification courses