On 9/04/2009 8:40 PM, Florian v. Savigny wrote: > > The question was serious, sincere, and earnest! > > > [It] seems [...] that the typeof() column adds no information that > > the quoted value itself does not provide. > > > So, can I simply use quote() [...] to determine the storage > > class SQLite uses? > > It would really be of great help to know this! Is really nobody around > who CAN answer it?
*You* can answer it. Start with the documentation for the quote() function. It says something like it converts the argument into a form that can be put into an SQL statement as a constant. It would be an extremely Bad Thing (TM) if you and the SQL compiler's lexer could not look at a constant and decide very simply which of the 5 basic types it was. Starts with N => NULL Starts with ' => Text Starts with X => BLOB Contains only decimal digits, optionally preceded by - => integer Otherwise it's a float, and if it's not, it'd be fixed before you knew it. HTH, John _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
