Received: from www.inreko.ee (www.inreko.ee [195.222.18.2]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9S9ofP77344 for ; Sun, 28 Oct 2001 04:50:42 -0500 (EST) (envelope-from marko@l-t.ee) Received: from grue ([195.222.18.13] helo=grue.l-t.ee) by www.inreko.ee with esmtp (Exim 3.22 #1) id 15xmim-0002je-00; Sun, 28 Oct 2001 11:59:12 +0200 Received: from marko by grue.l-t.ee with local (Exim 3.32 #1 (Debian)) id 15xmaY-0003Em-00; Sun, 28 Oct 2001 11:50:42 +0200 Date: Sun, 28 Oct 2001 11:50:42 +0200 From: Marko Kreen To: Jean-Michel POURE Cc: pgsql-hackers@postgresql.org Subject: Re: UNICODE Message-ID: <20011028115041.A12320@l-t.ee> References: <4.2.0.58.20011028085953.00cfa740@pop.freesurf.fr> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <4.2.0.58.20011028085953.00cfa740@pop.freesurf.fr> X-Archive-Number: 200110/978 X-Sequence-Number: 14701 On Sun, Oct 28, 2001 at 09:22:24AM +0100, Jean-Michel POURE wrote: > Dear all, > > I am running PostgreSQL 7.1.2 with UNICODE support in production. > Maybe I miss something about UNICODE: > SELECT * FROM test WHERE source_content ILIKE '%accepté%' ---> returns > nothing > SELECT * FROM test WHERE source_content ILIKE '%accepte%' ---> returns > nothing > > The same happens from ODBC, PHP and psql. Can you reproduce this? 1) Did you compile PostgreSQL with --enable-locale 2) Did you set correct locale for postmaster (LANG=xxx) -- marko