Change charset encoding Postgres win1252

viciussouza's profile image viciussouza posted 1 year ago in General Permalink

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.

1 attachment(s):
  • Captura-de-tela-2022-09-01-150425
franckcdr's profile image franckcdr posted 3 months ago Permalink

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.

1 attachment(s):
  • Sans-titre
ansgar's profile image ansgar posted 3 months ago Permalink

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?

franckcdr's profile image franckcdr posted 3 months ago Permalink

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

ansgar's profile image ansgar posted 3 months ago Permalink

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.

franckcdr's profile image franckcdr posted 3 months ago Permalink

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.

Please login to leave a reply, or register at first.