Re: Questions about encoding between two databases

Archibald Zimonyi <arsi@aranzo.netg.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?)

            regards, tom lane