RE: [GENERAL] 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: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
Cc: pgsql-general(at)postgresql(dot)org <pgsql-general(at)postgresql(dot)org>
Subject: RE: [GENERAL] Query failed: ERROR: character with byte sequence 0xc2 0x96 in encoding "UTF8" has no equivalent in encoding "WIN1250"
Date: 2015-11-25 13:56:29
Message-ID: 3gP.DhxV.3vo4DamXUUM.1MLRuD@seznam.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

but how to update affected columns ? error message does not  provide single 
clue ( at least row name)

And dump-restore ?  It  do not underestand how it could help.. dumped as
unicode  restore as unicode = I am at the same point ... dumping as latin2
and restore to utf8 will end with the some errors..  I suspect

---------- Původní zpráva ----------
Od: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
Komu: 'NTPT *EXTERN*' <NTPT(at)seznam(dot)cz>
Datum: 25. 11. 2015 14:47:46
Předmět: RE: [GENERAL] Query failed: ERROR: character with byte sequence 0xc
2 0x96 in encoding "UTF8" has no equivalent in encoding "WIN1250"

"NTPT wrote:
> but how to solve this in existing database ?

Either update all affected columns in the source database
or edit the database dump...

Yours,
Laurenz Albe"

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2015-11-25 14:43:51 Re: Problems with pg_upgrade after change of unix user running db.
Previous Message Stephen Frost 2015-11-25 13:42:35 Re: "trust" authentication in pg_hba.conf