mysql text 插入插入数据超长报错 偶然会出现 too long ,实际问题内容长度不够

{"msg":"\n### Error updating database. 
 Cause: java.sql.SQLException: Incorrect string value: '\\xE5\\xB0\\x91\\xE7\\x97\\x87...' for column 'info' at row 1\n### The error may involve com..Mapper.insert Info-Inline\n### 
The error occurred while setting parameters\n### SQL: insert into n \n### 
Cause: java.sql.SQLException: Incorrect string value: '\\xE5\\xB0\\x91\\xE7\\x97\\x87...'
for column 'info' at row 1
\n; uncategorized SQLException; SQL state [HY000]; error code [1366]; Incorrect string value: '\\xE5\\xB0\\x91\\xE7\\x97\\x87...' for column 'info' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\\xE5\\xB0\\x91\\xE7\\x97\\x87...' for column 'info' at row 1","code":500}

一位同事在富文本中插入了一段内容报错,检查了各种转码未找到问题,删除部分数据一直跟踪发现是数据长度不够导致,调整text > 之后可正常保存,但报错提示为编码问题,这里记下来....

同时记录 转码工具类 StringEscapeUtils的使用 

https://www.cnblogs.com/baby123/p/11462889.html