I realize I was too short, sorry. NTPT wrote: > but how to update affected columns ? error message does not provide single clue ( at least row name) For every table and every column in the source database that might be affected, try something like: SELECT id, col FROM tab WHERE col LIKE E'%\x96%'; Then issue UPDATE statements for the affected rows, e.g. replacing "–" with "-". > 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 You can run something like this over the plain text dump: sed -e 's/–/-/g' dump.sql >fixed.sql Of course there might be other windows characters lurking ... Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
