SQLite does not care about (or enforce) magnitude and precision hints. "numeric" alone is just as good, or even "integer". Textual values that look like numbers will be stored as integer (if they evaluate to a whole number) or real (if not). Increasing a salary of 5000 by 3% will result in a change of the stored type.
-----Ursprüngliche Nachricht----- Von: Werner Kleiner [mailto:sqliteh...@web.de] Gesendet: Donnerstag, 08. Mai 2014 13:42 An: sqlite-users@sqlite.org Betreff: Re: [sqlite] Storing amount? 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 ----------------------------------------------------------------------- Gunter Hick Software Engineer Scientific Games International GmbH Klitschgasse 2 – 4, A - 1130 Vienna, Austria FN 157284 a, HG Wien Tel: +43 1 80100 0 E-Mail: h...@scigames.at This e-mail is confidential and may well also be legally privileged. If you have received it in error, you are on notice as to its status and accordingly please notify us immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any person as to do so could be a breach of confidence. Thank you for your cooperation. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
