This question 62044887
There is a detailed solution. Here, I'm just documenting the problems I'm having.
This problem is usually encountered when inserting the database into the Address book (the name has everything)
The first of these methods
Database Design table when we generally set varchar is generally UTF8 utf8_general_ci if this state occurs then change to UTF8MB4 utf8m64_general_ci
Of course, this isn't going to work. I've had this problem for the first time, and it's not working. Second method of second modification perfect solution this should be related to the configuration of the database
The second method of
If we touch this 4-byte (usually emoticons) then we can identify it in Java and replace it with a * * or "" This is the copy of the pro-test available
public static string Filteremoji (String source,string slipstr) {
if (Stringutils.isnotblank (source)) {
return Source.replaceall ("[\\ud800\\udc00-\\udbff\\udfff\\ud800-\\udfff]", SLIPSTR);
}else{
return source;
}
}
MySQL can't save 4 bytes of problems (i.e. emoticons)