记录Invalid utf8 character string报错

### Error updating database.Cause: java.sql.SQLException: Invalid utf8 character string: '1\xEF'### The error may involve defaultParameterMap### The error occurred while setting parameters### SQL: INS

GOGxz

4401人浏览 · 2021-12-20 16:11:22

GOGxz · 2021-12-20 16:11:22 发布

### Error updating database.  Cause: java.sql.SQLException: Invalid utf8 character string: '1\xEF'
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: INSERT INTO p_userinfo (regid,user_name,sex,company_id,query_company_id)         VALUES (?,?,?,?，?);
### Cause: java.sql.SQLException: Invalid utf8 character string: '1\xEF'
; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1300]; Invalid utf8 character string: '1\xEF'; nested exception is java.sql.SQLException: Invalid utf8 character string: '1\xEF'

原因是xml里的SQL语句里有中文逗号！！

大家sql的时候一定要注意中英文标点符号问题！！