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
- data type — The kind of a value, such as a whole number, text or a date, which decides what you can do with it and how it compares and sorts.
- string literal — A fixed text value written directly in a query between single quotes, such as 'Lagos'.
- ISO 8601 date format — The international standard for writing dates and times as text, such as 2024-01-15T10:00:00Z.
Taught in
- Forty Terabytes Nobody Opens: Storage And Databases — CompTIA Cloud+ (CV0-004) Exam Prep
- Why Tables And Relations Beat Files — PostgreSQL, Indexing & Relational Data Modeling
- Data Types And What To Choose — PostgreSQL, Indexing & Relational Data Modeling