Hacker News new | ask | show | jobs
by marton78 2308 days ago
I don't know how it's done in the US, but in Europe financial calculations are done with four digits after the dot.
1 comments

So store the value as milli-cents? (haha)
Shouldn't that be centi-cents? ^^
Or in MySQL: innocents.
More likely: varchar(255)
varchar(255) == varchar(2000000) in SQLite

The type system in SQLite is not as strict as it is in other RDBMS.