Character Sets for MariaDB Community Server 10.6

Overview

MariaDB Community Server supports many different character sets.

Reference material is available for MariaDB Community Server 10.6.

Character Sets for MariaDB Community Server 10.6

The following character sets are supported by MariaDB Community Server 10.6:

Charset

Default Collation

Max Len (Bytes)

Comments

armscii8

armscii8_general_ci

1

ARMSCII-8 Armenian

ascii

ascii_general_ci

1

US ASCII

big5

big5_chinese_ci

2

Big5 Traditional Chinese

binary

binary

1

Binary pseudo charset

cp850

cp850_general_ci

1

DOS West European

cp852

cp852_general_ci

1

DOS Central European

cp866

cp866_general_ci

1

DOS Russian

cp932

cp932_japanese_ci

2

SJIS for Windows Japanese

cp1250

cp1250_general_ci

1

Windows Central European

cp1251

cp1251_general_ci

1

Windows Cyrillic

cp1256

cp1256_general_ci

1

Windows Arabic

cp1257

cp1257_general_ci

1

Windows Baltic

dec8

dec8_swedish_ci

1

DEC West European

eucjpms

eucjpms_japanese_ci

3

UJIS for Windows Japanese

euckr

euckr_korean_ci

2

EUC-KR Korean

gb2312

gb2312_chinese_ci

2

GB2312 Simplified Chinese

gbk

gbk_chinese_ci

2

GBK Simplified Chinese

geostd8

geostd8_general_ci

1

GEOSTD8 Georgian

greek

greek_general_ci

1

ISO 8859-7 Greek

hebrew

hebrew_general_ci

1

ISO 8859-8 Hebrew

hp8

hp8_english_ci

1

HP West European

keybcs2

keybcs2_general_ci

1

DOS Kamenicky Czech-Slovak

koi8r

koi8r_general_ci

1

KOI8-R Relcom Russian

koi8u

koi8u_general_ci

1

KOI8-U Ukrainian

latin1

latin1_swedish_ci

1

cp1252 West European

latin2

latin2_general_ci

1

ISO 8859-2 Central European

latin5

latin5_turkish_ci

1

ISO 8859-9 Turkish

latin7

latin7_general_ci

1

ISO 8859-13 Baltic

macce

macce_general_ci

1

Mac Central European

macroman

macroman_general_ci

1

Mac West European

sjis

sjis_japanese_ci

2

Shift-JIS Japanese

swe7

swe7_swedish_ci

1

7bit Swedish

tis620

tis620_thai_ci

1

TIS620 Thai

ucs2

ucs2_general_ci

2

UCS-2 Unicode

ujis

ujis_japanese_ci

3

EUC-JP Japanese

utf8

utf8mb3_general_ci

3

UTF-8 Unicode

utf8mb3

utf8mb3_general_ci

3

UTF-8 Unicode

utf8mb4

utf8mb4_general_ci

4

UTF-8 Unicode

utf16

utf16_general_ci

4

UTF-16 Unicode

utf16le

utf16le_general_ci

4

UTF-16LE Unicode

utf32

utf32_general_ci

4

UTF-32 Unicode

To see character sets supported in other versions, see "Character Sets by MariaDB Server Version".