On Thu, Jul 01, 2010 at 03:44:52PM +0100, Simon Slavin scratched on the wall: > > There is no such datatype as 'INT' in SQLite.
SQLite doesn't have defined datatypes, so I suppose you could say this is correct. But if you want to say that SQLite has no 'INT' datatype, it is just as legit to say that SQLite has no 'INTEGER' datatype either. > No part of SQLite should be declaring /any/ column as having an > affinity of 'INT'. It isn't. It is defining the *datatype* as INT. Under the rules laid out in section 2.1 of http://www.sqlite.org/datatype3.html, that will be translated into an integer affinity. And, I might point out, that the key sub-string that makes a datatype string translate into an integer affinity is 'INT.' Just 'INT.' So if you want to make an argument for the purest representation of an integer affinity, the only logical answer is 'INT.' -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
