Display MySQL and MariaDB server character sets and collations
||This module a part of the host administration|
This module displays the character sets available on connected servers and their associated collations.
The maximum memory required for the character encoding is given in bytes per character.
|big5||Big5 Traditional Chinese|
|binary||Binary pseudo charset|
|cp1250||Windows Central European|
|cp850||DOS West European|
|cp852||DOS Central European|
|cp932||SJIS for Windows Japanese|
|dec8||DEC West European|
|eucjpms||UJIS for Windows Japanese|
|gb18030||China National Standard GB18030|
|gb2312||GB2312 Simplified Chinese|
|gbk||GBK Simplified Chinese|
|greek||ISO 8859-7 Greek|
|hebrew||ISO 8859-8 Hebrew|
|hp8||HP West European|
|keybcs2||DOS Kamenicky Czech-Slovak|
|koi8r||KOI8-R Relcom Russian|
|latin1||cp1252 West European|
|latin2||ISO 8859-2 Central European|
|latin5||ISO 8859-9 Turkish|
|latin7||ISO 8859-13 Baltic|
|macce||Mac Central European|
|macroman||Mac West European|
|MySQL and MariaDB character sets and collations are used to define how the server stores and compares string data. A character set is a set of symbols and encodings used to represent characters in a database. MySQL and MariaDB support various character sets, including UTF-8, ASCII, ISO-8859 and more...|
A collation is a set of rules used to compare characters in a character set. Collations can define the order in which characters are sorted, whether uppercase and lowercase letters are treated the same, and how diacritics should be treated.
If a new MySQL or MariaDB database is to be created, a default character set and default collation for the database, tables and columns can be specified. The default character set for MySQL and MariaDB is UTF-8 and the default collation is utf8mb4_general_ci. Choosing a character set for your database should consider the type of data to be stored and the languages and scripts to be used. For example, if data is stored in multiple languages, a Unicode character set such as UTF-8 should be chosen.
Choosing a collation should consider how you want to compare and sort string data. For example, utf8mb4_general_ci is a case-insensitive collation and treats the accented characters as equal, while utf8mb4_bin is a case-sensitive collation and treats the accented characters as different.
The choice of character set and collation can affect the performance of your MySQL or MariaDB server. For example, using a Unicode character set such as UTF-8 can require more storage space than a single-byte character set, and using a case-sensitive collation can affect affect the performance of certain query types.
Choosing the appropriate character set and collation can ensure that the database works as expected and performs optimally.
|If no sorting is selected for a character set, the default sorting is used|