I use Blob because I don't know how many bits I must use (maybe 1024 bits or more). It's the user choice not mine. Moreover, I think Blob takes less space than Bool field (which is TINYINT or somethings like that).
Thanks for your reply -----Message d'origine----- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] la part de Alexey Pechnikov Envoyé : lundi 7 juillet 2008 13:27 À : General Discussion of SQLite Database Objet : Re: [sqlite] Bits selection В сообщении от Monday 07 July 2008 13:42:11 Raphaël KINDT написал(а): > Hello, > > I use an events table which looks like this: > > CREATE TABLE events( > time REAL NOT NULL, > detections BLOB); > > I want to select all events which have the BIT3 of detections field enable > between two time. > How can I do that with the SELECT request? Why you write bits to database? You may create some bool fields. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
