Emoji emoji not supported by Java processing database

The general database encoding is UTF8,UTF8 does not support the storage of emoticons, when the nickname with the expression will appear garbled, there are two ways to solve:

1.mysql database upgrade to more than 5.5 version, UTF8 to UTF8MB4,UTF8MB4 characters can be up to 4 bytes, can store emoticons, restart the database server, this method may be invalidated;

2. Filter out emoji in Java code, simple and efficient, below is the tool class that filters out emoticons:

ImportJava.util.regex.Matcher;ImportJava.util.regex.Pattern; Public classEmojiutil { Public Staticstring Replace (string input) {if(!stringutil.isempty (input)) {String Patternstr= "[^\\u0000-\\uffff]"; Pattern Pattern= Pattern.compile (patternstr, Pattern.unicode_case |pattern.case_insensitive); Matcher Matcher=pattern.matcher (input); Input= Matcher.replaceall (""); }        returninput; }}

Emoji emoji not supported by Java processing database