DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(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