4 ms·
Weird. They never mentioned the amazing power of inserting text and numbers into a boolean column.
by JimmaDaRustla 6y ago
Weird. They never mentioned the amazing power of inserting text and numbers into a boolean column.
- justin_oaks 6y agoI assume you're being sarcastic because I haven't yet thought of a reason why that'd be a good thing. Although I've never been bitten by SQLite's dynamic types, I wish they weren't a thing. I'm genuinely curious if there are any real use-cases for this behavior.
- samatman 6y agoBOOLEAN in SQLITE is spelled `flag INTEGER NOT NULL CHECK (flag = 0 or flag = 1)`. Less than ideal, sure. But typing is there when you want to reach for it.