Eric Scouten wrote:
On 10 May 2006, at 16:31, sqlite wrote:
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".
Depends on your application. For us, it's been a very natural fit. It
may not fit your data or coding style well; if so, then you may want to
consider other DB engines.
It's like "dynamic typing" vs. "static typing"
in your computer language. Both have advantages...
Whatever, I've reworked the code to associate
the "type" with the data value instead of the
column and it's all working now.
I'm writing a wrapper and I figure it will be
easier to make other database engines work
the SQLite way than to make SQLite work the
other way around.
