最近做做移動(dòng)端開發(fā)泵琳，用戶輸入Emoji表情時(shí)，
SQLException: Incorrect string value: '\xF0\x9F\x98\x84' for column 'review' at row 1

遵照以前的解決方案嫡锌，把emoji表情的字符串過(guò)濾掉，然后存到數(shù)據(jù)庫(kù)中琳钉；

根據(jù)字符編碼來(lái)排除Emoji表情势木；
暫時(shí)不曉得js如何過(guò)濾掉Emoji表情，當(dāng)然也是通過(guò)編碼的方式吧歌懒！

寫上java代碼吧＠沧馈！

package com.migoedu.mobile.common.Emoji;

import org.apache.commons.lang3.StringUtils;

/**
 * Created by XXX on 2015/9/7.
 */
public class EmojiFilter {
    /**
     * 檢測(cè)是否有emoji字符
     * @param source
     * @return 一旦含有就拋出
     */
    public static boolean containsWord(String source) {
        System.out.println(StringUtils.isBlank(source));
        if (StringUtils.isBlank(source)) {
            return false;
        }

        int len = source.length();
        System.out.println(len);
        for (int i = 0; i < len; i++) {
            char codePoint = source.charAt(i);

            if (isNotEmojiCharacter(codePoint)) {
                return true;
            }
        }

        return false;
    }


    private static boolean isNotEmojiCharacter(char codePoint) {
        return (codePoint == 0x0) ||
                (codePoint == 0x9) ||
                (codePoint == 0xA) ||
                (codePoint == 0xD) ||
                ((codePoint >= 0x20) && (codePoint <= 0xD7FF)) ||
                ((codePoint >= 0xE000) && (codePoint <= 0xFFFD)) ||
                ((codePoint >= 0x10000) && (codePoint <= 0x10FFFF));
    }

    /**
     * 過(guò)濾emoji 或者 其他非文字類型的字符
     * @param source
     * @return
     */
    public static String filterEmoji(String source) {

        if (!containsWord(source)) {
            System.out.println("filterEmoji 不包含文字說(shuō)明只有表情及皂。");
            return "";//如果不包含甫男，直接返回
        }
        //到這里鐵定包含
        StringBuilder buf = null;

        int len = source.length();

        for (int i = 0; i < len; i++) {
            char codePoint = source.charAt(i);

            if (isNotEmojiCharacter(codePoint)) {
                if (buf == null) {
                    buf = new StringBuilder(source.length());
                }
                buf.append(codePoint);
            } else {
            }
        }

        if (buf == null) {
            return "";//如果沒有可能到這步吧！
        } else {
            if (buf.length() == len) {//這里的意義在于盡可能少的toString验烧，因?yàn)闀?huì)重新生成字符串
                return source;
            } else {
                return buf.toString();
            }
        }

    }
}