From: Peter Eisentraut <peter_e@gmx.net>
To: pgsql-admin@postgresql.org
Cc: Carol Walter <walterc@indiana.edu>
Subject: Re: Changing encoding
Date: Tue, 15 Jul 2008 17:04:43 +0200
Message-ID: <200807151704.44182.peter_e@gmx.net> (raw)
In-Reply-To: <DA753240-4B27-402B-9C18-9404E7B8773A@indiana.edu>
References: <DA753240-4B27-402B-9C18-9404E7B8773A@indiana.edu>
Am Dienstag, 15. Juli 2008 schrieb Carol Walter:
> I have some databases that use SQL ASCII or Latin1 encoding that need
> to be UTF8. When I have drop the database and recreated it with the
> correct encoding I get errors in restoring the data. How is this done?
What is your PostgreSQL version? What is the exact command sequence?
The sort of problem you describe is usually fixed by setting the client
encoding correctly, but recent versions should do this automatically for
dumps/restores.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: peter_e@gmx.net, walterc@indiana.edu
Subject: Re: Changing encoding
In-Reply-To: <200807151704.44182.peter_e@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox