WL#5211: Spanish collation

Affects: Server-Prototype Only   —   Status: Un-Assigned   —   Priority: Very High

Adopt a Spanish collation which follows standards
and is consistent across many character sets.
Start with a new Spanish collation for latin9.
A collation for latin9 which is based
on Unicode UCA and CLDR Spanish tailoring.
Like latin1_spanish_ci
but without the bugs and more like the standards.


New collations are based on Unicode Collation
Algorithm (UCA), and are tailored according to
Common Locale Data Repository (CLDR)
from the Unicode site. Fuller description of
the principles is in WL#5170 Swedish collation.


Since the convention is
character set name _ language name _ UCA version _ case-insensitivity abbreviation
the new collation is

The Rules

The tailoring rules come from the CLDR file es.xml,
attached to this worklog task, or through these steps:
Go to http://cldr.unicode.org/
Click "CLDR Releases/Downloads"
Click "CLDR 1.7.2"
Click "core.zip"
Unzip core.zip
Copy ./common/collation/es.xml

Remember that, according to "Principles",
any ligatures are sorted as equal to the
first character of the expansion, because
we want to keep the collations simple
(one weight per character, primary weights only).

So Peter Gulutzan thinks these are the rules:

For es.xml collation_type="standard" (not "traditional"):

Ñ > N

This passage in the CLDR for collation_type="standard" is hard to understand:
For our limited purpose, it appears we must say Æ = A.

The complete character list

See section "The complete character list" in
WL#5170 Swedish collation. The only different
weights are for the characters Æ Ñ
as described in section "Rules" above,
and we won't use any of the Swedish tailoring.

Some Problems

Before we can accept this task, we need to agree:
* The "Principles" agreed for WL#5170 are okay generally.
* The "Rules" section above correctly reflects CLDR es.xml
* The CLDR es.xml does not contain errors.