Re: russian case-insensitive regexp search not working - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: russian case-insensitive regexp search not working
Date
Msg-id 20070709140232.GD5682@merkur.hilbert.loc
Whole thread Raw
In response to Re: russian case-insensitive regexp search not working  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: russian case-insensitive regexp search not working  (alexander lunyov <lan@startatom.ru>)
List pgsql-general
On Mon, Jul 09, 2007 at 09:50:42AM -0400, Tom Lane wrote:

> > On Mon, Jul 09, 2007 at 04:00:01PM +0400, alexander lunyov wrote:
> >> I found this bug report:
> >> http://archives.postgresql.org/pgsql-bugs/2006-09/msg00065.php
> >>
> >> Is it about this issue?
> > Yes.
>
> >> And will it be fixed someday?
> > Likely. In the meantime lower() can come to the rescue.
>
> It's not nearly as easy to fix as the reporter of that bug imagines,
> because we don't know the relationship between pg_wchar representation
> and the wchar_t representation assumed by the <wctype.h> functions.

Just to clarify: lower() on both sides of a comparison
should still work as expected on multibyte encodings ? It's
been suggested here before.

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: russian case-insensitive regexp search not working
Next
From: CG
Date:
Subject: xpath_* namespace bug