Postgres Pro
Downloads
Home   >   mailing lists

Re: How do I change the server encoding? - Mailing list pgsql-general

From Antti Haapala
Subject Re: How do I change the server encoding?
Date
Msg-id Pine.GSO.4.44.0302250949390.18775-100000@paju.oulu.fi
Whole thread Raw
In response to How do I change the server encoding?  (Joseph Shraibman <jks@selectacast.net>)
Responses Re: How do I change the server encoding?  (Philippe Kiener <philippe.kiener@eivd.ch>)
List pgsql-general
Tree view 
On Mon, 24 Feb 2003, Joseph Shraibman wrote:

> I have a server that has LATIN1 encoding.  I want to convert it to run UTF encoding.  How
> do I do that?  Simply changing the encoding in a dump file does not work.

So have you done both of these:
    - dropped and recreated your db with encoding 'utf-8'
    - converted your dumps to utf-8 or
      added set client_encoding to 'latin1' in the dumps

--
Antti Haapala

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: how to detect errors in statements piped to psql?
Next
From: "Peter Gibbs"
Date:
Subject: Re: how to detect psql's errors?