PHP Import EXCEL data Encoding problem BUG?

there are several data mobile phone numbers are UTF-8 codes
clipboard.png
the following 15989380761 is 11 digits, but the detection length is 17 digits. I looped through each bit of the string, and there are 3 invisible symbols before and after each bit, which is directly converted into an integer type and stored in the database. It appears to be 11 digits on the surface, but it cannot be found with sql, and there is no direct screening with navicat, but it is in the table. I don"t know why. It is suspected that there is something before and after the import of the excel watch, but there is nothing on the surface. Please know.

Php
Mar.05,2021

invited the big god, do not mind


obviously these are invisible characters, the easiest way, do a type judgment or directly use regular substitution, replace non-d with empty

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-1b380ea-2c0f0.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-1b380ea-2c0f0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?