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)
