--- In Firebird-Architect@yahoogroups.com, Jim Starkey <jas@n...>
wrote:

> I think the question of case-insensitivity is an interesting case.

In

> general, collation is only necessary for a high/low test -- sorting

and

> range retrievals, while equality can be based on raw byte

comparison.

> To support case insensitivity, collation is required to determine

even

> equality.
>
> Are there other collations where equality is collation specific?
>

In german, the character 'ß' (esstet) is absolutely equivalent
to 'ss'. So, 'Fußball' and 'Fussball' should be seen as equal. The
uppercase rule for 'ß' is that it becomes 'SS', so uppercase
('fußball') = 'FUSSBALL'