Indeed it does. If you insert something that smells like an integer in a column with integer affinity, it will be stored as an integer (rather than text, for example).
>-----Original Message----- >From: [email protected] [mailto:sqlite-users- >[email protected]] On Behalf Of Johnny >Sent: Friday, 31 January, 2014 13:41 >To: [email protected] >Subject: Re: [sqlite] Boolean and DataReader > >But sqlite is typeless... so the affinity does not change much... :-( >A constraint check in (0,1) is needed for a reliable boolean type > > > >-- >View this message in context: >http://sqlite.1065341.n5.nabble.com/Boolean-and-DataReader- >tp73521p73600.html >Sent from the SQLite mailing list archive at Nabble.com. >_______________________________________________ >sqlite-users mailing list >[email protected] >http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
