MySql UTF encoding

Question

 java.sql.SQLException: Incorrect string value: '\xAC\xED\x00\x05sr...' for column 'xxxx'

The column is a longtext in MYSQL with utf8 charset and utf8_general_ci collation.

What is wrong?

I'm reading the bytes from a server using utf-8(or ISO8859-1, or whatever), then create a StringBuffer, then pass it to hibernate, it then save it — user121196
– user121196, Commented Apr 21, 2010 at 23:44
Can you add some debug to show the contents of the StringBuffer before you send it to the database, and then post that here? — Mark Byers
– Mark Byers, Commented Apr 22, 2010 at 17:13

Jakub Bochenski · Accepted Answer · 2014-04-11 16:43:20Z

8

It's a bit late, but you might want to know that \xAC\xED\x00\x05sr... is a magic number for Java serialization. Apparently your parameter is being serialized instead of being pasted as a string.

answered Apr 11, 2014 at 16:43

Jakub Bochenski

3,3134 gold badges39 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ben3000 Over a year ago

Yep, that was my problem. I was trying to insert an ArrayList as-is into a MySQL VARCHAR.

Mark Byers · Accepted Answer · 2010-04-21 23:11:08Z

2

Assuming that those are hexadecimal escape codes, the text \xAC\xED\x00\x05sr... is not a valid UTF-8 string.

answered Apr 21, 2010 at 23:11

Mark Byers

843k202 gold badges1.6k silver badges1.5k bronze badges

Comments

Nathan Mall · Accepted Answer · 2015-02-23 22:26:40Z

1

Is this while using PreparedStatements in Groovy? If so, you're using GStrings instead of plain Java Strings. Check your object yo make sure your parameters are what you expect.

answered Feb 23, 2015 at 22:26

Nathan Mall

111 bronze badge

Comments

user666923 · Accepted Answer · 2013-11-10 23:13:05Z

0

change your table to latin1 encoding or utf8mb4

answered Nov 10, 2013 at 23:13

user666923

873 silver badges14 bronze badges

Comments

user1276886 · Accepted Answer · 2016-07-21 06:14:37Z

0

ALTER TABLE your_table CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

You can try this.

answered Jul 21, 2016 at 6:14

user1276886

Collectives™ on Stack Overflow

MySql UTF encoding

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related