Any field in SQLite can contain any type, even if the schema says that a field s... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		lawrencejgd 6 months ago \| parent \| context \| favorite \| on: SQLite's File Format 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 6 months ago [–]

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

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact