On Mon, 2007-01-29 at 19:26 -0300, Brodie Thiesfield wrote: > Does sqlite support numeric literals in hexadecimal? > e.g.INSERT INTO table(mask) VALUES (0xFFFF);
I don't think so. > Additionally, is there a constant like MAX_INTEGER defined which I can > use as the maximum value that an INTEGER field supports (assuming that > types actually exist)? SQLite supports signed 64 bit integers. So MAX_INTEGER is (2^63 - 1) Any integer literal outside this range is stored as a 64-bit IEEE float (i.e. lossy storage). Dan. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------