Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Incorrect string value: '\xE2\x80\x8F' for column 'subject' at row 1

Description

Never seen this problem on the 1 version before this. Only see this, seems like related to the Mail portlet issue i raised earlier. Not sure what's wrong?

Caused by: java.sql.BatchUpdateException: Incorrect string value: '\xE2\x80\x8F' for column 'subject' at row 1
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1257)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:943)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)

Environment

Ubuntu 10.04 LTS 64 bits, bundled tomcat version

Activity

Show:

Michael Saechang January 30, 2012 at 11:04 AM

Closing ticket as per Szymon's comment. Thank you for verifying.

Szymon Golebiewski January 28, 2012 at 8:43 AM

I assume it helped

This issue can be closed.

Szymon Golebiewski January 18, 2012 at 12:48 AM

In most cases it means that you don't have UTF-8 collation set for your tables in database. Check database default collation (should be UTF8), then table collation and at the very end collation of column "subject" in table "mail_message".

Did it help?

Won't Fix

Details

Assignee

Reporter

Labels

Components

Fix versions

Affects versions

Priority

Zendesk Support

Created January 17, 2012 at 9:04 PM
Updated June 24, 2023 at 3:42 PM
Resolved January 30, 2012 at 11:04 AM
Loading...