Re: Invalid byte sequence for encoding "UTF8"

Hi Neil,

On May 15, 2007, at 5:51 PM, Neil Saunders wrote:

> Any idea why the --encoding flag didn't do this via pg_dump?


I'm not really sure. I supposed for one thing it might be difficult
to do the right thing going from SQL_ASCII to UTF8.

I had some issues with 8.0 -> 8.1 that I was able to fix with
something like this before dumping it:

update my_table set comments = translate(comments,  chr(169), 'c')
where comments like '%' || chr(169) || '%';



John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL