mysql5.7之后开始支持json数据格式类型保存数据的时候报如下错误


org.nutz.dao.DaoException: !Nutz SQL Error: 'UPDATE mumshop_product SET pid=576898202150,name='CW-0114-DAMAOXIAN',url='https://detail.1688.com/offer/576898202150.html',shop_url='https://shop1470675225377.1688.com',price=38000.0,original_price=50000.0,images='["https://rk-cdn.oss-cn-hongkong.aliyuncs.com/cache/upload/2020/0114/20200114162035.jpg"]',time='2020-01-15 05:27:38',type='YDUCKMM',category=204,is_pushed=true,is_translated=false,props='["颜色"]',status=1,is_deleted=false,push_time='2020-01-15 05:27:38',provider_id=922,size_status=0,image_index=0,sort=1000000  WHERE id='7213524845999423488''
PreparedStatement: 
'UPDATE mumshop_product SET pid=?,name=?,url=?,shop_url=?,price=?,original_price=?,images=?,time=?,type=?,category=?,is_pushed=?,is_translated=?,props=?,status=?,is_deleted=?,push_time=?,provider_id=?,size_status=?,image_index=?,sort=?  WHERE id=?'
CaseMessage=Data truncation: Cannot create a JSON value from a string with CHARACTER SET 'binary'.
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:110)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:65)
	at org.nutz.dao.impl.interceptor.DaoTimeInterceptor.filter(DaoTimeInterceptor.java:23)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:63)
	at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:63)
	at org.nutz.plugins.cache.dao.DaoCacheInterceptor._exec(DaoCacheInterceptor.java:28)
	at org.nutz.plugins.cache.dao.CachedNutDaoExecutor.exec(CachedNutDaoExecutor.java:188)
	at org.nutz.plugins.cache.dao.DaoCacheInterceptor.filter(DaoCacheInterceptor.java:18)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:63)
	at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:138)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:163)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:130)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:97)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:86)
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:242)
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:254)
	at org.nutz.dao.impl.EntityOperator.exec(EntityOperator.java:58)
	at org.nutz.dao.impl.NutDao.update(NutDao.java:275)
	at com.kunnit.cloud.web.module.ApiModule.t(ApiModule.java:345)
这个问题有解决办法么?
请先登陆