db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen" <Bernt.John...@Sun.COM>
Subject Re: case insensitive searches
Date Thu, 10 Aug 2006 23:45:17 GMT
Hi,

Edson Carlos Ericksson Richter wrote:
> Is not possible to create a index based on function results?

Not for the moment. It is proposed as a new feature
(https://issues.apache.org/jira/browse/DERBY-455), but I don't think
anyone is working on it presently.

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


-- 
Bernt Marius Johnsen, Database Technology Group,
Staff Engineer, Technical Lead Derby/Java DB
Sun Microsystems, Trondheim, Norway

Mime
View raw message