| From: | Michal Hlavac <hlavki(at)medium13(dot)sk> |
|---|---|
| To: | Tino Wildenhain <tino(at)wildenhain(dot)de>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Lower case |
| Date: | 2005-01-26 10:41:19 |
| Message-ID: | 41F773CF.5060909@medium13.sk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-ru-general |
Tino Wildenhain wrote:
> Hi,
>
> On Wed, 2005-01-26 at 12:01 +0000, 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?
what about ILIKE operator?
miso
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2005-01-26 10:45:17 | Re: difficult JOIN |
| Previous Message | Eric Brown | 2005-01-26 10:39:21 | log_min_duration_statement |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vladimir S. Petukhov | 2005-01-26 12:01:49 | Lower case |
| Previous Message | Dawid Kuroczko | 2005-01-26 10:15:16 | Re: Lower case |