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 D7A113A49FF for ; Mon, 15 Nov 2004 20:44:37 +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 44260-02 for ; Mon, 15 Nov 2004 20:44:27 +0000 (GMT) Received: from leda.steelsun.com (dsl093-240-204.ral1.dsl.speakeasy.net [66.93.240.204]) by svr1.postgresql.org (Postfix) with ESMTP id 40D633A47E6 for ; Mon, 15 Nov 2004 20:44:27 +0000 (GMT) Received: from leda.steelsun.com (localhost [127.0.0.1]) by leda.steelsun.com (8.12.11/8.12.8) with ESMTP id iAFKiKjo013130; Mon, 15 Nov 2004 15:44:20 -0500 Received: from localhost (cfowler@localhost) by leda.steelsun.com (8.12.11/8.12.11/Submit) with ESMTP id iAFKiKVJ013127; Mon, 15 Nov 2004 15:44:20 -0500 X-Authentication-Warning: leda.steelsun.com: cfowler owned process doing -bs Date: Mon, 15 Nov 2004 15:44:20 -0500 (EST) From: Christian Fowler X-X-Sender: cfowler@leda.steelsun.com To: Tom Lane Cc: Christian Fowler , pgsql-admin list Subject: Re: evil characters #bfef cause dump failure In-Reply-To: <10478.1100550946@sss.pgh.pa.us> Message-ID: References: <9996.1100547889@sss.pgh.pa.us> <10478.1100550946@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed 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/121 X-Sequence-Number: 15505 db-# ; server_encoding ----------------- SQL_ASCII (1 row) whoa! yikes, I bet this has a lot to do with it? I really wanted to keep everything UNICODE end-to-end. I must have forgotten --encoding on my initdb? Anything I can do at this point? On Mon, 15 Nov 2004, Tom Lane wrote: > Christian Fowler writes: >> [shell]$ env >> PGCLIENTENCODING=UNICODE >> LANG=en_US.UTF-8 > >> db=# \encoding >> UNICODE > > I was more concerned about the database encoding, which the above > doesn't prove. Try "SHOW server_encoding" > > regards, tom lane > [ \ / [ >X< Christian Fowler | spider AT viovio.com [ / \ http://www.viovio.com | http://www.tikipro.org