> SQLite does not have column types. It has column affinities instead. OK, so I would like to see that declared column affinity as that will determine how to process the data. I have no problem doing this on the Windows PC. More difficult though to do this on Android.
RBS On Tue, May 8, 2018 at 5:29 PM, Simon Slavin <slav...@bigfraud.org> wrote: > On 8 May 2018, at 4:19pm, Bart Smissaert <bart.smissa...@gmail.com> wrote: > > > Just tested that (TypeOf) on the Android phone and it doesn't do what I > > wanted. > > I tested on a column declared Real but with text values in it as well. > > It will give both real and text and what I wanted was to produce only > real > > as that > > is what the column is declared as. > > SQLite does not have column types. It has column affinities instead. > When you supply a value for a column SQLite will try to convert it into the > desired type, but if it cannot do so (for instance, the column is type REAL > but you supply "hello") then it will store the text instead. > > If you don't want to see text in your numeric columns, don't store text in > your numeric columns. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users