X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 76F6F3A3B8C for ; Fri, 26 Nov 2004 07:31:01 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 37465-02 for ; Fri, 26 Nov 2004 07:30:51 +0000 (GMT) Received: from mail.gmx.net (mail.gmx.de [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id 7D9973A4983 for ; Fri, 26 Nov 2004 07:30:50 +0000 (GMT) Received: (qmail 27375 invoked by uid 65534); 26 Nov 2004 07:30:48 -0000 Received: from dsl-213-023-254-133.arcor-ip.net (EHLO colt.pezone.net) (213.23.254.133) by mail.gmx.net (mp020) with SMTP; 26 Nov 2004 08:30:48 +0100 X-Authenticated: #495269 From: Peter Eisentraut To: Andrew M Subject: Re: HowTo change encoding type.... Date: Fri, 26 Nov 2004 08:30:41 +0100 User-Agent: KMail/1.6.2 Cc: pgsql-sql@postgresql.org References: In-Reply-To: MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: 7bit Message-Id: <200411260830.41161.peter_e@gmx.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/261 X-Sequence-Number: 19579 Andrew M wrote: > how do I change the encoding type in postgreSQL (8) from UTF-8 to > ISO-8859-1? Dump your database, drop your database, recreate your database with the different encoding, reload your data. Make sure the client encoding is set correctly during all this. -- Peter Eisentraut http://developer.postgresql.org/~petere/