Hi Darryl,

> Will FB case-insensitive collation and indexing be available on the
> Linux platform anytime in the near future? Its available on Windows.
> Is it doable on Linux?

Well, as Martijn discovered (much to my surprise and joy) there are
collations for the ISO8859_1 charset that are case insensitive. I
checked du_nl, en_uk, en_us and de_de with positive results.

Please note: these are standard out-of-the-box collations that come
with Firebird, and my results were the same under Linux and Windows.

You might want to experiment a little with other charsets and
collations.

I _suppose_ that if you specify a collation order for a domain/column,
that order is also used for indexing. (Would seem pretty illogical if
it weren't.)

Depending on how other charsets/collations behave, the problem you
brought up might not exist after all - except maybe that you cannot
specify a different collation order when creating an index.

Still wonder whether this is a Firebird feature or Interbase heritage,
though.


Greetings,
Paul Vinkenoog