Hello,
a PHP script stores an amount into a SQLite table column "salary" which is 
defined as float(10,0)
I a user fill in 50000 into a textfield, this value is stored as 5000.0
 
Why this? why not 50000 ?
 
If I do the same in MySQL, where the column is defined as decimal(10,0) it is 
stored correct as 50000.
 
PS: I did the convertion from mysql to sqlite with a converter tool which 
converts the MySQL decimal(10,0) to SQLite float(10,0) automatically.
 
Is this the wrong datatype in SQLite for storing amounts?
 
best regards
Werner
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to