Data truncation: Incorrect string value: '\xE5\xB9\xB43\xE6\x9C...' for column 'reg_time' at row 1_com.mysql.jdbc.mysqldatatruncation: data truncatio-优快云博客

在使用SpringDataJPA过程中遇到MysqlDataTruncation异常，由于字符串值超出字段长度限制，通过更改数据库表编码格式为utf-8成功解决乱码及数据截断问题。

Caused by: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Incorrect string value: ‘\xE5\xB9\xB43\xE6\x9C…’ for column ‘reg_time’ at row 1 at
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:104) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:974) at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1113) at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1061) at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1381) at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1046) at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61) at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:175) … 64 more

在做Spring Data JPA练习时，我猜测是因为乱码之后的字符串值超出了，字段名定义的长度，后将数据库表的编码格式改为utf-8解决问题。