Re: russian case-insensitive regexp search not working

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