Postgres JDBC Error for SQL_ASCII encoded database

Hello,

I have an issue in the Intellij's Database tool when I want to query a Postgres database, encoded in 'SQL_ASCII' (I know it's bad, but I have no possibility to change that).

When I select data, I get this error :

[22021] ERROR: invalid byte sequence for encoding "UTF8": 0xe9 0x74 0x61

Is there a way to solve this issue to display data even if there are encoding issues ?

Softwares like pgAdmin, are able to display those data.

I tried to put options, in Advanced tab, such as :

- 'encodingCharset' : 'UTF8' (I tried SQL_ASCII too)

- 'clientEncoding': 'UTF8'

A few months before, in IntelliJ, only cells with encoding issues got there value filled with error, but all other data was displayed.

I tried to Download a 2018 version of IntelliJ, but to my suprise, I have the same error in this error, I don't understand.

I tried to use an older JDBC driver : postgresql-42.0.0.jre6

Here, same problem.

It would be so great to use Database tool from IntelliJ.

Here is my version :

IntelliJ IDEA 2019.2.1 Preview (Ultimate Edition)
Build #IU-192.6262.9, built on August 6, 2019

Thank you for your reply !

Have a nice day