Emoji 中关于MySQL 无法插入的问题解决

JAVA代码

----------------------------------------------------------------------------------------------------------------------------------

package com.einwin.draw;

/**
 * Created by WSQ on 2017/7/6.
 */

public class Utils {
    /**
     * unicod转字符串
     *
     * @param unicode
     * @return
     */
    public static String unicode2String(String unicode) {

        StringBuffer string = new StringBuffer();

        String[] hex = unicode.split("\\\\u");

        for (int i = 1; i < hex.length; i++) {
            if (hex[i].length() > 4) {
                String substring1 = hex[i].substring(0, 4);
                String substring2 = hex[i].substring(4, hex[i].length());

                if (substring1.equals("20")) {
                    string.append(" ");
                } else {
                    // 转换出每一个代码点
                    int data = Integer.parseInt(substring1, 16);
                    // 追加成string
                    string.append((char) data);
                }

                string.append(substring2);
            } else {

                if (hex[i].equals("20")) {
                    string.append(" ");
                } else {
                    // 转换出每一个代码点
                    int data = Integer.parseInt(hex[i], 16);
                    // 追加成string
                    string.append((char) data);
                }
            }

        }
        return string.toString();
    }

    /**
     * 字符串转 Unicode
     *
     * @param string
     * @return
     */
    public static String string2Unicode(String string) {

        StringBuffer unicode = new StringBuffer();

        for (int i = 0; i < string.length(); i++) {

            // 取出每一个字符
            char c = string.charAt(i);

            if (c >= 0 && c <= 255) {

                unicode.append(c);
            } else {
                // 转换为unicode
                unicode.append("\\u" + Integer.toHexString(c));
            }
        }

        return unicode.toString();
    }
}

----------------------------------------------------------------------------------------------------------------------------------

OC代码

----------------------------------------------------------------------------------------------------------------------------------

    //未编码
    NSLog(@"------------------------------------------------");
    NSLog(@"未编码");
    NSLog(@"%@", textFieldText );
    //编码
    NSString *uniStr = [NSString stringWithUTF8String:[textFieldText UTF8String]];
    NSData *uniData = [uniStr dataUsingEncoding:NSNonLossyASCIIStringEncoding];
    NSString *requestText = [[NSString alloc] initWithData:uniData encoding:NSUTF8StringEncoding] ;
    NSLog(@"------------------------------------------------");
    NSLog(@"已编码");
    NSLog(@"%@", requestText );

               NSLog(@"------------------------------------------------");
               NSLog(@"未解码");
               NSLog(@"%@", mutableString );
               
               NSString *goodStr = [mutableString copy];
               const char *jsonString = [goodStr UTF8String];   // goodStr 服务器返回的 json
               NSData *jsonData = [NSData dataWithBytes:jsonString length:strlen(jsonString)];
               NSString *showText = [[NSString alloc] initWithData:jsonData encoding:NSNonLossyASCIIStringEncoding];
               
               self.labelForText.text = showText;
               
               NSLog(@"------------------------------------------------");
               NSLog(@"已编码");
               NSLog(@"%@", showText );

----------------------------------------------------------------------------------------------------------------------------------