This may help http://stackoverflow.com/questions/5562322/difference-between-int-and-int3-data-types-in-my-sql
On 10/07/2013, at 6:33 PM, Woody Wu <narkewo...@gmail.com> wrote: > On Wed, Jul 10, 2013 at 10:50:06AM +0200, Paolo Bolzoni wrote: >> Yes, I think it is possible to put only for >> compatibility reasons. Maybe in some >> other db systems you can set the magnitude? > Understood. I also don't know why there are number(2) in the schema > that I saw. It's just a database created many years ago, probabaly > sqlite supported that then. Thanks for your explaination. > >> On Wed, Jul 10, 2013 at 10:06 AM, Woody Wu <narkewo...@gmail.com> wrote: >>> On Wed, Jul 10, 2013 at 09:53:41AM +0200, Paolo Bolzoni wrote: >>>> See here: >>>> http://www.sqlite.org/datatype3.html >>>> >>>> I think it just means Integer. And its >>>> size depends on the magnitude of the >>>> number stored. >>> >>> I've read the doc, it's not so easy to understand. >>> >>> Did you mean, in number(N), N will not make difference, right? >>> >>> Thanks! >>> _______________________________________________ >>> 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 > > -- > I can't go back to yesterday - because I was a different person then > _______________________________________________ > 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
