Change charset encoding Postgres win1252

I started using HeidiSQL to access Postgres, where the base is under WIN1252. When opening a table, where it has data like ~ç and other special characters, it is not showing correctly. I couldn't find where to change the display configuration.

Bonjour,

J'ai le même problème.

Ma base est encodée en WIN1252 et les caractères accentués ne s'affichent pas correctement. Si je passe par PGADMIN, l'affichage est correct.

Comment résoudre ce problème ? HeidiSQL n'est pas compatible avec les bases encodées WIN1252 ?

J'utilise la 12.6.0.6765

Cordialement.

I'm not really sure what HeidiSQL should do to support other client_encoding's than "UTF8". Please read issue #22 and try to make a suggestion what could fix that.

Does it help if you fire SET CLIENT_ENCODING TO "WIN1252" in a query tab?

It doesn't do anything more. I'm disappointed that HeidiSQL do not support other client_encodind than UTF8.

Well that was just a guess, and I am not that deep into PostgreSQL yet.

In the newer issue #1864 there is a new comment which sounds promising. I will try to fix that there. Please watch the issue to get updates. I will try to remember this thread as well.

Thank's but I don't want to touch my data encoding. WIN1252 is the encoding used and we don't want to change it.