--- In Firebird-Architect@yahoogroups.com, Olivier Mascia wrote:
> Regarding french language, characters with accent should sort as the
> same characters without accent, just as it is in a french dictionnary.
> Don't know for spanish. But I assume this rule is mostly valid, with
> maybe some exceptions that could justify some collating rules.

Oh yes! Collation rules are just a bunch of exceptions.
Putting them all in the wastebasket would certainly not help.

See in our files area
http://groups.yahoo.com/group/Firebird-Architect/files/charsets_and_collations/
the file latinletters_win32.html for examples.

Why a large group of languages have equal sorting in this example,
another eually large group begs to differ.

An that comparisons doesn't even cover all the possibilities
for differences (digraph sorting and accent sorting order).

Regards,
Peter Jacobi