initializing postgreSQL db with data.sql -file and having utf-8 encoding work

Question

When initializing postgreSQL database via application.properties using the data.sql -file, the inserted data with chars (like Ä and ö) that require utf-8 encoding do not get correctly encoded in their respective fields.

So, I have in the application.properties file the following by which to populate the database ...

spring.datasource.initialization-mode=always
spring.datasource.data=classpath:data.sql

...

Spring does the schema creation by:

spring.jpa.hibernate.ddl-auto=create-drop

What else should I define to get those chars to encode utf-8 correctly.

In addition, in pgAdmin properties I can see that the database itself is utf-8 encoded.

M.Y. · Accepted Answer · 2018-10-30 15:08:03Z

0

I found answer by finding it from an other thread: Wrong encoding between Spring and PostgreSQL.

This simply was needed in addition in application properties and utf-8 encoding now works:

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

answered Oct 30, 2018 at 15:08

M.Y.

6291 gold badge7 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

initializing postgreSQL db with data.sql -file and having utf-8 encoding work

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related