How to convert negative int32 to int64 in nodejs?

Question

Node.js

There is a server on Nodejs, through it I connect to the Mysql database, in the database there is one table Items (id, id2);
id is an int;
id2 is bigint;
when receiving a record, it displays -1556717912 for me, and in the base 2738249384.

Answer 1

since the node does not support 64 bits of the number, then when stored in int32, part of the number is lost. converting is useless.
in your case as a temporary solution.
2^32 - 1556717912 = 2738249384
(2^32 = 4294967296)
but as soon as the id exceeds 2^32, it won't help.
if you need more, then you need to rewrite the module that you use to communicate with mysql. so that it returns them as a floating point number, where the least significant bits, as far as I know, disappear starting from 2 ^ 53, this should be enough.

Answer 2

nodejs int64