> On Sep 6, 2017, at 2:37 PM, Cecil Westerhof <cldwester...@gmail.com> wrote: > > But should in the first case the 0 not be cast to a 0.0?
No, SQLite ignores column type declarations. There's a whole article on the website on SQLite's dynamic approach to data typing. —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users