Character Sets and Collations

Simply put, a character set defines how and which characters are stored to support a particular language or languages. A collation, on the other hand, defines the order used when comparing strings (i.e. the position of any given character within the alphabet of that language)

Title Description
Character Set and Collation Overview Introduction to character sets and collations.
Supported Character Sets and Collations MariaDB supports the following character sets and collations.
Setting Character Sets and Collations Changing from the default character set and collation.
Unicode Unicode support.
SHOW CHARACTER SET Available character sets.
SHOW COLLATION Supported collations.
Information Schema CHARACTER_SETS Table Supported character sets.
Information Schema COLLATIONS Table Supported collations.
Internationalization and Localization Character sets, collations, time zones and locales.
SET CHARACTER SET Maps all strings sent between the current client and the server with the given mapping.
SET NAMES The character set used to send statements to the server, and results back to the client.
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.