On 8 May 2014, at 12:13pm, Kleiner Werner <sqliteh...@web.de> 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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
