Re: [Firebird-devel] Case-insensitive collations

[James K. L. <jkl...@sc...>]

On Sat, 26 Jun 2004, "Carlos H. Cantu" <fb...@wa...> wrote:
> JKL>It's standard practice to use UPPER() to defeat case-sensitive
> JKL>searches.
> 
> The major problem of using UPPER/NOACCENT is that it does not allow
> indexes usage in the search.

Sure, but that's an artifact of the implementation.  Indexes are not
controlled by the SQL standard, and Firebird is free to implement them
however it wishes, in as many ways as it wishes.  

--jkl