0

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 ????

user8106215
  • 1
  • 3

1 Answers1

0

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

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

How do I see what character set a MySQL database / table / column is?

my.cnf

Spring-Boot, Can't save unicode string in MySql using spring-data JPA

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

Trouble with UTF-8 characters; what I see is not what I stored

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

ian
  • 61
  • 5