On Jan 12, 2009, at 11:10 AM, vlema...@ausy.org wrote: > Hello, > > As described in SQL syntax > (http://www.sqlite.org/syntaxdiagrams.html#type-name) a column type > may be > declared like this : > int(x) > or float(x, y) > ... > > what does x and y means ? max number of digits ? max value ? max bytes > encoding ? ... > > a subsidiary question is : how to specify a precision on numbers if > this > syntax is not appropriated ?
The x and y are for compatibility with other database engines. They are ignored by SQLite. SQLite stores numbers as either (1) 64-bit signed integers or (2) 64-bit IEEE floating point numbers. > > > Thanks, > > Vincent > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
