Mysql uses the bigint field to store the 10-digit mobile phone number, which is truncated. How can I store a mobile phone number in the BIGINT field every time. No matter what the 11-digit number is, only 4294967295 will be displayed. ------ solution ------------------ echopow ); 4294967296 that's because you didn't process the mobile phone number as a string in php ------ mysql used the bigint field to store the 10-digit mobile phone number, and it was truncated.
How can I store a mobile phone number in the BIGINT field every time. No matter what the 11-digit number is, only 4294967295 is displayed.
------ Solution --------------------
Echo pow (2, 32); // 4294967296
That's because you didn't process the mobile phone number as a string in php.
------ Solution --------------------
The integer type of PHP does not support 11-bit decimal numbers (32-bit operating systems ).
The integer that exceeds the range is converted to a floating point number by PHP ".
The problem you encounter may be that you have used a database interface program to handle this situation. In short, if you can see the final execution of the insert into... statement, it will be clear.
--------------------------------
Based on the plug-in extension function provided by the CSDN forum, I have made a signing tool and shared it with you. we welcome Technical Exchange :)