Incorrect string value: '\xF0\x9F\xA4\x97 3...' for column 'nick_name' at row 1

悠悠 2022-02-20 04:49 222阅读 0赞

#### 今日遇到一个棘手的问题，不知道怎么办好，最后决定过滤调emoji不要了，只留下字符串，工具类是他人的，文章结尾有原文地址 ####

#### 1. 异常信息 ： ####

#### 2、异常原因： ####

微信昵称含有特殊字符  mysql数据库 存不了

#### 3、修改后: ####

解释：[https://blog.csdn.net/u012613902/article/details/78716972][https_blog.csdn.net_u012613902_article_details_78716972]

package cn.buildoncloud.mipro.video.common;
    
    /** * 过滤emoji表情与非emoji表情 * @author * */
    
    public class EmojiFilter { 
    /** * 检测是否有emoji字符 * @param source 需要判断的字符串 * @return 一旦含有就抛出 */
        public  static boolean containsEmoji(String source) { 
            int len = source.length();
            for (int i = 0; i < len; i++) { 
                char codePoint = source.charAt(i);
                if (!notisEmojiCharacter(codePoint)) { 
                //判断确认有表情字符
                return true;
                }
            }
            return false;
        }
        /** * 非emoji表情字符判断 * @param codePoint * @return */
        private  static boolean notisEmojiCharacter(char codePoint) { 
            return (codePoint == 0x0) || 
                    (codePoint == 0x9) ||                            
                    (codePoint == 0xA) ||
                    (codePoint == 0xD) ||
                    ((codePoint >= 0x20) && (codePoint <= 0xD7FF)) ||
                    ((codePoint >= 0xE000) && (codePoint <= 0xFFFD)) ||
                    ((codePoint >= 0x10000) && (codePoint <= 0x10FFFF));
        }
        
        /** * 过滤emoji 或者 其他非文字类型的字符 * @param source 需要过滤的字符串 * @return */
        public  static  String filterEmoji(String source) { 
            if (!containsEmoji(source)) { 
                return source;//如果不包含，直接返回
            }
            
            StringBuilder buf = null;//该buf保存非emoji的字符
            int len = source.length();
            for (int i = 0; i < len; i++) { 
                char codePoint = source.charAt(i);
                if (notisEmojiCharacter(codePoint)) { 
                    if (buf == null) { 
                        buf = new StringBuilder(source.length());
                    }
                    buf.append(codePoint);
                } 
            }
            
            if (buf == null) {          
                return "";//如果没有找到非emoji的字符，则返回无内容的字符串
            } else { 
                if (buf.length() == len) { 
                    buf = null;
                    return source;
                } else { 
                    return buf.toString();
                }
            }
        }
    
    }

#### 特别鸣谢： ####

工具类来源： [https://blog.csdn.net/gc1329689056/article/details/80842683][https_blog.csdn.net_gc1329689056_article_details_80842683]

[https_blog.csdn.net_u012613902_article_details_78716972]: https://blog.csdn.net/u012613902/article/details/78716972
[https_blog.csdn.net_gc1329689056_article_details_80842683]: https://blog.csdn.net/gc1329689056/article/details/80842683