Title: Ask Reuben 168 - Big Numbers Post by: Reuben B. on March 31, 2023, 12:05:27 am The Genero documentation gives the biggest number for various integer datatypes. For BIGINT this is 9,223,372,036,854,775,807 or 2^63 -1.
Recently had an interesting case where a very big BIGINT was not parsing to JSON correctly. When we investigated it, the JSON definition of a number uses the IEEE 754 double-precision floating point format which can only represent integers precisely up to 2^53 Read more at https://4js.com/ask-reuben/ig-168/ |