2017-02-15 1:32 GMT+01:00 Simon Slavin <slav...@bigfraud.org>: > > On 15 Feb 2017, at 12:22am, Cecil Westerhof <cldwester...@gmail.com> > wrote: > > > Is there a way to store an INTEGER in a TEXT field? > > No. But you can do it the other way around. You can store text in an > INTEGER field. Just bind it using sqlite3_bind_textnn() or pass a value > delimited by single quotes. You’ll find that SQLite is happy to store and > retrieve it. >
I thought so, but it never hurts to check. ;-) The table is already defined and it stores mostly text. The fields date, time and type are also relatively big, so I keep it like this and use the view I think. Thanks. -- Cecil Westerhof _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
