mysql 表情字符插入异常解决方案

mysql 表情字符插入异常：Incorrect string value: '\xF0\x9F\x90\xB7",...' for column 解决方案对表情字符进行过滤替换，如下

 /**
         * 将emoji表情替换成*
         *
         * @param source
         * @return 过滤后的字符串
         */
        public static String filterEmoji(String source) {
            if(StringUtils.isNotBlank(source)){
                return source.replaceAll("[\\ud800\\udc00-\\udbff\\udfff\\ud800-\\udfff]", "*");
            }else{
                return source;
            }
        }
        public static void main(String[] args){
            try{
                String text = "This is a smiley \uD83C\uDFA6 face\uD860\uDD5D \uD860\uDE07 \uD860\uDEE2 \uD863\uDCCA \uD863\uDCCD \uD863\uDCD2 \uD867\uDD98 ";
                System.out.println(text);
                System.out.println(text.length());
                System.out.println(text.replaceAll("[\\ud83c\\udc00-\\ud83c\\udfff]|[\\ud83d\\udc00-\\ud83d\\udfff]|[\\u2600-\\u27ff]", "*"));
                System.out.println(filterEmoji(text));
            }catch (Exception ex){
                ex.printStackTrace();
            }
        }

##输出结果

This is a smiley 🎦 face𨅝 𨈇 𨋢 𨳊 𨳍 𨳒 𩶘

45

This is a smiley * face𨅝 𨈇 𨋢 𨳊 𨳍 𨳒 𩶘

This is a smiley * face* * * * * * *