> > sqlite> create table t (a, b integer, c real); > this is a great explanation, but, why does 1,2,3 return as > text,integer,integer and not integer,integer,integer?
I suspect that it's because no type was specified for field 'a', so everything is interpreted as text. Brad