Java: insert accented characters in mysql

Question

If I have this query from java:

String query="insert into user (..., name, ...) values (..., 'à', ...)";
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/Spinning?user=root");
PreparedStatement prest = con.prepareStatement(query);
prest.executeUpdate();

In the db I will have a strange character: a diamond with a question mark inside.

Is there any solution to this problem?

It'll be down to the character-set that you're using, though it's hard to say exactly where if hard-coded try looking at the class file first — Bob Flannigon, Feb 07 '13 at 11:06
@BobFlannigon I can't understand where I have to look....In the class file? — Martina, Feb 07 '13 at 11:07
What's the CREATE statement used to create the table? The name column needs to have proper encoding (preferably unicode) to support all accented characters — Adam Dyga, Feb 07 '13 at 11:12

score 3 · Accepted Answer · answered Feb 07 '13 at 11:16

3

Change your connection url to the following:

jdbc:mysql://localhost/Spinning?user=root&useUnicode=true&characterEncoding=utf8

answered Feb 07 '13 at 11:16

Wim Deblauwe

25,113
20
133
211

score 1 · Answer 2 · answered Feb 07 '13 at 11:15

Verify the character set you are using in MySQL DB. You can try "SHOW CREATE TABLE xxxx" to print the table DDL with charset being used.
Verify the character set you are using in JDBC driver. If using MySQL ConnectorJ, you can set charset in the JDBC url.

Java: insert accented characters in mysql

2 Answers2