This is a creation in Article, where the information may have evolved or changed.
Incorrect string value: ' \xef\xbf\xbd\xef\xbf\xbd ... '
Report this error, basically is the coding problem, check the table code
Show CREATE TABLE table_name;
For example, the problem is the character set
| gosignal | CREATE TABLE ' gosignal ' (
' id ' int (one) DEFAULT NULL,
' Time ' varchar (+) DEFAULT NULL,
' IMSI ' varchar DEFAULT NULL,
' IMEI ' varchar (+) DEFAULT NULL,
' Duration ' int (one) DEFAULT NULL,
' Startlac ' varchar DEFAULT NULL,
' STARTCI ' varchar DEFAULT NULL,
' Endlac ' varchar DEFAULT NULL,
' ENDCI ' varchar DEFAULT NULL,
' Cause ' varchar (5) DEFAULT NULL,
' Fromnum ' varchar (+) DEFAULT NULL,
' Tonum ' varchar (+) DEFAULT NULL,
' STARTLNG ' double DEFAULT NULL,
' Startlat ' double DEFAULT NULL,
' ENDLNG ' double DEFAULT NULL,
' Endlat ' double DEFAULT NULL
) Engine=innodb DEFAULT charset=latin1 |
Modify method
ALTER TABLE gosignal convert to character set UTF8;