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(at)startatom(dot)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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83