Incorrect string value: '\xAC\xED\x00\x05sr...' for column
Posted by:
Karen Goh
Date: December 13, 2018 01:38AM
I got this error which I need help to resovle.
java.sql.SQLException: Incorrect string value: '\xAC\xED\x00\x05sr...' for column 'subjectName' at row 1
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:975)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1114)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1062)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1383)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1047)
I have also checked the problem column Name : subjectName is in utf8mb4
What I have attempted so far:
-----------------------------
I have added my.cnf
[mysqld]
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
And re-start server but to no avail.
I am using MYSQL 8.0.12 in Windows 10, running a Maven web App in Java EE with CDI.
Eclipse Oxygen.
Please help.
Subject
Written By
Posted
Incorrect string value: '\xAC\xED\x00\x05sr...' for column
December 13, 2018 01:38AM
December 13, 2018 06:25AM
December 13, 2018 09:42AM
December 13, 2018 11:18AM
December 15, 2018 03:10AM
December 27, 2018 07:33AM
December 29, 2018 04:43AM
December 30, 2018 03:40AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.