Re: russian case-insensitive regexp search not working

alexander,

lc_ctype and lc_collate can be changed only at initdb !
You need to read localization chapter
http://www.postgresql.org/docs/current/static/charset.html


Oleg
On Thu, 12 Jul 2007, alexander lunyov wrote:

> Tom Lane wrote:
>> 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".
>
> db=>  SHOW LC_CTYPE;
> lc_ctype
> ----------
> C
> (1 запись)
>
> db=>  SHOW LC_COLLATE;
> lc_collate
> ------------
> C
> (1 запись)
>
> Where can i change this? Trying to SET this parameters gives error "parameter
> "lc_collate" cannot be changed"
>
>> 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?
>
> I put to textfile 3 russian strings with different case of first char and
> grep'ed them all:
>
> # cat > textfile
> Зеленая
> Зеленодольская
> зеленая
> # grep -i зелен *
> textfile:Зеленая
> textfile:Зеленодольская
> textfile:зеленая
>
> So i think system is fine about unicode.
>
>

     Regards,
         Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83