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

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Won't Fix
• Affects Version/s: 6.1.0 CE GA1
• Fix Version/s: --Sprint 11/12, 6.2.0 CE M2
• Component/s: Collaboration, Collaboration > Mail
• Labels:
  • community-verifier
• Environment: Ubuntu 10.04 LTS 64 bits, bundled tomcat version
• Similar Issues: Show 5 results ; ;

  LPS-18256	Incorrect string value
  LPS-4189	Data truncation: Data too long for column 'key_' at row 1
  LPS-19207	Incorrect solr query for an 'a' keyword
  LPS-14474	Mail portlet not synchronizing all the mails
  LPS-32878	When a portlet is deployed, there are no check about name length. If it is over PortletItem.portletId column width (75 characters), the portlet is incorrectly deployed, generating later errors.

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)

[Szymon Golebiewski]

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?

[Szymon Golebiewski]

I assume it helped

This issue can be closed.

[Michael Saechang]

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