Subject Re: Case Sensitivity on Indices
Author darryl_caillouet <darryl.caillouet@allte
--- In ib-support@yahoogroups.com, "Martijn Tonies" <m.tonies@u...>
wrote:
> ...I think there's
> a clear distinction between the use of indices (see my prev. post)
and
> constraints - that's why I thought the comparison was flawed.

True. But I wasn't trying to compare indices and constraints. I was
trying to compare mindset to mindset: how people view the good things
and bad things about a particular design. MySQL's arguments may be
crap and FB's arguments may be excellent. But if the goal of FB users
and developers is to get more people to use FB, then having a superior
design or greater speed isn't everything. Sometimes you have to cater
to certain expectations or developers will dismiss your product
without giving it a try.

>There is
> a reason why case-insensitive indices aren't available (see Helens
post).

I knew they weren't available. My reason for getting involved with
this post was to get the following question answered: 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? If I really want this feature without having to write
triggers and modifying tables, should I look elsewhere? Or should I
start learning FB because this feature will be available soon?

Darryl