Daniel Szalay Daniel Szalay - 4 years ago 201
SQL Question

JDBC character encoding

I have a Java Web application running on GlassFish 3 and JPA (EclipseLink) on MySQL. The problem I'm facing is that if I'm saving entities to the database with the

update()
method,
String
fields lose integrity;
'?'
is shown instead of some characters.

The server, pages and database are configured to use
UTF-8
.

After I post form data, the next page shows the data correctly. Furthermore it "seems" in NetBeans debug that the
String
property of the current entity stores the correct value too. Dunno if NetBeans debug can be trusted; might be that it decodes correctly, however it's incorrect.

Answer Source

It's JDBC, not JPA that determines the encoding:

jdbc:mysql://localhost:3306/administer?characterEncoding=utf8
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download