Thanks, everyone. I appreciate all the insight. As for the data type, I have a few follow up questions...
Does the data type start at being the same as the column affinity in the underlying table and then adjust if the actual data isn't of that type? And, if I don't know the underlying table structure, I am guessing that I should always treat INTEGER as a potential int64? Thanks, Marc > -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Rob Richardson > Sent: Tuesday, February 14, 2012 1:09 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Able to differentiate between No query and empty > results? > > -----Original Message---- > > Also, Stephan is quite right: it's not the columns but the values which > have datatypes, and if you're looking at some random SQLite database > that wasn't carefully created the value in r1c1 may be an integer but > the value in r2c1 may be text. > > Simon. > ------------------------------ > A fact that has driven me up nearby walls on several occasions, > especially when working with date/times. > > RobR > _______________________________________________ > 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
