retrieve unicode data from database using spring java

Question

how to retrieve unicode data from mysql database using spring java

set the url like this

<property name="url"
        value="jdbc:mysql://localhost:3306/sample?useUnicode=yes&amp;characterEncoding=UTF-8" />

But when data is loaded what i get is ????

ian · Accepted Answer · 2018-02-22 09:30:28Z

0

I can not comment cause my reputation, so I post here.

Have you checked your character set of table, database and column?

my.cnf

Make sure your code IDE(or terminal) language to UTF8

Sorry about many references, but encoding problem maybe have many cause.

answered Feb 22, 2018 at 9:14

ian

615 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1