3 months ago
- SQLite columns are flexibly typed, allowing any value in any column.
- Columns have a 'type affinity', and SQLite performs implicit conversions, like turning numeric strings into integers.
- The NULL type remains special, and NOT NULL constraints are enforced, unlike other flexible typing aspects.
- SQLite can store mismatched types (e.g., writing bytes as-is) when conversions aren't possible, unlike many databases that might reject such data.