On 8 May 2014, at 12:13pm, Kleiner Werner <[email protected]> wrote:
> 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
Which way of accessing SQLite are you using ? The PDO library or the sqlite3
one ?
How is the column defined in the table definition ? What type is it given ?
If you do
SELECT thisCol,typeof(thisCol) FROM myTable
what type is shown for that value ?
Simon.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
