There is a difference in the value of number conversion between long in java and number in database.

1. The number of bank card digits entered by the user on the page is relatively long, so the server is loaded with long type.
when saved in the oracle database, the viewing data becomes a scientific notation tag. (it is said on the Internet that the length of the number field of an unspecified oracle will scientifically count more than 8 or 9 digits.) Then comes the problem.
when the fields in the library are taken out and displayed at the front end, it is found that the last four digits have become 0, and some have added 10000 at last.

example:
original value 123457689098221781
stored in the library is scientific notation
again, it becomes 123457689098220000 or 1234576890982210000
(oddly enough, when excel is exported, the card numbers in the file are all correct.)

talents are sparse and learning is shallow. Please take a look at

Mar.28,2021

finds the problem, and each programming language has a specified word length. Values with jsdouble type words longer than 15 digits are not displayed as zeroing.

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e5a08e-5a5c9.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e5a08e-5a5c9.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?