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) collations:
latin1is the default character set. MySQL's
latin1is the same as the Windows
cp1252character set. This means it is the same as the official
ISO 8859-1or IANA (Internet Assigned Numbers Authority)
latin1, except that IANA
latin1treats the code points between
0x9fas “undefined,” whereas
cp1252, and therefore MySQL's
latin1, assign characters for those positions. For example,
0x80is the Euro sign. For the “undefined” entries in
cp1252, MySQL translates
latin1_swedish_cicollation 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_cicollations 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 22.214.171.124, “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) collations:
swe7(7bit Swedish) collations: