Hello Simon, thanks for help. I use the PDO library. The typeOf results in "real"
If I change the "swsalary" column to "numeric(10,0) it results in integer and then the value of 50000 ist stored correct without . (dot). So is it better to take datatype "numeric" for storing amounts without dots or floating points? (In the textfield I have forbitten to fill in non numeric characters, only numbers allowed) regards Werner -- View this message in context: http://sqlite.1065341.n5.nabble.com/Storing-amount-tp75527p75529.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