Hi Paul,

> > 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.

Do note that these collations will NOT provide you with case
insensitive comparisons in WHERE clauses.

> 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.

IB.


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."