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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general