Wrong encoding between Spring and PostgreSQL

Question

I have a Spring Boot (version 1.3) Web application, all in UTF-8, and a PostgreSQL server with server encoding UTF-8 and client encoding WIN1252.

The problem is that when I save in the DB something with special characters manually, the encoding is right, but from JDBC the string is saved wrong.

In the same way, when I have a string saved with special characters and I make a SELECT query to read manually, the encoding is right, but from JDBC the string is read wrongly.

Dropping the database and creating again is not a choice for the moment, so I have been trying a lot of things with poor result. Is there any solution for me?

PD: I have put all these properties in my application.properties file:

spring.datasource.sql-script-encoding = UTF-8
spring.http.encoding.charset = UTF-8
spring.http.encoding.enabled = true
spring.http.encoding.force = true
spring.mandatory-file-encoding = UTF-8
server.tomcat.uri-encoding = UTF-8
spring.messages.encoding = UTF-8

I think your property is incorrectly named. Try spring.datasource.sqlScriptEncoding=UTF-8 instead of spring.datasource.sql-script-encoding = UTF-8 — dambros
– dambros, Commented Mar 25, 2016 at 15:01
I'm using Spring Boot 1.3, I didn't say it sorry. The property is called as you said in Spring Boot 1.2 I think. Application Properties 1.3.3 — malkomich
– malkomich, Commented Mar 25, 2016 at 15:25
It works for me straight out of the box with the default Boot settings. I posted € over HTTP and it saved correctly in the db and returned € in the response. Which unicode chars are you trying? — Neil McGuigan
– Neil McGuigan, Commented Mar 25, 2016 at 20:58
I have just test it saving '€' character, and it has been encoded as 'Ç' character. Have you the same server and client encoding as me? — malkomich
– malkomich, Commented Mar 25, 2016 at 21:04

G.O. · Accepted Answer · 2021-11-11 10:41:26Z

4

I had a similar problem. I use Spring Boot 1.5.9 and postgres 9.6, data.sql with inserts. Encoding on data.sql was UTF-8, but after start of application, in DB was special symbols instead russian letters.

spring.datasource.sql-script-encoding= UTF-8

This property in application.properties has helped.

All properties responsible for DB:

spring.datasource.jndi-name=java:/PostgresDS
spring.jpa.properties.hibernate.default_schema=my_scheme_name
spring.jpa.hibernate.ddl-auto = update
spring.jpa.show-sql = false
spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect
spring.datasource.continue-on-error=true
spring.datasource.sql-script-encoding= UTF-8

edited Nov 11, 2021 at 10:41

answered Sep 13, 2018 at 9:41

G.O.

5201 gold badge4 silver badges16 bronze badges

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

2 Comments

happy_marmoset Over a year ago

It is deprecated github.com/spring-projects/spring-boot/blob/v2.6.3/… and remove in Spring Boot 3.0.

G.O. Over a year ago

@happy_marmoset it sounds great!

Eduard · Accepted Answer · 2022-11-07 14:50:52Z

1

Now the correct option is:

spring.sql.init.encoding = UTF-8

edited Nov 7, 2022 at 14:50

answered Nov 7, 2022 at 14:12

Eduard

1012 silver badges4 bronze badges

Comments

Nick Delaney · Accepted Answer · 2016-03-25 14:59:51Z

0

Where you define the datasource URL, try adding ?characterEncoding=UTF-8 to the end of the URL

answered Mar 25, 2016 at 14:59

Nick Delaney

6015 silver badges15 bronze badges

1 Comment

malkomich Over a year ago

I added it, but the problem continues :(

Vadim Pilipenko · Accepted Answer · 2022-09-01 17:46:35Z

0

In my case the problem was on JVM side.

After I added:

-Dfile.encoding=UTF8

as VM option - problem was resolved

answered Sep 1, 2022 at 17:46

Vadim Pilipenko

114 bronze badges

Collectives™ on Stack Overflow

Wrong encoding between Spring and PostgreSQL

4 Answers 4

2 Comments

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related