<< 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