Skip site navigation (1) Skip section navigation (2)

Re: Changing encoding

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Cc: Carol Walter <walterc(at)indiana(dot)edu>
Subject: Re: Changing encoding
Date: 2008-07-15 15:04:43
Message-ID: 200807151704.44182.peter_e@gmx.net (view raw or flat)
Thread:
Lists: pgsql-admin
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.

In response to

Responses

pgsql-admin by date

Next:From: Matthew T. O'ConnorDate: 2008-07-15 15:12:30
Subject: Re: More Autovacuum questions
Previous:From: Carol WalterDate: 2008-07-15 14:14:25
Subject: Changing encoding

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group