From: Tatsuo Ishii <t-ishii@sra.co.jp>
To: sva@netpointers.com
Cc: tgl@sss.pgh.pa.us
Cc: pgsql-sql@postgresql.org
Subject: Re: Scadinavian characters in regular expressions
Date: Wed, 10 Apr 2002 10:06:52 +0900
Message-ID: <20020410100652N.t-ishii@sra.co.jp> (raw)
In-Reply-To: <910513A5A944D5118BE900C04F67CB5A1F82C7@MAIL>
References: <910513A5A944D5118BE900C04F67CB5A1F82C7@MAIL>
> There is obviously a problem with the scecial characters.
> The query SELECT 'oneå two three' ~ '^[^ ]+[ ][^ ]+$';
> produced FALSE on a database with ENCODING = 'LATIN1' and TRUE on a database
> with ENCODING = 'UNICODE'.
>
> Do you have a suggestion to how I can find the count of two-word strings
> with ENCODING = 'UNICODE'?
I see no problem here.
SELECT 'oneå two three' ~ '^[^ ]+[ ][^ ]+$';
?column?
----------
f
(1 row)
SELECT 'oneå three' ~ '^[^ ]+[ ][^ ]+$';
?column?
----------
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: t-ishii@sra.co.jp, sva@netpointers.com, tgl@sss.pgh.pa.us
Subject: Re: Scadinavian characters in regular expressions
In-Reply-To: <20020410100652N.t-ishii@sra.co.jp>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox