db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edson Carlos Ericksson Richter <edson.rich...@mgrinformatica.com.br>
Subject Re: case insensitive searches
Date Thu, 10 Aug 2006 18:35:22 GMT
Is not possible to create a index based on function results?

Regards,

Richter




Terry Kilshaw escreveu:
> Kristian,
>
> I mean like in MySQL. You configure it for case insensitive searching and
> that's it.
>
> For example the following two SELECT statements return the same row, whose
> actual value is 'jdoe':
>
> select userID from tbl_personnel where userID = 'jdoe'
> select userID from tbl_personnel where userID = 'JDOE'  
>
> Most of the feedback so far seems to indicate that although cas-insensitive
> searching can be done it Derby, it carries the penalty of not using indexes.
>
> Terry
>
> -----Original Message-----
> From: Kristian.Waagan@Sun.COM [mailto:Kristian.Waagan@Sun.COM] 
> Sent: Wednesday, August 09, 2006 3:20 PM
> To: Derby Discussion
> Subject: Re: case insensitive searches
>
> Terry Kilshaw wrote:
>   
>> Is it possible to set Derby to do case-insensitive searches? The 
>> default seems to be case-sensitive. This would be fine as a global 
>> setting that never needs to change.
>>     
>
> Hi Terry,
>
> Could give us some more information on what kind of searches you are talking
> about? Most importantly, what searching mechanism is being used.
>
>
>
> Thank you,
>   


Mime
View raw message