> Le 2 mars 2018 à 13:19, Richard Hipp <d...@sqlite.org> a écrit : > >> Will insert into T values(FALSE) actually store integer 0 no matter column >> affinity or will it follow affinity? > > No. FALSE is merely an alias for 0. Affinity still applies. If the > column is of type TEXT, then it will store '0', not 0.
Thank you very much for the precise answer on that and others questions. So FALSE is alias to 0, and then follows affinity. In such a context of storing, is TRUE an alias to 1? And so leading to 1, '1' or 1.0 following affinity? Looks like evidence, but want to be sure I got the model right. -- 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
