Mysql uses the bigint field to store the 10-digit mobile phone number, which is truncated. What should I do?

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 and echopow (4294967296) are displayed; // is because you didn't treat the mobile phone number as a string in php, PH mysql used the bigint field to store the 10-digit mobile phone number, which 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 :)