Re: Questions about encoding between two databases - Mailing list pgsql-general

From Tom Lane
Subject Re: Questions about encoding between two databases
Date
Msg-id 5911.1250873204@sss.pgh.pa.us
Whole thread Raw
In response to Re: Questions about encoding between two databases  (Archibald Zimonyi <arsi@aranzo.netg.se>)
Responses Re: Questions about encoding between two databases
List pgsql-general
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

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: Error inserting data to bytea column in 8.4
Next
From: Martin Gainty
Date:
Subject: Re: Out of memory on pg_dump