> Err... the good answer may have to wait for Firebird 2.0. There

are

> case insensitive collations for ISO8859-1 (that's the character

set you

> want, I suspect). The problem is integrating case insensitivity

into

> all the string comparisons and functions ... Peter Jacobi wrote
> collations that are case insensitive, which might be a starting

point.

>
> The collation chosen has no effect on data representation - that's

the

> character set - and a case insensitive collation has no effect on

index

> size, as compared with a case sensitive but dictionary style

collation.

>
> Regards,
>
>
> Ann

Will the database every have a default collation like it does with
character sets, so that you don't have to manually add it to every
string field?

Or am I mistaken in what I just said?

Thanks