注意点

• 数据库字符集 设置为utf8mb4

• 表编字符集 设置为utf8mb4

• 字段字符集 设置为utf8mb4

• 执行insert into 前 执行SET NAMES utf8mb4

UserDO userDO = new UserDO();
        userDO.setOpenid("33333");
        userDO.setName("\uD83D\uDE40\uD83D\uDE40\uD83D\uDE40");
        userService.setUTF();
        userService.save(userDO);

#xml
<update id="setUTF">SET NAMES utf8mb4</update>

    <insert id="save" parameterType="com.yikang.UserDO">
        insert into qa_user
        (
                                `id`,             
                                `created`,             
                                `modified`,             
                                `del_flag`,             
                                `openid`,             
                                `name`,             
                                `sex`,             
                                `phone`,             
                                `head_url`,             
                                `account`,             
                                `password`            
        )
        values
        (
                                #{id},             
                                #{created},             
                                #{modified},             
                                #{delFlag},             
                                #{openid},             
                                #{name},             
                                #{sex},             
                                #{phone},             
                                #{headUrl},             
                                #{account},             
                                #{password}            
        )
    </insert>