(mysql.info.gz) Charset-we-sets
Info Catalog
(mysql.info.gz) Charset-Unicode-sets
(mysql.info.gz) Charset-charsets
(mysql.info.gz) Charset-ce-sets
10.11.2 West European Character Sets
------------------------------------
West 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:
* `ascii_bin'
* `ascii_general_ci' (default)
* `cp850' (DOS West European) collations:
* `cp850_bin'
* `cp850_general_ci' (default)
* `dec8' (DEC West European) collations:
* `dec8_bin'
* `dec8_swedish_ci' (default)
* `hp8' (HP West European) collations:
* `hp8_bin'
* `hp8_english_ci' (default)
* `latin1' (ISO 8859-1 West European) collations:
* `latin1_bin'
* `latin1_danish_ci'
* `latin1_general_ci'
* `latin1_general_cs'
* `latin1_german1_ci'
* `latin1_german2_ci'
* `latin1_spanish_ci'
* `latin1_swedish_ci' (default)
The `latin1' is the default character set. The
`latin1_swedish_ci' collation is the default that probably is used
by the majority of MySQL customers. It is constantly stated that
this is based on the Swedish/Finnish collation rules, but you will
find Swedes and Finns who disagree with that 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 fu"r Normung (that is, the German answer to
ANSI). DIN-1 is called the dictionary collation and DIN-2 is
called the phone-book collation.
* `latin1_german1_ci' (dictionary) rules:
A" = A
O" = O
U" = U
ss = s
* `latin1_german2_ci' (phone-book) rules:
A" = AE
O" = OE
U" = UE
ss = ss
In the `latin1_spanish_ci' collation, `N~' (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)
Info Catalog
(mysql.info.gz) Charset-Unicode-sets
(mysql.info.gz) Charset-charsets
(mysql.info.gz) Charset-ce-sets
automatically generated byinfo2html