> 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