>SQLite does not understand column types like "numeric(10,0)". It has only two number types: INTEGER and >REAL.
So if the column is datatype REAL and you will store amount 50000, SQLite results in 5000.0 ? Why not 50000.0 ? And if the columns datatype is REAL, you need a helper tool or script which adds the ".0" at the end of the amount at PHP server side, if the <form> textfield only allows numbers for salary. ? (if you want to store the correct value) regards Werner -- View this message in context: http://sqlite.1065341.n5.nabble.com/Storing-amount-tp75527p75533.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users