Collations
This page is part of MariaDB's MariaDB Documentation.
The parent of this page is: Localization
Topics on this page:
Overview
A collation is a set of rules for sorting and comparing character sets.
MariaDB SkySQL supports many collations.
Example of Collation
As an example, consider a list of names. The character set defines which characters can appear in each name. The collation defines the order in which the names would be sorted, and whether two names would be equal:
In a case-insensitive collation, "Mueller" and "mueller" would be considered the same name.
In a case-sensitive collation, "Mueller" and "mueller" would be considered different names.
In a German collation, "Mueller" and "Müller" would be considered the same name.
In an English collation, "Mueller" and "Müller" would be considered different names.
In a collation that ignores padding, "Mueller" and "Mueller " would be considered the same name.
In a no-pad collation, "Mueller" and "Mueller " would be considered different names.
Supported Collations
For the full list of supported collations, see:
MariaDB Enterprise Server 10.6 (Multi-Node Analytics, Replicated Transactions, Single Node Analytics, Single Node Transactions)
MariaDB Enterprise Server 10.5 (Multi-Node Analytics, Replicated Transactions, Single Node Analytics, Single Node Transactions)
MariaDB Enterprise Server 10.4 (Multi-Node Analytics, Replicated Transactions, Single Node Analytics, Single Node Transactions)
Using Collations
For details on how to use collations, see:
MariaDB Enterprise Server (Multi-Node Analytics, Replicated Transactions, Single Node Analytics, Single Node Transactions)