Western European character sets cover most West European languages, such as French, Spanish, Catalan, Basque, Portuguese, Italian, Albanian, Dutch, German, Danish, Swedish, Norwegian, Finnish, Faroese, Icelandic, Irish, Scottish, and English.
ascii (US ASCII) collations:
cp850 (DOS West European) collations:
dec8 (DEC Western European) collations:
hp8 (HP Western European) collations:
latin1 (cp1252 West European)
latin1 is the default character set.
latin1 is the same as the
cp1252 character set. This
means it is the same as the official
8859-1 or IANA (Internet Assigned Numbers
latin1, except that IANA
latin1 treats the code points between
cp1252, and therefore MySQL's
latin1, assign characters for those
positions. For example,
0x80 is the
Euro sign. For the “undefined” entries in
cp1252, MySQL translates
0x81 to Unicode
latin1_swedish_ci collation is the
default that probably is used by the majority of MySQL
customers. Although it is frequently said that it is based
on the Swedish/Finnish collation rules, there are Swedes
and Finns who disagree with this statement.
latin1_german2_ci collations are based
on the DIN-1 and DIN-2 standards, where DIN stands for
Deutsches Institut für
Normung (the German equivalent of ANSI).
DIN-1 is called the “dictionary collation”
and DIN-2 is called the “phone book
collation.” For an example of the effect this has
in comparisons or when doing searches, see
Section 10.1.7.8, “Examples of the Effect of Collation”.
Ä = A Ö = O Ü = U ß = s
Ä = AE Ö = OE Ü = UE ß = ss
ñ” (n-tilde) is a
separate letter between
macroman (Mac West European)
swe7 (7bit Swedish) collations: