How to properly set utf8 encoding with jdbc and MySQL?

Question

JDBC and MySQL work just fine in my project except when it comes down to accented characters. This is the URL I use to access the database:

jdbc:mysql://localhost:3306/dbname?useUnicode=yes&characterEncoding=UTF-8

Suppose a resultSet = preparedStatement.executeQuery(), and then a System.out.println(resultSet.getString("text_with_accents"));. What's stored in the database is àèìòù (note that I've already set the right encoding in the database and all its tables), but what I get is ?????.

Is there a way to fix this?

score 6 · Accepted Answer · edited Feb 04 '21 at 05:52

6

Try to change your url like

url="jdbc:mysql://localhost:3306/dbname?useUnicode=true&amp;characterEncoding=UTF-8"

The & must be represented as &

edited Feb 04 '21 at 05:52

Fahim Farook

1,446
2
13
36

answered Nov 12 '15 at 10:47

Rahul Tripathi

161,154
30
262
319

@pr0gma:- Can you check your my.cnf and see if your file has `[client] default-character-set=utf8 [mysql] default-character-set=utf8` present? – Rahul Tripathi Nov 12 '15 at 10:49
I have no my.cnf. Should I create one? If so, where? – pr0gma Nov 12 '15 at 10:52
@pr0gma:- It should be present. You can refer this: http://stackoverflow.com/questions/4292769/what-is-the-location-of-mysql-client-my-cnf-in-xampp-for-windows to get its location – Rahul Tripathi Nov 12 '15 at 10:59
Found the my.ini. Double checked, the option was already set in both the client and mysql section. – pr0gma Nov 12 '15 at 16:41
1

`characterEncoding=utf8` --> `characterEncoding=UTF-8`. – Rick James Dec 23 '18 at 20:06

score 0 · Answer 2 · answered Dec 11 '15 at 04:08

0

Probably...

you had utf8-encoded data (good)
SET NAMES latin1 was in effect (default, but wrong)
the column was declared CHARACTER SET latin1 (default, but wrong)

answered Dec 11 '15 at 04:08

Rick James

122,779
10
116
195

How to properly set utf8 encoding with jdbc and MySQL?

2 Answers2

Linked