Re: Easy way to convert a database from WIN1252 to UTF8?

On Thu, Jul 01, 2010 at 09:47:03AM -0700, Mike Christensen wrote:
> On Thu, Jul 1, 2010 at 9:44 AM, Sam Mason <sam(at)samason(dot)me(dot)uk> wrote:
> > On Thu, Jul 01, 2010 at 09:31:12AM -0700, Mike Christensen wrote:
> >> Then, I edited the file in Notepad and saved it as UTF8 which also
> >> appears to have worked.
> >
> > I don't think you want to be doing this. The file should contain a "set
> > client_encoding" of the correct value which will let PG to do the "right
> > thing" when you import it back into a UTF8 database.
>
> Yup, that fixed it. I had to change the DB.dbs.out file to use the
> new encoding. Duh! Everything's working now.

AFAIK, you should be able to leave the file exactly as it came out of
pg_dump and PG will do all the conversions automatically.

If you've not checked already, it may be worth checking through to see
what row was on line 170 and see if it's got the right thing in there
now.

--
Sam http://samason.me.uk/