On 10 Jul 2013, at 8:44am, Woody Wu <narkewo...@gmail.com> wrote: > I have an old dabase, some integer columns were defined as type of > number(2).
It limits the number of digits after the decimal point to 2. In other words, it’s what you might use if you wanted an amount of dollars automatically truncated to cents as the value is stored. It’ll be ignored by SQLite, of course. SQLite will treat the value as REAL and store all the digits it can fit in a REAL. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users