Central European Character Sets • latin1_general_ci • latin1_german1_ci • latin1_general_cs • latin1_spanish_ci • latin1_german2_ci • latin1_swedish_ci  (default) MySQL’s  latin1  is the same as the Windows  cp1252  character set. This means it is the same as the official  ISO 8859-1  or IANA (Internet Assigned Numbers Authority)  latin1 , except that IANA latin1  treats the code points between  0x80  and  0x9f  as “undefined,”  whereas  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  0x0081 ,  0x8d  to  0x008d ,  0x8f  to 0x008f ,  0x90  to  0x0090 , and  0x9d  to  0x009d . The  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. The  latin1_german1_ci  and  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.8.6, “Examples of the Effect of Collation” . • latin1_german2_ci  (phone-book) rules: • latin1_german1_ci  (dictionary) rules: ˜ = A Ö = O Ü = U ß = s ˜ = AE Ö = OE Ü = UE ß = ss In the  latin1_spanish_ci  collation,  æ  (n-tilde) is a separate letter between  n  and  o . • macroman  (Mac West European) collations: • macroman_bin • macroman_general_ci  (default) • swe7  (7bit Swedish) collations: • swe7_bin • swe7_swedish_ci  (default) 10.10.3 Central European Character Sets 1978