All Available Character Sets in MariaDB

The following table is a full list of character sets available in MariaDB.

Character Sets	Description	Default Collation
`big5`	Big5 Traditional Chinese	big5_chinese_ci
`dec8`	DEC West European	dec8_swedish_ci
`cp850`	DOS West European	cp850_general_ci
`hp8`	HP West European	hp8_english_ci
`koi8r`	KOI8-R Relcom Russian	koi8r_general_ci
`latin1`	cp1252 West European	latin1_swedish_ci
`latin2`	ISO 8859-2 Central European	latin2_general_ci
`swe7`	7bit Swedish	swe7_swedish_ci
`ascii`	US ASCII	ascii_general_ci
`ujis`	EUC-JP Japanese	ujis_japanese_ci
`sjis`	Shift-JIS Japanese	sjis_japanese_ci
`hebrew`	ISO 8859-8 Hebrew	hebrew_general_ci
`tis620`	TIS620 Thai	tis620_thai_ci
`euckr`	EUC-KR Korean	euckr_korean_ci
`koi8u`	KOI8-U Ukrainian	koi8u_general_ci
`gb2312`	GB2312 Simplified Chinese	gb2312_chinese_ci
`greek`	ISO 8859-7 Greek	greek_general_ci
`cp1250`	Windows Central European	cp1250_general_ci
`gbk`	GBK Simplified Chinese	gbk_chinese_ci
`latin5`	ISO 8859-9 Turkish	latin5_turkish_ci
`armscii8`	ARMSCII-8 Armenian	armscii8_general_ci
`utf8`	UTF-8 Unicode	utf8_general_ci
`ucs2`	UCS-2 Unicode	ucs2_general_ci
`cp866`	DOS Russian	cp866_general_ci
`keybcs2`	DOS Kamenicky Czech-Slovak	keybcs2_general_ci
`macce`	Mac Central European	macce_general_ci
`macroman`	Mac West European	macroman_general_ci
`cp852`	DOS Central European	cp852_general_ci
`latin7`	ISO 8859-13 Baltic	latin7_general_ci
`utf8mb4`	UTF-8 Unicode	utf8mb4_general_ci
`cp1251`	Windows Cyrillic	cp1251_general_ci
`utf16`	UTF-16 Unicode	utf16_general_ci
`utf16le`	UTF-16LE Unicode	utf16le_general_ci
`cp1256`	Windows Arabic	cp1256_general_ci
`cp1257`	Windows Baltic	cp1257_general_ci
`utf32`	UTF-32 Unicode	utf32_general_ci
`binary`	Binary pseudo charset	binary
`geostd8`	GEOSTD8 Georgian	geostd8_general_ci
`cp932`	SJIS for Windows Japanese	cp932_japanese_ci
`eucjpms`	UJIS for Windows Japanese	eucjpms_japanese_ci

You can asle get the full list of character sets by running the following command:

SHOW CHARACTER SET;

Output:

+----------+-----------------------------+---------------------+--------+
| Charset  | Description                 | Default collation   | Maxlen |
+----------+-----------------------------+---------------------+--------+
| big5     | Big5 Traditional Chinese    | big5_chinese_ci     |      2 |
| dec8     | DEC West European           | dec8_swedish_ci     |      1 |
| cp850    | DOS West European           | cp850_general_ci    |      1 |
| hp8      | HP West European            | hp8_english_ci      |      1 |
| koi8r    | KOI8-R Relcom Russian       | koi8r_general_ci    |      1 |
| latin1   | cp1252 West European        | latin1_swedish_ci   |      1 |
| latin2   | ISO 8859-2 Central European | latin2_general_ci   |      1 |
| swe7     | 7bit Swedish                | swe7_swedish_ci     |      1 |
| ascii    | US ASCII                    | ascii_general_ci    |      1 |
| ujis     | EUC-JP Japanese             | ujis_japanese_ci    |      3 |
| sjis     | Shift-JIS Japanese          | sjis_japanese_ci    |      2 |
| hebrew   | ISO 8859-8 Hebrew           | hebrew_general_ci   |      1 |
| tis620   | TIS620 Thai                 | tis620_thai_ci      |      1 |
| euckr    | EUC-KR Korean               | euckr_korean_ci     |      2 |
| koi8u    | KOI8-U Ukrainian            | koi8u_general_ci    |      1 |
| gb2312   | GB2312 Simplified Chinese   | gb2312_chinese_ci   |      2 |
| greek    | ISO 8859-7 Greek            | greek_general_ci    |      1 |
| cp1250   | Windows Central European    | cp1250_general_ci   |      1 |
| gbk      | GBK Simplified Chinese      | gbk_chinese_ci      |      2 |
| latin5   | ISO 8859-9 Turkish          | latin5_turkish_ci   |      1 |
| armscii8 | ARMSCII-8 Armenian          | armscii8_general_ci |      1 |
| utf8     | UTF-8 Unicode               | utf8_general_ci     |      3 |
| ucs2     | UCS-2 Unicode               | ucs2_general_ci     |      2 |
| cp866    | DOS Russian                 | cp866_general_ci    |      1 |
| keybcs2  | DOS Kamenicky Czech-Slovak  | keybcs2_general_ci  |      1 |
| macce    | Mac Central European        | macce_general_ci    |      1 |
| macroman | Mac West European           | macroman_general_ci |      1 |
| cp852    | DOS Central European        | cp852_general_ci    |      1 |
| latin7   | ISO 8859-13 Baltic          | latin7_general_ci   |      1 |
| utf8mb4  | UTF-8 Unicode               | utf8mb4_general_ci  |      4 |
| cp1251   | Windows Cyrillic            | cp1251_general_ci   |      1 |
| utf16    | UTF-16 Unicode              | utf16_general_ci    |      4 |
| utf16le  | UTF-16LE Unicode            | utf16le_general_ci  |      4 |
| cp1256   | Windows Arabic              | cp1256_general_ci   |      1 |
| cp1257   | Windows Baltic              | cp1257_general_ci   |      1 |
| utf32    | UTF-32 Unicode              | utf32_general_ci    |      4 |
| binary   | Binary pseudo charset       | binary              |      1 |
| geostd8  | GEOSTD8 Georgian            | geostd8_general_ci  |      1 |
| cp932    | SJIS for Windows Japanese   | cp932_japanese_ci   |      2 |
| eucjpms  | UJIS for Windows Japanese   | eucjpms_japanese_ci |      3 |
+----------+-----------------------------+---------------------+--------+
40 rows in set (0.001 sec)

On this page