X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E19C33A4F18 for ; Tue, 16 Nov 2004 07:19:08 +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 09289-04 for ; Tue, 16 Nov 2004 07:18:58 +0000 (GMT) Received: from mail.gmx.net (pop.gmx.net [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id 41C453A4F08 for ; Tue, 16 Nov 2004 07:18:58 +0000 (GMT) Received: (qmail 9690 invoked by uid 65534); 16 Nov 2004 07:18:56 -0000 Received: from dsl-082-082-232-111.arcor-ip.net (EHLO colt.pezone.net) (82.82.232.111) by mail.gmx.net (mp007) with SMTP; 16 Nov 2004 08:18:56 +0100 X-Authenticated: #495269 From: Peter Eisentraut To: Tom Lane , "Iain" Subject: Re: evil characters #bfef cause dump failure Date: Tue, 16 Nov 2004 08:18:53 +0100 User-Agent: KMail/1.5.1 Cc: "Christian Fowler" , "pgsql-admin list" References: <007901c4cb7a$1cbddcb0$7201a8c0@mst1x5r347kymb> <12470.1100568891@sss.pgh.pa.us> In-Reply-To: <12470.1100568891@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200411160818.54201.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/126 X-Sequence-Number: 15510 Tom Lane wrote: > You make a good point though --- I'm a bit tempted to make it default > to UNICODE for the Red Hat build, since Red Hat is pretty gung-ho on > UTF8 support these days. Recall that in 8.0 the default encoding will be derived from the locale. So if the postgres account has a reasonable locale set (presumably chosen somewhere during the system installation), everything will work out. -- Peter Eisentraut http://developer.postgresql.org/~petere/