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

From: NTPT <NTPT(at)seznam(dot)cz>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Query failed: ERROR: character with byte sequence 0xc2 0x96 in encoding "UTF8" has no equivalent in encoding "WIN1250"
Date: 2015-11-25 10:22:29
Message-ID: 2sa.Dhu5.1hk1yrpTNFy.1MLOlb@seznam.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 win
1250"

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)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tomas Vondra 2015-11-25 11:38:08 Re: full_page_writes on SSD?
Previous Message Albe Laurenz 2015-11-25 09:16:25 Re: What could cause CREATE TEMP... "could not read block" error?