On Tue, 14 Feb 2012 18:08:39 +0000, Rob Richardson <rdrichard...@rad-con.com> wrote:
>>-----Original Message---- >> >> Also, Stephan is quite right: it's not the columns >> but the values which have datatypes, and if you're >> looking at some random SQLite database that wasn't >> carefully created the value in r1c1 may be an >> integer but the value in r2c1 may be text. >> >>Simon. >>------------------------------ > > A fact that has driven me up nearby walls on several > occasions, especially when working with date/times. > > RobR You can more or less restrict the datatypes a table can contain by specifying CHECK constraints in your table definitions. You'll have to experiment to see what works and what doesn't. -- Regards, Kees Nuyt _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
