<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[g960806的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/g960806</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; g960806]]></copyright><item><title><![CDATA[mysql解决存储微信表情emoji保存失败问题]]></title><link>https://blog.youkuaiyun.com/g960806/article/details/106622362</link><guid>https://blog.youkuaiyun.com/g960806/article/details/106622362</guid><author>g960806</author><pubDate>Mon, 08 Jun 2020 16:21:13 +0800</pubDate><description><![CDATA[问题分析

微信开发中带有emoji表情昵称的微信用户无法自动登录的问题

异常信息：


Incorrect string value: '\xF0\x9F\x8D\x80' for column 'nickname' at row 1;


原因： emoji表情是用4个字节编码，mysql默认是默认varchar字段属于utf-8只能用存进3个字节编码的字符串内容



一：mysql版本5.7以下

1.1：使用base64转码后存入数据库，

1.2：过滤emoji表情(可能有些表情无法过滤...]]></description><category></category></item><item><title><![CDATA[spring boot Unable to find a @SpringBootConfiguration, you need to use @ContextConfiguration]]></title><link>https://blog.youkuaiyun.com/g960806/article/details/78443691</link><guid>https://blog.youkuaiyun.com/g960806/article/details/78443691</guid><author>g960806</author><pubDate>Sat, 04 Nov 2017 15:13:24 +0800</pubDate><description><![CDATA[java.lang.IllegalStateException: Unable to find a @SpringBootConfiguration, you need to use @ContextConfiguration or @SpringBootTest(classes=...) with your test
	at org.springframework.util.Assert.state(Assert.java:70)
	at org.springframework.boot.test.con]]></description><category></category></item></channel></rss>