Why integer (Number) are saved as Double in MongoDb

Question

I'm working on a new project and I try to figure out why when Mongoose save my model, instead of having an integer, I got a Double.

Ex. {myId: 12345678} become {myId: 12345678.0}

My schema contains this:

{
 myId: {
  type: Number
 }
}

Mongoose version: 5.x Node: 10.x

Any idea ?

JohnnyHK · Accepted Answer · 2018-06-05 13:38:57Z

6

The Number schema type is floating point. If you want to store a number as an integer, you can use the mongoose-int32 plug-in:

var Int32 = require('mongoose-int32');
const schema = new mongoose.Schema({
  myId: {
    type: Int32
  }
});

If you need 64-bit integer support, use the mongoose-long plug-in.

edited Jun 5, 2018 at 13:38

answered Jun 4, 2018 at 15:56

JohnnyHK

313k70 gold badges632 silver badges479 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Ashh Over a year ago

why mongoose itself doesn't give that date type?

JohnnyHK Over a year ago

@Ashish I'm also surprised that data type isn't not part of Mongoose itself. Especially as the author of the plug-in is one of the main Mongoose developers.

Vincent Over a year ago

Thank you for your message. Meanwhile, I used this library: mongoose-long npmjs.com/package/mongoose-long It works great too :)

JohnnyHK Over a year ago

@Vincent Both work for integers; mongoose-long is 64-bit and mongoose-int32 is 32-bit.

Oda Mitsuru Over a year ago

It's so irony that neither mongodb or mongoose provides int type by default

|

Oda Mitsuru · Accepted Answer · 2020-01-20 09:27:29Z

2

Instead of additional npm package overhead, it's recommended to use such getter/setter in the Schema Types.

var numberSchema = new Schema({
  integerOnly: {
    type: Number,
    get: v => Math.round(v),
    set: v => Math.round(v),
    alias: 'i'
  }
});

Therefore, CRUD operations related to field of Number Schema Type will cast to Int32 in Mongodb.

More info can be found in Mongoose v5.8.9 Schema Types documentation

answered Jan 20, 2020 at 9:27

Oda Mitsuru

7341 gold badge6 silver badges5 bronze badges

1 Comment

Balasubramanian S Over a year ago

This solution did not work for me. I don't want to use Plugins either.

Collectives™ on Stack Overflow

Why integer (Number) are saved as Double in MongoDb

2 Answers 2

7 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related