Received: from sraigw.sra.co.jp (sraigw.sra.co.jp [202.32.10.2]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9T0w3P85738 for ; Sun, 28 Oct 2001 19:58:04 -0500 (EST) (envelope-from t-ishii@sra.co.jp) Received: from sranhm.sra.co.jp (sranhm [133.137.13.152]) by sraigw.sra.co.jp (8.9.3/3.7W-sraigw) with ESMTP id JAA19419; Mon, 29 Oct 2001 09:57:59 +0900 (JST) Received: from localhost (IDENT:t-ishii@srapc1474.sra.co.jp [133.137.13.54]) by sranhm.sra.co.jp (8.9.3+3.2W/3.7W-srambox) with ESMTP id JAA20907; Mon, 29 Oct 2001 09:57:59 +0900 To: jm.poure@freesurf.fr Cc: pgsql-hackers@postgresql.org Subject: Re: UNICODE In-Reply-To: <4.2.0.58.20011028085953.00cfa740@pop.freesurf.fr> References: <4.2.0.58.20011028085953.00cfa740@pop.freesurf.fr> X-Mailer: Mew version 1.94.2 on Emacs 20.7 / Mule 4.1 =?iso-2022-jp?B?KBskQjAqGyhCKQ==?= Mime-Version: 1.0 Content-Type: Text/Plain; charset=iso-8859-1 Message-Id: <20011029095705G.t-ishii@sra.co.jp> Date: Mon, 29 Oct 2001 09:57:05 +0900 From: Tatsuo Ishii X-Dispatcher: imput version 20000228(IM140) Lines: 21 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id f9T11cM87460 X-Archive-Number: 200110/1002 X-Sequence-Number: 14724 I'm not sure what you are expecting but... > SELECT * FROM test WHERE source_content ILIKE '%accept%'; ---> returns a record > SELECT * FROM test WHERE source_content ILIKE '%accepté%' ---> returns a record > SELECT * FROM test WHERE source_content ILIKE '%accepte%' ---> returns 0 record So all of above seem to work fine for me. $ pg_config --configure --prefix=/usr/local/pgsql --enable-multibyte=EUC_JP --enable-unicode-conversion --with-tcl --with-perl --enable-syslog --enable-debug --with-CXX --with-java $ pg_config --version PostgreSQL 7.1.3 -- Tatsuo Ishii