Re: Questions about encoding between two databases

Archibald Zimonyi wrote:
>
> Hello,
>
> >Archibald Zimonyi <arsi(at)aranzo(dot)netg(dot)se> writes:
> >>I went into the generated dump file and (more wish then anything else)
> >>tried to simply change the encoding from LATIN1 to UTF8 and then load the
> >>file, it did not complain about incorrect encoding setting for the load,
> >>however it complained that the characters did not match true UTF8
> >>characters (which was almost what I guessed would happen).
> >
> >Indeed. Do *not* change the client_encoding setting in the dump file.
> >You can edit the ENCODING options in the CREATE DATABASE commands
> >though. (Didn't we explain this to you already?)
> >

> Well, I did send this query with an incorrect email address so it
> got stuck and was never posted properly, so I have not seen any such
> reply. Can you please explain again?

Search the archives: http://archives.postgresql.org/

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support