Subject Re: [ib-support] ignore case order by
Author Dimitry Sibiryakov
On 2 Jun 2002 at 13:06, Joe Martinez wrote:

>I don't believe there's a particular way to tell FB to do a case
>insensive order by, but here's what I do:
>select upper(city) from cities
>order by 1

The problem is that if FB cannot make order by case-insensitive, it
also cannot make right UPPER(). It seems that these features are
There is a pack of "right" collates by David Schnepper (if I'm not
mistaken). I can't remember exact URL, but I believe that it can be
found by any search engine using "collate" and "Schnepper" together.

SY, Dimitry Sibiryakov.