Re: Lower case - Mailing list pgsql-general

From Michal Hlavac
Subject Re: Lower case
Date
Msg-id 41F773CF.5060909@medium13.sk
Whole thread Raw
In response to Re: Lower case  (Tino Wildenhain <tino@wildenhain.de>)
List pgsql-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

pgsql-general by date:

Previous
From: Eric Brown
Date:
Subject: log_min_duration_statement
Next
From: Martijn van Oosterhout
Date:
Subject: Re: difficult JOIN