Thread: Re: [GENERAL] Lower case

Vladimir,

there is pgsql-ru-general mailing list for russian speaking people

     Oleg
On Wed, 26 Jan 2005, Vladimir S. Petukhov wrote:

> Hi!
>
> Sorry for my English..
>
> I want to do case-insensitivity search, like this
> ... WHERE lower (column_name) LIKE lower (%value%);
> This work fine for English..
> But i need search for Russian words, lower() operator does not work with
> Russian (non-English) chars, but ORDER works fine...
> ???????????????
> What's wrong?
>
>

     Regards,
         Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

Здравствуйте, все.

Увидел письмо от Владимира (переслал Олег 26 января 2005 г., 17:35:00)

OB> On Wed, 26 Jan 2005, Vladimir S. Petukhov wrote:

>>
>> I want to do case-insensitivity search, like this
>> ... WHERE lower (column_name) LIKE lower (%value%);
>> This work fine for English..
>> But i need search for Russian words, lower() operator does not work with
>> Russian (non-English) chars, but ORDER works fine...
>> ???????????????
>> What's wrong?
>>

Действительно, как заставить PostgeSQL поддерживать системную локаль?

--
С уважением,
 Mihail                          mailto:m.nasedkin.perm@mail.ru