@Simon <<Declare it as REAL.
I tried this, but Inserting 1.700 is also stored as 1.7 With TEXT I can store it like 1.700 but we want to calculate later with PHP or C# 2016-11-30 16:39 GMT+01:00 Werner Kleiner <sqlitetes...@gmail.com>: > << All you need to store in the database table is the number. How it is > formatted for viewing or printing is controlled by the user interface. > > yes thats right, but it would be nice to have same behavior between > MySQL and sqlite > I think to use a char datatype is not a good solution. > > 2016-11-30 16:27 GMT+01:00 Rich Shepard <rshep...@appl-ecosys.com>: >> On Wed, 30 Nov 2016, Igor Tandetnik wrote: >> >>> Store it as an integer, in $.0001 units. So $1.500 would be represented >>> simply as an integer 1500. >> >> >> All you need to store in the database table is the number. How it is >> formatted for viewing or printing is controlled by the user interface. >> >> Rich >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users