@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 <[email protected]>: > << 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 <[email protected]>: >> 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 >> [email protected] >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
