Hi everyone,
So, I'm using pgAdmin4 to connect to a PostgreSQL 10.3 instance which has a
database with WIN1252 encoding.
Whenever I try to select results from a table:
table myschema.mytable;
I get this error:
ERROR: character with byte sequence 0x81 in encoding "WIN1252" has no
equivalent in encoding "UTF8"
When I use psql, it's rather easy to deal with this error, all it takes is
to alter the client_encoding variable:
set client_encoding = 'WIN1252';
table myschema.mytable;
(lots of results)
But when I try to alter the variable through pgAdmin4, I get no results
whatsoever, just a blank screen:
[image: Screenshot_20181215_163625.png]
Would you guys know if I'm missing something, or if supporting WIN1252
characters is a feature pgAdmin4 still doesn't support?
Thanks in advance,
Arlindo Neto.