How to handle very big numbers in node js?

Question

I am using BigInt(20) datatype for auto Increment id in mysql database. and when the integer value is so big then how can I handle this as after the number precision of javascript, it won't to allow to insert and read any number Value. So how can I achieve this. Read about the big-integer libraries but I won't the expected result

Example:-

var x = 999999999999999999999999999999999999999;

How can I print the same number without using its exponential value and any garbage value ?

I tried like that

var BigNumber = require('big-number');

var x = new BigNumber(999999999999999999999999999999999999999, 10);
console.log(x);

Example2:-

If I get the last inserted Id, then how can I handle this value

 connection_db.query('INSERT INTO tableName SET ?', tableData, 
  function (error1, results1, fields1) {
     error1){
         // Db error
        }else{
         var lastInserted = new BigNumber(results1.insertId);
         console.log(lastInserted);// still wrong value
          }

  });

Don't think BIGINT(20) generates a int with 20 digits.. the (20) only apply to zerofull function of mysql... the minimal and maximal values off BIGINT are here dev.mysql.com/doc/refman/5.5/en/integer-types.html.. — Raymond Nijland
– Raymond Nijland, Commented Sep 26, 2017 at 13:55
@robertklep provides a good answer. I want to add another thought. Depending on your concrete environment, JavaScript gives you "safe integers" up to 2^53 - 1. MySQL's BIGINT is (depending on your installation) a 64 bit value. So, if 2^53 - 1 (= 9007199254740991) is enough for your needs, you might use this combination anyway (taking care of your bounds, of course). — iquellis
– iquellis, Commented Sep 26, 2017 at 14:10

robertklep · Accepted Answer · 2017-09-28 06:34:01Z

3

You can only pass/show large numbers like that as strings:

var BigNumber = require('big-number');

var x = new BigNumber('999999999999999999999999999999999999999', 10);
console.log(x.toString())

However, in the end, it's up to the MySQL driver how it handles large numbers like this, because it does have to take into account Number.MAX_SAFE_INTEGER.

For instance, the mysql module has various options (supportBigNumbers and bigNumberStrings) that relate to handling BIGINT.

edited Sep 28, 2017 at 6:34

answered Sep 26, 2017 at 13:55

robertklep

205k38 gold badges421 silver badges413 bronze badges

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

5 Comments

O. Jones Over a year ago

It's worth clarifying: If your application requires integer values with more than 14 or 15 digits, you're in for a world of pain if you try to program the application in Javascript. If you can, avoid it.

VIKAS KOHLI Over a year ago

@robertklep How can I even perform like this becoze some is sending the data as very big number so how can I pass this as a sttring

robertklep Over a year ago

@VIKASKOHLI see my edit. You probably have to specifically enable BIGINT support in the MySQL driver.

VIKAS KOHLI Over a year ago

@robertklep So I have to change the sql package for supportig the very big numbers

robertklep Over a year ago

@VIKASKOHLI no, you have to set the correct option. It already supports big numbers, but that support is disabled by default. Please read the documentation.

Collectives™ on Stack Overflow

How to handle very big numbers in node js?

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related