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