Subject Re: [ib-support] Re: Firebird support case insensitive??
Author Ann W. Harrison
At 05:26 PM 12/26/2001 +0200, Arda Tunccekic wrote:
> > It's a good issue for firebird, don't you think?
>Yes I think incasesensitive indexing should be supported..
>Is it something hard to implement with firebird?

Not hard to implement, but so far, no one has offered
a spec that satisfies me. Suppose you put two indexes
on a single column, one case sensitive, one not. What
should be the result of a comparison between the two
if the only difference is case?

The presence (or absence) of an index should not affect
the comparison of values (except the performance).

We have, at various times, considered two alternatives.
One is a set of special operators that are explicitly
case insensitive. That's really non-standard, but it's
very clean, architecturally.

Another is a case-insensitive data type, which Dave Schnepper
has created (effectively) with his case insensitive collating
sequences. The problem there is remembering to cast literals
to the case insensitive type.


We have answers.