[ < ] [ > ]   [ << ] [ Up ] [ >> ]         [Top] [Contents] [Index] [ ? ]

8.2 Character Sets and Collations in MySQL

A character set always has at least one collation. It may have several collations.

For example, character set latin1 ("ISO-8859-1 West European") has the following collations:

Collation

Meaning

latin1_bin

Binary according to latin1 encoding

latin1_danish_ci

Danish/Norwegian

latin1_german1_ci

German DIN-1

latin1_german2_ci

German DIN-2

latin1_swedish_ci

Swedish/Finnish

latin1_general_ci

Multilingual

Notes:

Notice that there is a convention for collation names: They start with the name of the character set they are associated with, they usually include a language name, and they end with _ci (case insensitive), _cs (case sensitive), or _bin (binary).


[ < ] [ > ]   [ << ] [ Up ] [ >> ]


Hosting by: Hurra Communications Ltd.
Generated: 2007-01-26 17:58:46