db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Thornton <mthorn...@optrak.co.uk>
Subject Re: case-insensitive searching
Date Tue, 10 Jun 2008 14:08:51 GMT
Geoff hendrey wrote:
> Hi Guys,
>
> I was wondering what is being done for case-insensitive comparisons. 
> Also wanted to propose an implementation option, which would be to 
> allow indexes to be created on UPPER or LOWER. As long as I had an 
> index on UPPER or LOWER, I could do this efficiently:
>
> WHERE UPPER(T1.lastname) = UPPER(T2.lastname)
>
> Is that a totally crazy suggestion, to allow indexes to be created on 
> UPPER and LOWER? Maybe this is easy to implement.
>
> -geoff
>
Proper internationalization would require indices based on a Collator as 
defined by java.text.Collator. In general the default Collator for a 
locale is a better basis for sorting than either upper or lower case.

Mark Thornton


Mime
View raw message