On 2016-11-30 16:39, Werner Kleiner wrote:
<< 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.
No using a char datatype is not a solution AS it is not a solution for
SQLite to implement everything in a way that's compatible with database
X.
You were given a good recommendation save everything in "cents". Which
might also be a good solution depending on the underlying language you
use. as you can't store money in a float!
BR,
Miha
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
