db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kurt Huwig <k.hu...@iku-ag.de>
Subject Re: case-insensitive
Date Thu, 19 Jul 2007 06:57:02 GMT
Dan Scott schrieb:
> On 18/07/07, Onur Aslan <onur@0nur.net> wrote:
>> Hi. I am using Apache Derby and i am newbie. I have a problem. I am
>> select some rows with:
>>
>> "SELECT * FROM parcalar WHERE parca_no LIKE '%onur%'"
>>
>> But this query is select case-insensitive parca_no values. Like if
>> parca_no = Onur this query isn't select this row. I want to disable case
>> insensitive. How can i do this?
>>
>
> "SELECT * FROM parcalar WHERE LCASE(parca_no) LIKE '%onur%'"
>
> ... should do the trick, although it may be slower than you want.
>
We do another trick by lower-casing the entries upon INSERT.

Mime
View raw message