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.
|