5

I'm using pgAdmin IV (version 5.7) now because of my job, previously I only had used pgAdmin III. My problem is that I have already set the charset correctly with

set client_encoding = 'Win1252';

and when I execute a select, this error still appears. I'm connected to the same database with both, and the database I'm linking to is Postgres 9.5. When I do the same with pgAdmin III, I get all the data correctly.

When I run show server_encoding on the database I receive **WIN1252*: Server encoding WIN1252

Error:

'charmap' codec can't decode byte 0x8d in position 8773: character maps to <undefined>

FMorschel
  • 799
  • 5
  • 18
  • 1
    This needs more information 1) The complete version information for pgAdmin4 2) The Postgres version you are connecting to. 3) Are you connecting to the same database with `pgAdmin4` as with `pgAdmin3` 4) What does `show server_encoding;` return? – Adrian Klaver Jun 11 '22 at 15:15
  • Edited with the suggested pieces of information, thank you! – FMorschel Jun 13 '22 at 11:06
  • What are you doing when you receive the error? Can you connect with `psql` and not receive an error? – Adrian Klaver Jun 19 '22 at 21:04
  • I'm receiving this error only when I execute a select. Sorry if I wasn't clear – FMorschel Jun 20 '22 at 11:15
  • What is the select and do you have any issues when you do the select in `psql`? – Adrian Klaver Jun 20 '22 at 14:50
  • The select is ```select * from ws.ws_log order by id desc limit 100;``` and I have no issues when I do the select in `psql` – FMorschel Jun 20 '22 at 16:01
  • 1
    Hmm, I just tried here and ran into similar issue. I set the `client_encoding` under the *Parameters* tab of the database *Properties* and it seemed to ignore that setting. I'm thinking you will need to file an issue here [pgAdmin4 issues](https://www.pgadmin.org/support/issues/). FYI, you will need to set up a Postgres community account to get to the issues page itself. – Adrian Klaver Jun 20 '22 at 18:24
  • [Issue #7491](https://redmine.postgresql.org/issues/7491) created, any suggestion would be appreciated – FMorschel Jun 21 '22 at 11:02
  • Use `psql`, you will get a lot more done. – Adrian Klaver Jun 21 '22 at 14:52

0 Answers0