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

From Tom Lane
Subject Re: russian case-insensitive regexp search not working
Date
Msg-id 18790.1184075693@sss.pgh.pa.us
Whole thread Raw
In response to Re: russian case-insensitive regexp search not working  (alexander lunyov <lan@startatom.ru>)
Responses Re: russian case-insensitive regexp search not working  (alexander lunyov <lan@startatom.ru>)
List pgsql-general
alexander lunyov <lan@startatom.ru> writes:
>     With this i just wanted to say that lower() doesn't work at all on
> russian unicode characters,

In that case you're using the wrong locale (ie, not russian unicode).
Check "show lc_ctype".

Or [ checks back in thread... ] maybe you're using the wrong operating
system.  Not so long ago FreeBSD didn't have Unicode locale support at
all; I'm not sure if 6.2 has that problem but it is worth checking.
Does it work for you to do case-insensitive russian comparisons in
"grep", for instance?

            regards, tom lane

pgsql-general by date:

Previous
From: "Alexander Staubo"
Date:
Subject: Re: TOAST, large objects and ACIDity
Next
From: Brad Nicholson
Date:
Subject: Vaccum Stalling