pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (7+ messages)

Message-ID: <20020410100652N.t-ishii@sra.co.jp>
Permalink:  ../20020410100652N.t-ishii@sra.co.jp/
Also on:    postgresql.org/message-id/20020410100652N.t-ishii@sra.co.jp

 · 

reply

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