What to do when you need integers larger than 20 digits on mysql?

by

Big integers aren’t actually limited to 20 digits, they’re limited to the numbers that can be expressed in 64 bits (for example, the number 99,999,999,999,999,999,999 is not a valid big integer despite it being 20 digits long).

The reason you have this limitation is that native format integers can be manipulated relatively fast by the underlying hardware whereas textual versions of a number (tend to) need to be processed one digit at a time.

If you want a number larger than the largest 64-bit unsigned integer 18,446,744,073,709,551,615 then you will need to store it as a varchar (or other textual field) and hope that you don’t need to do much mathematical manipulation on it.

Alternatively, you can look into floating point numbers which have a larger range but less precision, or decimal numbers which should be able to give you 65 digits for an integral value, with decimal(65,0) as the column type.

More Related Contents:

  1. MySQL Error #1071 – Specified key was too long; max key length is 767 bytes
  2. MySQL: Large VARCHAR vs. TEXT?
  3. What is the size of column of int(11) in mysql in bytes?
  4. What is the MySQL VARCHAR max size?
  5. Equivalent of varchar(max) in MySQL?
  6. Difference between VARCHAR and TEXT in MySQL [duplicate]
  7. MySQL VARCHAR Lengths and UTF-8
  8. MySQL varchar index length
  9. MySQL too long varchar truncation/error setting
  10. SQL unique varchar case sensitivity question
  11. MySQL INT meaning
  12. What are the optimum varchar sizes for MySQL?
  13. What is the MAX number if I store int(255) in MySQL?
  14. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  15. Comparison of full text search engine – Lucene, Sphinx, Postgresql, MySQL? [closed]
  16. MySQL Error 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes
  17. a count for each join – optimisation
  18. How to grant all privileges to root user in MySQL 8.0
  19. MySQL Group by SUM
  20. Search for all occurrences of a string in a mysql database [duplicate]
  21. MySQL Aggregate Functions without GROUP BY clause
  22. Count days between two dates, excluding weekends (MySQL only)
  23. Difference in minutes from two time fields in MySQL
  24. Is there a way to “limit” the result with ELOQUENT ORM of Laravel?
  25. NodeJS responded MySQL timezone is different when I fetch directly from MySQL
  26. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ [duplicate]
  27. How to swap values of two rows in MySQL without violating unique constraint?
  28. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  29. Storing images in MySQL [closed]
  30. Would it help to add index to BIGINT column in MySQL?

Leave a Comment