On Mon, Dec 9, 2013 at 11:12 AM, RSmith <rsm...@rsweb.co.za> wrote: > > On 2013/12/09 15:32, Simon Slavin wrote: > >> First, never do this: >> >>> CREATE TABLE IF NOT EXISTS T1(F1,F2,F3,F4,SUBTOTAL); >>> >> Always define your column types. In your case you'd be using either >> INTEGER or REAL. >> > > Agreed, those Columns have TEXT affinity by default which is wholly > unsuitable for numeric comparisons such as those that prompted this thread. >
The default affinity is "NONE". Which basically means the SQLite leaves your data alone and does not try to coerce it into one datatype or another. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
