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

From Alvaro Herrera
Subject Re: Questions about encoding between two databases
Date
Msg-id 20090821185635.GI5487@alvh.no-ip.org
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  (Archibald Zimonyi <arsi@aranzo.netg.se>)
List pgsql-general
Archibald Zimonyi wrote:
>
> Hello,
>
> >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?)
> >

> 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

pgsql-general by date:

Previous
From: David Kerr
Date:
Subject: export a schema / import as new schema
Next
From: Alban Hertroys
Date:
Subject: Comparing arrays of composite types