Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id DBC0B475EDF for ; Fri, 25 Oct 2002 11:39:57 -0400 (EDT) Received: from mail.perdue.net (12-216-72-93.client.mchsi.com [12.216.72.93]) by postgresql.org (Postfix) with ESMTP id 403EE4758E6 for ; Fri, 25 Oct 2002 11:39:57 -0400 (EDT) Received: (from tperdue@localhost) by mail.perdue.net (8.11.2/8.11.2/Debian 8.11.2-1) id g9PFZXW30774 for pgsql-sql@postgresql.org; Fri, 25 Oct 2002 10:35:33 -0500 Date: Fri, 25 Oct 2002 10:35:33 -0500 From: Tim Perdue To: pgsql-sql@postgresql.org Subject: Re: Foreign character struggles Message-ID: <20021025103533.D29164@mail.perdue.net> References: <20021025083259.B29164@mail.perdue.net> <22964.1035556679@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.12i In-Reply-To: <22964.1035556679@sss.pgh.pa.us>; from tgl@sss.pgh.pa.us on Fri, Oct 25, 2002 at 10:37:59AM -0400 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/361 X-Sequence-Number: 10078 On Fri, Oct 25, 2002 at 10:37:59AM -0400, Tom Lane wrote: > Tim Perdue writes: > > I compiled postgres with --enable-multibyte and --enable-recode, and it > > doesn't appear to help with my problem. > > I think this is a locale issue, not a character set issue. You > definitely need --enable-locale, but I doubt you need either of the > above (unless you need to deal with Unicode or Far-Eastern languages). I skipped --enable-locale because I feared I would have to dump/restore all my databases and require re-testing the application. Is that unfounded? > > Also, my "Up Arrow" and "Delete" keys no longer work since I recompiled 7.2.3 > > on debian. > > You are missing libreadline. Thanks. libreadline is there, it just isn't being picked up by psql. Any suggestions? Tim Perdue