Eclipse Community Forums: Java Development Tools (JDT) » Eclipselink / MySQL / UTF-8 Issues

Help

Home

Home » Language IDEs » Java Development Tools (JDT) » Eclipselink / MySQL / UTF-8 Issues

Show: Today's Messages :: Show Polls :: Message Navigator

Eclipselink / MySQL / UTF-8 Issues [message #1741571]

Thu, 25 August 2016 21:34

Richard Harrison

Messages: 3
Registered: October 2014

Junior Member

I've set up a small project using Struts 2, Tomcat, Eclipselink and MySQL, which needs to store some special characters in the database using UTF-8. I set up the database tables as "utf8_unicode_ci". The persistance.xml file looks like this:

<properties>
	<property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.Driver" />
	<property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost:3306/xxxxxx?useUnicode=true&amp;characterEncod‌ing=UTF-8" />
	<property name="javax.persistence.jdbc.user" value="yyyyyyyy" />
	<property name="eclipselink.logging.level" value="FINE"/>
	<property name="eclipselink.ddl-generation" value="drop-and-create-tables"/>
	<property name="eclipselink.ddl-generation.output-mode" value="sql-script"/>
	<property name="eclipselink.create-ddl-jdbc-file-name" value="datastore-create.sql"/>
	<property name="eclipselink.drop-ddl-jdbc-file-name" value="datastore-drop.sql"/>
	<property name="eclipselink.application-location" value="/home/richardh/dddd/"/>
	<property name="eclipselink.deploy-on-startup" value="false"/>
	<property name="javax.persistence.jdbc.password" value="zzzzzzz"/>
</properties>

When special characters are entered through the app, the EclipseLink logs show that the special characters are in the statement as it is logged. However, they aren't in the database correctly. (They show up as "?".) When I take the same statement and manually run it against the database, it works fine. I'm not sure where to go from here.

Thanks in advance for any ideas anyone can provide.

[Updated on: Thu, 25 August 2016 22:06]

Report message to a moderator