Does MongoDB support floating point types?

by

MongoDB stores data in a binary format called BSON which supports these numeric data types:

  • int32 – 4 bytes (32-bit signed integer)
  • int64 – 8 bytes (64-bit signed integer)
  • double – 8 bytes (64-bit IEEE 754 floating point)

There’s no exact value fixed-point equivalent to mySQL’s decimal type in MongoDB, but you can store 64-bit floating point numbers in Mongo as a double.

It’s worth mentioning that the MongoDB shell – being a JavaScript shell – doesn’t recognise the distinction between integer and floating-point values, it treats all numbers the same because JavaScript represents all numbers as 64-bit floating point, regardless of their underlying BSON type.

Most MongoDB language drivers, however, make the distinction between integer and floating point types.

More Related Contents:

  1. Possibility of duplicate Mongo ObjectId’s being generated in two different collections?
  2. Where does mongodb stand in the CAP theorem?
  3. How do you query for “is not null” in Mongo?
  4. How to stop insertion of Duplicate documents in a mongodb collection
  5. Is mongodb running?
  6. MongoDB normalization, foreign key and joining
  7. Get a document in MongoDB without specifying collection
  8. Update field in exact element array in MongoDB
  9. MongoDB: How to update multiple documents with a single command?
  10. How to remove a field completely from a MongoDB document?
  11. Store images in a MongoDB database
  12. Add new field to every document in a MongoDB collection
  13. Querying internal array size in MongoDB
  14. How can I run MongoDB as a Windows service?
  15. MongoDB vs. Cassandra [closed]
  16. Find duplicate records in MongoDB
  17. Best practice to maintain a mgo session
  18. How do you rename a MongoDB database?
  19. How do I do a “NOT IN” query in Mongo?
  20. How to enforce foreign keys in NoSql databases (MongoDB)?
  21. NoSQL (MongoDB) vs Lucene (or Solr) as your database [closed]
  22. MongoDB update with condition
  23. MongoDB lookup when foreign field is an array of objects
  24. Mongodb: Failed to connect to 127.0.0.1:27017, reason: errno:10061
  25. MongoDB nested array query
  26. Filtering embedded documents in MongoDB
  27. Mongodb aggregation $group, restrict length of array
  28. MongoDB/NoSQL: Keeping Document Change History
  29. MongoDB Single Document size limit is 16MB
  30. Unique IDs with mongodb

Leave a Comment