15 ms·

Any field in SQLite can contain any type, even if the schema says that a field should be INTEGER, it could have a TEXT, so it's necessary to specify what's the

Any field in SQLite can contain any type, even if the schema says that a field should be INTEGER, it could have a TEXT, so it's necessary to specify what's the type of every single value

maxbond 1y ago
Indeed, unless it's a strict table, you can put gibberish in the type field (or forego giving a column a type altogether).