MySQL can't save 4 bytes of problems (i.e. emoticons)

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)