Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 7F7FF476B05 for ; Fri, 25 Oct 2002 10:38:12 -0400 (EDT) Received: from apps.tgds.net (apps.tgds.net [212.100.226.141]) by postgresql.org (Postfix) with ESMTP id E6E8E476826 for ; Fri, 25 Oct 2002 10:38:10 -0400 (EDT) Received: from vaio (ANantes-106-1-19-105.abo.wanadoo.fr [81.49.41.105]) (authenticated (0 bits)) by apps.tgds.net (8.11.6/8.11.6) with ESMTP id g9PEcCk08015; Fri, 25 Oct 2002 15:38:12 +0100 Subject: Re: Foreign character struggles From: Tony Grant To: Tim Perdue Cc: pgsql-sql@postgresql.org In-Reply-To: <20021025083259.B29164@mail.perdue.net> References: <20021025083259.B29164@mail.perdue.net> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Mailer: Ximian Evolution 1.0.3 (1.0.3-6) Date: 25 Oct 2002 16:36:14 +0200 Message-Id: <1035556580.20666.457.camel@vaio> Mime-Version: 1.0 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/373 X-Sequence-Number: 10090 On Fri, 2002-10-25 at 15:33, Tim Perdue wrote: > I compiled postgres with --enable-multibyte and --enable-recode, and it > doesn't appear to help with my problem. createdb my_db_name -E LATIN1 Worked just fine for me but the client wanted to be able to search with accents so I turned the to_ascii stuff off. See www.3continents.com/base_de_donnees.htm and search for "Amn=E9sie" if you want the english search to work you search for "Amnesia"... The client wants the user to check spelling... Before it worked just the way you wanted _but_ I am using a JDBC request via JSP. Cheers Tony Grant --=20 www.tgds.net Library management software toolkit, redhat linux on Sony Vaio C1XD, Dreamweaver MX with Tomcat and PostgreSQL