| From: | Mihail Nasedkin <m(dot)nasedkin(dot)perm(at)mail(dot)ru> |
|---|---|
| To: | pgsql-ru-general(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] Lower case |
| Date: | 2005-01-27 03:23:03 |
| Message-ID: | 6137262656.20050127082303@mail.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-ru-general |
Здравствуйте, все.
Увидел письмо от Владимира (переслал Олег 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(dot)nasedkin(dot)perm(at)mail(dot)ru
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Madison Kelly | 2005-01-27 05:35:25 | Return value of 'serial' column on insert |
| Previous Message | PFC | 2005-01-27 01:42:34 | Re: Extended unit |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dawid Kuroczko | 2005-01-27 09:44:51 | Re: Lower case |
| Previous Message | Vladimir S. Petukhov | 2005-01-27 00:16:14 | Re: Lower case |