微信开发工具显示500

Question

com.hanmeng.o2o.exceptions.WechatAuthOperationException: insertWechatAuth error: insertPersonInfo error:
### Error updating database.  Cause: java.sql.SQLException: Incorrect string value: '\xF0\x9F\x94\x85' for column 'name' at row 1
### The error may involve com.hanmeng.o2o.dao.PersonInfoDao.insertPersonInfo-Inline
### The error occurred while setting parameters
### SQL: INSERT   INTO   tb_person_info(name,gender,email,profile_img,user_type,   create_time,last_edit_time,enable_status)   VALUES   (?,?,?,?,   ?,?,?,?)
### Cause: java.sql.SQLException: Incorrect string value: '\xF0\x9F\x94\x85' for column 'name' at row 1
; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1366]; Incorrect string value: '\xF0\x9F\x94\x85' for column 'name' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xF0\x9F\x94\x85' for column 'name' at row 1
com.hanmeng.o2o.service.impl.WechatAuthServiceImpl.register(WechatAuthServiceImpl.java:69)
sun.reflect.GeneratedMethodAccessor716.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:498)

Answer 1

hthonor 2020-09-01 21:41:05

我把昵称中的表情删掉就ok了，数据库的编码不支持表情

Answer 2

翔仔 2020-05-08 01:41:31

同学好，感觉是编码问题？打印一下当时的name看看 就是用户名，需要对比一下编码

• hthonor #1

  我也遇到这个问题，怎么解决呢

• hthonor #2

  打印出日志，name显示正常