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