Eric Scouten wrote:
No such thing, really. In SQLite the data types are associated with the cell, not the column.
Yes, I saw that. I'm not sure it's a good "feature".
The "declared type" of a column that you've found is used to establish preferences for how cells are stored, but it is not a hard requirement (unlike most other SQL implementations).
Internally SQLite seems to have a column "affinity". That's what I need...