Postgres Pro
Downloads
Home   >   mailing lists

Query failed: ERROR: character with byte sequence 0xc2 0x96 in encoding "UTF8" has no equivalent in encoding "WIN1250" - Mailing list pgsql-general

From NTPT
Subject Query failed: ERROR: character with byte sequence 0xc2 0x96 in encoding "UTF8" has no equivalent in encoding "WIN1250"
Date
Msg-id 2sa.Dhu5.1hk1yrpTNFy.1MLOlb@seznam.cz
Whole thread Raw
Responses Re: Query failed: ERROR: character with byte sequence 0xc2 0x96 in encoding "UTF8" has no equivalent in encoding "WIN1250"  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-general
Tree view
Hi, all.

I need help.

pg_exec(): Query failed: ERROR: character with byte sequence 0xc2 0x96 in encoding "UTF8" has no equivalent in encoding "WIN1250"

It is a strange. First there was a database with latin2 encoding.

to this database connect an aplicaton with "set client encoding to win1250" and manipulating data

then database was dumped with pg_dump -E UTF8

then database was restored pg_restore on another cluster in database with UTF8 encoding

then application connect to new database with "set client encoding to win1250"

and - query failed


How in this scenario could invaid  characters reach the database ???

And how to solve this ? Errort message is not very useful, because does not provide any hint (at least column and row)

pgsql-general by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: What could cause CREATE TEMP... "could not read block" error?
Next
From: Tomas Vondra
Date:
Subject: Re: full_page_writes on SSD?