Search code examples
javapostgresqljdbcpgadmin

PostgreSQL encoding issue

I am running a local postgresql server in version 9.1 and using the postgresql-9.1-901.jdbc4.jar for my java application to access the database.

Though i set the encoding to UTF8 and restarted the server, it is not possible to insert (using the application) values with german umlauts like äöü. The result looks like this: √§√∂√º√ü

I already checked everywhere the encoding and even downgraded the server to version 9.0 with corresponding driver, but nothing helped.

Thanks for helping! mmm...

Solution

  • I found the solution for this problem. I was working with Mac OSX Lion, and the default system encoding changed to MacRoman after updating. However, changing the encoding fixed my problem.