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