Received: from sraigw.sra.co.jp (sraigw.sra.co.jp [202.32.10.2]) by postgresql.org (Postfix) with ESMTP id 4CB924759CD for ; Tue, 9 Apr 2002 21:09:31 -0400 (EDT) Received: from srascb.sra.co.jp (srascb [133.137.8.65]) by sraigw.sra.co.jp (8.9.3/3.7W-sraigw) with ESMTP id KAA99898; Wed, 10 Apr 2002 10:07:59 +0900 (JST) Received: (from root@localhost) by srascb.sra.co.jp (8.11.6/8.11.6) id g3A17Mt93489; Wed, 10 Apr 2002 10:07:22 +0900 (JST) (envelope-from t-ishii@sra.co.jp) Received: from sranhm.sra.co.jp (sranhm [133.137.170.62]) by srascb.sra.co.jp (8.11.6/8.11.6av) with ESMTP id g3A17LV93481; Wed, 10 Apr 2002 10:07:21 +0900 (JST) (envelope-from t-ishii@sra.co.jp) Received: from localhost (IDENT:t-ishii@srapc1474.sra.co.jp [133.137.170.59]) by sranhm.sra.co.jp (8.9.3+3.2W/3.7W-srambox) with ESMTP id KAA06142; Wed, 10 Apr 2002 10:07:58 +0900 To: sva@netpointers.com Cc: tgl@sss.pgh.pa.us, pgsql-sql@postgresql.org Subject: Re: Scadinavian characters in regular expressions In-Reply-To: <910513A5A944D5118BE900C04F67CB5A1F82C7@MAIL> References: <910513A5A944D5118BE900C04F67CB5A1F82C7@MAIL> 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 Content-Transfer-Encoding: quoted-printable Message-Id: <20020410100652N.t-ishii@sra.co.jp> Date: Wed, 10 Apr 2002 10:06:52 +0900 From: Tatsuo Ishii X-Dispatcher: imput version 20000228(IM140) Lines: 33 X-Archive-Number: 200204/112 X-Sequence-Number: 7377 > There is obviously a problem with the scecial characters. > The query SELECT 'one=E5 two three' ~ '^[^ ]+[ ][^ ]+$'; > produced FALSE on a database with ENCODING =3D 'LATIN1' and TRUE on a dat= abase > with ENCODING =3D 'UNICODE'. >=20 > Do you have a suggestion to how I can find the count of two-word strings > with ENCODING =3D 'UNICODE'? I see no problem here. SELECT 'one=E5 two three' ~ '^[^ ]+[ ][^ ]+$'; ?column?=20 ---------- f (1 row) SELECT 'one=E5 three' ~ '^[^ ]+[ ][^ ]+$'; ?column?=20 ---------- t (1 row) (The database encoding is UNICODE) This is PostgreSQL 7.1.3/7.2.1 running on a Linux box. I guess you have some problems with your installation or platform. -- Tatsuo Ishii