MongoDB – What about Decimal type of value?

by

If you want an exact representation for financial purposes, then doubles or floating point values are unsuitable as the fractional parts are subject to rounding error. Certain decimal values cannot not be represented using binary-based floating points and must be approximated.

For a less technical intro, see The trouble with rounding floating point numbers; if you want to geek out, then read What Every Computer Scientist Should Know About Floating-Point Arithmetic.

The recommendation of using an integer type (storing the value in cents) is to avoid potential rounding errors. This approach is described as “Using a Scale Factor” in the MongoDB documentation for modelling monetary data and is a general workaround for MongoDB 3.2 and earlier.

MongoDB 3.4 includes a new Decimal BSON type which provides exact precision for manipulating monetary data fields.

More Related Contents:

  1. How to query nested objects?
  2. Understanding MongoDB BSON Document size limit
  3. How to ignore nulls while unmarshalling a MongoDB document?
  4. MongoDB Single Document size limit is 16MB
  5. MongoDB first time user setup [closed]
  6. How to execute mongo commands through shell scripts?
  7. pushing object into array schema in Mongoose
  8. Performing regex queries with PyMongo
  9. Check if every element in array matches condition
  10. What is the default database path for MongoDB?
  11. Updating nested arrays in mongoDB via mongo shell [duplicate]
  12. How can I get a random record from MongoDB?
  13. How do I convert a property in MongoDB from text to date type?
  14. Merging two collections in MongoDB
  15. MongoDB can’t find data directory after upgrading to Mac OS 10.15 (Catalina)
  16. Matching ObjectId to String for $graphLookup
  17. How to work around the lack of transactions in MongoDB?
  18. MongoDB-CR Authentication failed
  19. Mongodb aggregation lookup with conditions
  20. Create an ISODate with pyMongo
  21. E: Unable to locate package mongodb-org
  22. Collision probability of ObjectId vs UUID in a large distributed system
  23. $skip and $limit in aggregation framework
  24. Read-only file system when attempting mkdir /data/db on Mac [closed]
  25. How does the order of compound indexes matter in MongoDB performance-wise?
  26. Mongodb Aggregation Framework | Group over multiple values?
  27. How does MongoDB order their docs in one collection? [duplicate]
  28. How to stop mongo DB in one command
  29. MongoDB: how to count number of keys in a document?
  30. Query for a field in an object in array with Mongo?

Leave a Comment