Friday , December 2 2022

ERROR: character with byte sequence 0xd0 0x9c in encoding “UTF8” has no equivalent in encoding “WIN1252”

If encoding is not specified in the pg_dump command, we get an error as follows.

ERROR: character with byte sequence 0xd0 0x9c in encoding “UTF8”
has no equivalent in encoding “WIN1252”

Solution :

We edit the command as below and get the dump again.

Or the client_encoding is changed.

*We are displaying client_encoding.

*We set client_encoding to UTF8. After the adjustment, we can successfully dump.

Melek Durdu
Author: Melek Durdu

Oracle and PostgreSQL DBA

About Melek Durdu

Oracle and PostgreSQL DBA

Leave a Reply

Your email address will not be published. Required fields are marked *