3 ms·

But it is dynamic typing. The type in sqlite is associated with the value. For example you can have a number column, but actually store a string in it. Proper

by anyfoo 5y ago

But it is dynamic typing. The type in sqlite is associated with the value. For example you can have a number column, but actually store a string in it. Proper shocked now?

deleted 5y ago
[deleted]
neolog 5y ago
I guess it depends if you consider columns values or expressions. A dynamically typed number column would not accept non-number values.
- anyfoo 5y ago
  sqlite does accept non-number values in a number column, and gives them back in those non-number types.
- jayd16 5y ago
  The breakdown is it appears SQLite columns are not actually typed. Its just a hint. Only the values are typed.
vbezhenar 5y ago
How do you store "001" string in a number column?