> Le 30 juin 2018 à 09:04, Thomas Kurz <sqlite.2...@t-net.ruhr> a écrit :
>
> CREATE TABLE a (col1 STRING);
> INSERT INTO a (col1) VALUES ("3.0");
> SELECT * from a;
> ---> 3 // this should never happen!!
SQLite type affinity rules clearly do not recognise STRING as TEXT: it does so
only when the type contains the words CHAR, TEXT or CLOB. STRING, which you
use for your example, is even specifically warned about (being of NUMERIC
affinity).
https://www.sqlite.org/datatype3.html#determination_of_column_affinity
--
Best Regards, Meilleures salutations, Met vriendelijke groeten,
Olivier Mascia
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
