Collations for MariaDB Community Server 10.5

Overview

MariaDB Community Server 10.5 supports many different collations.

Reference material is available for MariaDB Community Server 10.5.

Collations for MariaDB Community Server 10.5

The following collations are supported by MariaDB Community Server 10.5:

Collation

Charset

ID

Is Default

Is Compiled

Sort Len

Comments

armscii8_bin

armscii8

64

Yes

1

A collation for the armscii8 character set.

armscii8_general_ci

armscii8

32

Yes

Yes

1

A collation for the armscii8 character set.

armscii8_general_nopad_ci

armscii8

1056

Yes

1

A collation for the armscii8 character set.

armscii8_nopad_bin

armscii8

1088

Yes

1

A collation for the armscii8 character set.

ascii_bin

ascii

65

Yes

1

A collation for the ascii character set.

ascii_general_ci

ascii

11

Yes

Yes

1

A collation for the ascii character set.

ascii_general_nopad_ci

ascii

1035

Yes

1

A collation for the ascii character set.

ascii_nopad_bin

ascii

1089

Yes

1

A collation for the ascii character set.

big5_bin

big5

84

Yes

1

A collation for the big5 character set.

big5_chinese_ci

big5

1

Yes

Yes

1

A collation for the big5 character set.

big5_chinese_nopad_ci

big5

1025

Yes

1

A collation for the big5 character set.

big5_nopad_bin

big5

1108

Yes

1

A collation for the big5 character set.

binary

binary

63

Yes

Yes

1

A collation for the binary character set.

cp850_bin

cp850

80

Yes

1

A collation for the cp850 character set.

cp850_general_ci

cp850

4

Yes

Yes

1

A collation for the cp850 character set.

cp850_general_nopad_ci

cp850

1028

Yes

1

A collation for the cp850 character set.

cp850_nopad_bin

cp850

1104

Yes

1

A collation for the cp850 character set.

cp852_bin

cp852

81

Yes

1

A collation for the cp852 character set.

cp852_general_ci

cp852

40

Yes

Yes

1

A collation for the cp852 character set.

cp852_general_nopad_ci

cp852

1064

Yes

1

A collation for the cp852 character set.

cp852_nopad_bin

cp852

1105

Yes

1

A collation for the cp852 character set.

cp866_bin

cp866

68

Yes

1

A collation for the cp866 character set.

cp866_general_ci

cp866

36

Yes

Yes

1

A collation for the cp866 character set.

cp866_general_nopad_ci

cp866

1060

Yes

1

A collation for the cp866 character set.

cp866_nopad_bin

cp866

1092

Yes

1

A collation for the cp866 character set.

cp932_bin

cp932

96

Yes

1

A collation for the cp932 character set.

cp932_japanese_ci

cp932

95

Yes

Yes

1

A collation for the cp932 character set.

cp932_japanese_nopad_ci

cp932

1119

Yes

1

A collation for the cp932 character set.

cp932_nopad_bin

cp932

1120

Yes

1

A collation for the cp932 character set.

cp1250_bin

cp1250

66

Yes

1

A collation for the cp1250 character set.

cp1250_croatian_ci

cp1250

44

Yes

1

A collation for the cp1250 character set.

cp1250_czech_cs

cp1250

34

Yes

2

A collation for the cp1250 character set.

cp1250_general_ci

cp1250

26

Yes

Yes

1

A collation for the cp1250 character set.

cp1250_general_nopad_ci

cp1250

1050

Yes

1

A collation for the cp1250 character set.

cp1250_nopad_bin

cp1250

1090

Yes

1

A collation for the cp1250 character set.

cp1250_polish_ci

cp1250

99

Yes

1

A collation for the cp1250 character set.

cp1251_bin

cp1251

50

Yes

1

A collation for the cp1251 character set.

cp1251_bulgarian_ci

cp1251

14

Yes

1

A collation for the cp1251 character set.

cp1251_general_ci

cp1251

51

Yes

Yes

1

A collation for the cp1251 character set.

cp1251_general_cs

cp1251

52

Yes

1

A collation for the cp1251 character set.

cp1251_general_nopad_ci

cp1251

1075

Yes

1

A collation for the cp1251 character set.

cp1251_nopad_bin

cp1251

1074

Yes

1

A collation for the cp1251 character set.

cp1251_ukrainian_ci

cp1251

23

Yes

1

A collation for the cp1251 character set.

cp1256_bin

cp1256

67

Yes

1

A collation for the cp1256 character set.

cp1256_general_ci

cp1256

57

Yes

Yes

1

A collation for the cp1256 character set.

cp1256_general_nopad_ci

cp1256

1081

Yes

1

A collation for the cp1256 character set.

cp1256_nopad_bin

cp1256

1091

Yes

1

A collation for the cp1256 character set.

cp1257_bin

cp1257

58

Yes

1

A collation for the cp1257 character set.

cp1257_general_ci

cp1257

59

Yes

Yes

1

A collation for the cp1257 character set.

cp1257_general_nopad_ci

cp1257

1083

Yes

1

A collation for the cp1257 character set.

cp1257_lithuanian_ci

cp1257

29

Yes

1

A collation for the cp1257 character set.

cp1257_nopad_bin

cp1257

1082

Yes

1

A collation for the cp1257 character set.

dec8_bin

dec8

69

Yes

1

A collation for the dec8 character set.

dec8_nopad_bin

dec8

1093

Yes

1

A collation for the dec8 character set.

dec8_swedish_ci

dec8

3

Yes

Yes

1

A collation for the dec8 character set.

dec8_swedish_nopad_ci

dec8

1027

Yes

1

A collation for the dec8 character set.

eucjpms_bin

eucjpms

98

Yes

1

A collation for the eucjpms character set.

eucjpms_japanese_ci

eucjpms

97

Yes

Yes

1

A collation for the eucjpms character set.

eucjpms_japanese_nopad_ci

eucjpms

1121

Yes

1

A collation for the eucjpms character set.

eucjpms_nopad_bin

eucjpms

1122

Yes

1

A collation for the eucjpms character set.

euckr_bin

euckr

85

Yes

1

A collation for the euckr character set.

euckr_korean_ci

euckr

19

Yes

Yes

1

A collation for the euckr character set.

euckr_korean_nopad_ci

euckr

1043

Yes

1

A collation for the euckr character set.

euckr_nopad_bin

euckr

1109

Yes

1

A collation for the euckr character set.

gb2312_bin

gb2312

86

Yes

1

A collation for the gb2312 character set.

gb2312_chinese_ci

gb2312

24

Yes

Yes

1

A collation for the gb2312 character set.

gb2312_chinese_nopad_ci

gb2312

1048

Yes

1

A collation for the gb2312 character set.

gb2312_nopad_bin

gb2312

1110

Yes

1

A collation for the gb2312 character set.

gbk_bin

gbk

87

Yes

1

A collation for the gbk character set.

gbk_chinese_ci

gbk

28

Yes

Yes

1

A collation for the gbk character set.

gbk_chinese_nopad_ci

gbk

1052

Yes

1

A collation for the gbk character set.

gbk_nopad_bin

gbk

1111

Yes

1

A collation for the gbk character set.

geostd8_bin

geostd8

93

Yes

1

A collation for the geostd8 character set.

geostd8_general_ci

geostd8

92

Yes

Yes

1

A collation for the geostd8 character set.

geostd8_general_nopad_ci

geostd8

1116

Yes

1

A collation for the geostd8 character set.

geostd8_nopad_bin

geostd8

1117

Yes

1

A collation for the geostd8 character set.

greek_bin

greek

70

Yes

1

A collation for the greek character set.

greek_general_ci

greek

25

Yes

Yes

1

A collation for the greek character set.

greek_general_nopad_ci

greek

1049

Yes

1

A collation for the greek character set.

greek_nopad_bin

greek

1094

Yes

1

A collation for the greek character set.

hebrew_bin

hebrew

71

Yes

1

A collation for the hebrew character set.

hebrew_general_ci

hebrew

16

Yes

Yes

1

A collation for the hebrew character set.

hebrew_general_nopad_ci

hebrew

1040

Yes

1

A collation for the hebrew character set.

hebrew_nopad_bin

hebrew

1095

Yes

1

A collation for the hebrew character set.

hp8_bin

hp8

72

Yes

1

A collation for the hp8 character set.

hp8_english_ci

hp8

6

Yes

Yes

1

A collation for the hp8 character set.

hp8_english_nopad_ci

hp8

1030

Yes

1

A collation for the hp8 character set.

hp8_nopad_bin

hp8

1096

Yes

1

A collation for the hp8 character set.

keybcs2_bin

keybcs2

73

Yes

1

A collation for the keybcs2 character set.

keybcs2_general_ci

keybcs2

37

Yes

Yes

1

A collation for the keybcs2 character set.

keybcs2_general_nopad_ci

keybcs2

1061

Yes

1

A collation for the keybcs2 character set.

keybcs2_nopad_bin

keybcs2

1097

Yes

1

A collation for the keybcs2 character set.

koi8r_bin

koi8r

74

Yes

1

A collation for the koi8r character set.

koi8r_general_ci

koi8r

7

Yes

Yes

1

A collation for the koi8r character set.

koi8r_general_nopad_ci

koi8r

1031

Yes

1

A collation for the koi8r character set.

koi8r_nopad_bin

koi8r

1098

Yes

1

A collation for the koi8r character set.

koi8u_bin

koi8u

75

Yes

1

A collation for the koi8u character set.

koi8u_general_ci

koi8u

22

Yes

Yes

1

A collation for the koi8u character set.

koi8u_general_nopad_ci

koi8u

1046

Yes

1

A collation for the koi8u character set.

koi8u_nopad_bin

koi8u

1099

Yes

1

A collation for the koi8u character set.

latin1_bin

latin1

47

Yes

1

A collation for the latin1 character set.

latin1_danish_ci

latin1

15

Yes

1

A collation for the latin1 character set.

latin1_general_ci

latin1

48

Yes

1

A collation for the latin1 character set.

latin1_general_cs

latin1

49

Yes

1

A collation for the latin1 character set.

latin1_german1_ci

latin1

5

Yes

1

A collation for the latin1 character set.

latin1_german2_ci

latin1

31

Yes

2

A collation for the latin1 character set.

latin1_nopad_bin

latin1

1071

Yes

1

A collation for the latin1 character set.

latin1_spanish_ci

latin1

94

Yes

1

A collation for the latin1 character set.

latin1_swedish_ci

latin1

8

Yes

Yes

1

A collation for the latin1 character set.

latin1_swedish_nopad_ci

latin1

1032

Yes

1

A collation for the latin1 character set.

latin2_bin

latin2

77

Yes

1

A collation for the latin2 character set.

latin2_croatian_ci

latin2

27

Yes

1

A collation for the latin2 character set.

latin2_czech_cs

latin2

2

Yes

4

A collation for the latin2 character set.

latin2_general_ci

latin2

9

Yes

Yes

1

A collation for the latin2 character set.

latin2_general_nopad_ci

latin2

1033

Yes

1

A collation for the latin2 character set.

latin2_hungarian_ci

latin2

21

Yes

1

A collation for the latin2 character set.

latin2_nopad_bin

latin2

1101

Yes

1

A collation for the latin2 character set.

latin5_bin

latin5

78

Yes

1

A collation for the latin5 character set.

latin5_nopad_bin

latin5

1102

Yes

1

A collation for the latin5 character set.

latin5_turkish_ci

latin5

30

Yes

Yes

1

A collation for the latin5 character set.

latin5_turkish_nopad_ci

latin5

1054

Yes

1

A collation for the latin5 character set.

latin7_bin

latin7

79

Yes

1

A collation for the latin7 character set.

latin7_estonian_cs

latin7

20

Yes

1

A collation for the latin7 character set.

latin7_general_ci

latin7

41

Yes

Yes

1

A collation for the latin7 character set.

latin7_general_cs

latin7

42

Yes

1

A collation for the latin7 character set.

latin7_general_nopad_ci

latin7

1065

Yes

1

A collation for the latin7 character set.

latin7_nopad_bin

latin7

1103

Yes

1

A collation for the latin7 character set.

macce_bin

macce

43

Yes

1

A collation for the macce character set.

macce_general_ci

macce

38

Yes

Yes

1

A collation for the macce character set.

macce_general_nopad_ci

macce

1062

Yes

1

A collation for the macce character set.

macce_nopad_bin

macce

1067

Yes

1

A collation for the macce character set.

macroman_bin

macroman

53

Yes

1

A collation for the macroman character set.

macroman_general_ci

macroman

39

Yes

Yes

1

A collation for the macroman character set.

macroman_general_nopad_ci

macroman

1063

Yes

1

A collation for the macroman character set.

macroman_nopad_bin

macroman

1077

Yes

1

A collation for the macroman character set.

sjis_bin

sjis

88

Yes

1

A collation for the sjis character set.

sjis_japanese_ci

sjis

13

Yes

Yes

1

A collation for the sjis character set.

sjis_japanese_nopad_ci

sjis

1037

Yes

1

A collation for the sjis character set.

sjis_nopad_bin

sjis

1112

Yes

1

A collation for the sjis character set.

swe7_bin

swe7

82

Yes

1

A collation for the swe7 character set.

swe7_nopad_bin

swe7

1106

Yes

1

A collation for the swe7 character set.

swe7_swedish_ci

swe7

10

Yes

Yes

1

A collation for the swe7 character set.

swe7_swedish_nopad_ci

swe7

1034

Yes

1

A collation for the swe7 character set.

tis620_bin

tis620

89

Yes

1

A collation for the tis620 character set.

tis620_nopad_bin

tis620

1113

Yes

1

A collation for the tis620 character set.

tis620_thai_ci

tis620

18

Yes

Yes

4

A collation for the tis620 character set.

tis620_thai_nopad_ci

tis620

1042

Yes

4

A collation for the tis620 character set.

ucs2_bin

ucs2

90

Yes

1

A collation for the ucs2 character set.

ucs2_croatian_ci

ucs2

640

Yes

8

A collation for the ucs2 character set.

ucs2_croatian_mysql561_ci

ucs2

149

Yes

8

A collation for the ucs2 character set.

ucs2_czech_ci

ucs2

138

Yes

8

A collation for the ucs2 character set.

ucs2_danish_ci

ucs2

139

Yes

8

A collation for the ucs2 character set.

ucs2_esperanto_ci

ucs2

145

Yes

8

A collation for the ucs2 character set.

ucs2_estonian_ci

ucs2

134

Yes

8

A collation for the ucs2 character set.

ucs2_general_ci

ucs2

35

Yes

Yes

1

A collation for the ucs2 character set.

ucs2_general_mysql500_ci

ucs2

159

Yes

1

A collation for the ucs2 character set.

ucs2_general_nopad_ci

ucs2

1059

Yes

1

A collation for the ucs2 character set.

ucs2_german2_ci

ucs2

148

Yes

8

A collation for the ucs2 character set.

ucs2_hungarian_ci

ucs2

146

Yes

8

A collation for the ucs2 character set.

ucs2_icelandic_ci

ucs2

129

Yes

8

A collation for the ucs2 character set.

ucs2_latvian_ci

ucs2

130

Yes

8

A collation for the ucs2 character set.

ucs2_lithuanian_ci

ucs2

140

Yes

8

A collation for the ucs2 character set.

ucs2_myanmar_ci

ucs2

641

Yes

8

A collation for the ucs2 character set.

ucs2_nopad_bin

ucs2

1114

Yes

1

A collation for the ucs2 character set.

ucs2_persian_ci

ucs2

144

Yes

8

A collation for the ucs2 character set.

ucs2_polish_ci

ucs2

133

Yes

8

A collation for the ucs2 character set.

ucs2_roman_ci

ucs2

143

Yes

8

A collation for the ucs2 character set.

ucs2_romanian_ci

ucs2

131

Yes

8

A collation for the ucs2 character set.

ucs2_sinhala_ci

ucs2

147

Yes

8

A collation for the ucs2 character set.

ucs2_slovak_ci

ucs2

141

Yes

8

A collation for the ucs2 character set.

ucs2_slovenian_ci

ucs2

132

Yes

8

A collation for the ucs2 character set.

ucs2_spanish2_ci

ucs2

142

Yes

8

A collation for the ucs2 character set.

ucs2_spanish_ci

ucs2

135

Yes

8

A collation for the ucs2 character set.

ucs2_swedish_ci

ucs2

136

Yes

8

A collation for the ucs2 character set.

ucs2_thai_520_w2

ucs2

642

Yes

4

A collation for the ucs2 character set.

ucs2_turkish_ci

ucs2

137

Yes

8

A collation for the ucs2 character set.

ucs2_unicode_520_ci

ucs2

150

Yes

8

A collation for the ucs2 character set.

ucs2_unicode_520_nopad_ci

ucs2

1174

Yes

8

A collation for the ucs2 character set.

ucs2_unicode_ci

ucs2

128

Yes

8

A collation for the ucs2 character set.

ucs2_unicode_nopad_ci

ucs2

1152

Yes

8

A collation for the ucs2 character set.

ucs2_vietnamese_ci

ucs2

151

Yes

8

A collation for the ucs2 character set.

ujis_bin

ujis

91

Yes

1

A collation for the ujis character set.

ujis_japanese_ci

ujis

12

Yes

Yes

1

A collation for the ujis character set.

ujis_japanese_nopad_ci

ujis

1036

Yes

1

A collation for the ujis character set.

ujis_nopad_bin

ujis

1115

Yes

1

A collation for the ujis character set.

utf8_bin

utf8

83

Yes

1

A collation for the utf8 character set.

utf8_croatian_ci

utf8

576

Yes

8

A collation for the utf8 character set.

utf8_croatian_mysql561_ci

utf8

213

Yes

8

A collation for the utf8 character set.

utf8_czech_ci

utf8

202

Yes

8

A collation for the utf8 character set.

utf8_danish_ci

utf8

203

Yes

8

A collation for the utf8 character set.

utf8_esperanto_ci

utf8

209

Yes

8

A collation for the utf8 character set.

utf8_estonian_ci

utf8

198

Yes

8

A collation for the utf8 character set.

utf8_general_ci

utf8

33

Yes

Yes

1

A collation for the utf8 character set.

utf8_general_mysql500_ci

utf8

223

Yes

1

A collation for the utf8 character set.

utf8_general_nopad_ci

utf8

1057

Yes

1

A collation for the utf8 character set.

utf8_german2_ci

utf8

212

Yes

8

A collation for the utf8 character set.

utf8_hungarian_ci

utf8

210

Yes

8

A collation for the utf8 character set.

utf8_icelandic_ci

utf8

193

Yes

8

A collation for the utf8 character set.

utf8_latvian_ci

utf8

194

Yes

8

A collation for the utf8 character set.

utf8_lithuanian_ci

utf8

204

Yes

8

A collation for the utf8 character set.

utf8_myanmar_ci

utf8

577

Yes

8

A collation for the utf8 character set.

utf8_nopad_bin

utf8

1107

Yes

1

A collation for the utf8 character set.

utf8_persian_ci

utf8

208

Yes

8

A collation for the utf8 character set.

utf8_polish_ci

utf8

197

Yes

8

A collation for the utf8 character set.

utf8_roman_ci

utf8

207

Yes

8

A collation for the utf8 character set.

utf8_romanian_ci

utf8

195

Yes

8

A collation for the utf8 character set.

utf8_sinhala_ci

utf8

211

Yes

8

A collation for the utf8 character set.

utf8_slovak_ci

utf8

205

Yes

8

A collation for the utf8 character set.

utf8_slovenian_ci

utf8

196

Yes

8

A collation for the utf8 character set.

utf8_spanish2_ci

utf8

206

Yes

8

A collation for the utf8 character set.

utf8_spanish_ci

utf8

199

Yes

8

A collation for the utf8 character set.

utf8_swedish_ci

utf8

200

Yes

8

A collation for the utf8 character set.

utf8_thai_520_w2

utf8

578

Yes

4

A collation for the utf8 character set.

utf8_turkish_ci

utf8

201

Yes

8

A collation for the utf8 character set.

utf8_unicode_520_ci

utf8

214

Yes

8

A collation for the utf8 character set.

utf8_unicode_520_nopad_ci

utf8

1238

Yes

8

A collation for the utf8 character set.

utf8_unicode_ci

utf8

192

Yes

8

A collation for the utf8 character set.

utf8_unicode_nopad_ci

utf8

1216

Yes

8

A collation for the utf8 character set.

utf8_vietnamese_ci

utf8

215

Yes

8

A collation for the utf8 character set.

utf8mb3_bin

utf8

83

Yes

1

A collation for the utf8 character set.

utf8mb3_croatian_ci

utf8

576

Yes

8

A collation for the utf8 character set.

utf8mb3_croatian_mysql561_ci

utf8

213

Yes

8

A collation for the utf8 character set.

utf8mb3_czech_ci

utf8

202

Yes

8

A collation for the utf8 character set.

utf8mb3_danish_ci

utf8

203

Yes

8

A collation for the utf8 character set.

utf8mb3_esperanto_ci

utf8

209

Yes

8

A collation for the utf8 character set.

utf8mb3_estonian_ci

utf8

198

Yes

8

A collation for the utf8 character set.

utf8mb3_general_ci

utf8

33

Yes

Yes

1

A collation for the utf8 character set.

utf8mb3_general_mysql500_ci

utf8

223

Yes

1

A collation for the utf8 character set.

utf8mb3_general_nopad_ci

utf8

1057

Yes

1

A collation for the utf8 character set.

utf8mb3_german2_ci

utf8

212

Yes

8

A collation for the utf8 character set.

utf8mb3_hungarian_ci

utf8

210

Yes

8

A collation for the utf8 character set.

utf8mb3_icelandic_ci

utf8

193

Yes

8

A collation for the utf8 character set.

utf8mb3_latvian_ci

utf8

194

Yes

8

A collation for the utf8 character set.

utf8mb3_lithuanian_ci

utf8

204

Yes

8

A collation for the utf8 character set.

utf8mb3_myanmar_ci

utf8

577

Yes

8

A collation for the utf8 character set.

utf8mb3_nopad_bin

utf8

1107

Yes

1

A collation for the utf8 character set.

utf8mb3_persian_ci

utf8

208

Yes

8

A collation for the utf8 character set.

utf8mb3_polish_ci

utf8

197

Yes

8

A collation for the utf8 character set.

utf8mb3_roman_ci

utf8

207

Yes

8

A collation for the utf8 character set.

utf8mb3_romanian_ci

utf8

195

Yes

8

A collation for the utf8 character set.

utf8mb3_sinhala_ci

utf8

211

Yes

8

A collation for the utf8 character set.

utf8mb3_slovak_ci

utf8

205

Yes

8

A collation for the utf8 character set.

utf8mb3_slovenian_ci

utf8

196

Yes

8

A collation for the utf8 character set.

utf8mb3_spanish2_ci

utf8

206

Yes

8

A collation for the utf8 character set.

utf8mb3_spanish_ci

utf8

199

Yes

8

A collation for the utf8 character set.

utf8mb3_swedish_ci

utf8

200

Yes

8

A collation for the utf8 character set.

utf8mb3_thai_520_w2

utf8

578

Yes

4

A collation for the utf8 character set.

utf8mb3_turkish_ci

utf8

201

Yes

8

A collation for the utf8 character set.

utf8mb3_unicode_520_ci

utf8

214

Yes

8

A collation for the utf8 character set.

utf8mb3_unicode_520_nopad_ci

utf8

1238

Yes

8

A collation for the utf8 character set.

utf8mb3_unicode_ci

utf8

192

Yes

8

A collation for the utf8 character set.

utf8mb3_unicode_nopad_ci

utf8

1216

Yes

8

A collation for the utf8 character set.

utf8mb3_vietnamese_ci

utf8

215

Yes

8

A collation for the utf8 character set.

utf8mb4_bin

utf8mb4

46

Yes

1

A collation for the utf8mb4 character set.

utf8mb4_croatian_ci

utf8mb4

608

Yes

8

A collation for the utf8mb4 character set.

utf8mb4_croatian_mysql561_ci

utf8mb4

245

Yes

8

A collation for the utf8mb4 character set.

utf8mb4_czech_ci

utf8mb4

234

Yes

8

A collation for the utf8mb4 character set.

utf8mb4_danish_ci

utf8mb4

235

Yes

8

A collation for the utf8mb4 character set.

utf8mb4_esperanto_ci

utf8mb4

241

Yes

8

A collation for the utf8mb4 character set.

utf8mb4_estonian_ci

utf8mb4

230

Yes

8

A collation for the utf8mb4 character set.

utf8mb4_general_ci

utf8mb4

45

Yes

Yes

1

A collation for the utf8mb4 character set.

utf8mb4_general_nopad_ci

utf8mb4

1069

Yes

1

A collation for the utf8mb4 character set.

utf8mb4_german2_ci

utf8mb4

244

Yes

8

A collation for the utf8mb4 character set.

utf8mb4_hungarian_ci

utf8mb4

242

Yes

8

A collation for the utf8mb4 character set.

utf8mb4_icelandic_ci

utf8mb4

225

Yes

8

A collation for the utf8mb4 character set.

utf8mb4_latvian_ci

utf8mb4

226

Yes

8

A collation for the utf8mb4 character set.

utf8mb4_lithuanian_ci

utf8mb4

236

Yes

8

A collation for the utf8mb4 character set.

utf8mb4_myanmar_ci

utf8mb4

609

Yes

8

A collation for the utf8mb4 character set.

utf8mb4_nopad_bin

utf8mb4

1070

Yes

1

A collation for the utf8mb4 character set.

utf8mb4_persian_ci

utf8mb4

240

Yes

8

A collation for the utf8mb4 character set.

utf8mb4_polish_ci

utf8mb4

229

Yes

8

A collation for the utf8mb4 character set.

utf8mb4_roman_ci

utf8mb4

239

Yes

8

A collation for the utf8mb4 character set.

utf8mb4_romanian_ci

utf8mb4

227

Yes

8

A collation for the utf8mb4 character set.

utf8mb4_sinhala_ci

utf8mb4

243

Yes

8

A collation for the utf8mb4 character set.

utf8mb4_slovak_ci

utf8mb4

237

Yes

8

A collation for the utf8mb4 character set.

utf8mb4_slovenian_ci

utf8mb4

228

Yes

8

A collation for the utf8mb4 character set.

utf8mb4_spanish2_ci

utf8mb4

238

Yes

8

A collation for the utf8mb4 character set.

utf8mb4_spanish_ci

utf8mb4

231

Yes

8

A collation for the utf8mb4 character set.

utf8mb4_swedish_ci

utf8mb4

232

Yes

8

A collation for the utf8mb4 character set.

utf8mb4_thai_520_w2

utf8mb4

610

Yes

4

A collation for the utf8mb4 character set.

utf8mb4_turkish_ci

utf8mb4

233

Yes

8

A collation for the utf8mb4 character set.

utf8mb4_unicode_520_ci

utf8mb4

246

Yes

8

A collation for the utf8mb4 character set.

utf8mb4_unicode_520_nopad_ci

utf8mb4

1270

Yes

8

A collation for the utf8mb4 character set.

utf8mb4_unicode_ci

utf8mb4

224

Yes

8

A collation for the utf8mb4 character set.

utf8mb4_unicode_nopad_ci

utf8mb4

1248

Yes

8

A collation for the utf8mb4 character set.

utf8mb4_vietnamese_ci

utf8mb4

247

Yes

8

A collation for the utf8mb4 character set.

utf16_bin

utf16

55

Yes

1

A collation for the utf16 character set.

utf16_croatian_ci

utf16

672

Yes

8

A collation for the utf16 character set.

utf16_croatian_mysql561_ci

utf16

122

Yes

8

A collation for the utf16 character set.

utf16_czech_ci

utf16

111

Yes

8

A collation for the utf16 character set.

utf16_danish_ci

utf16

112

Yes

8

A collation for the utf16 character set.

utf16_esperanto_ci

utf16

118

Yes

8

A collation for the utf16 character set.

utf16_estonian_ci

utf16

107

Yes

8

A collation for the utf16 character set.

utf16_general_ci

utf16

54

Yes

Yes

1

A collation for the utf16 character set.

utf16_general_nopad_ci

utf16

1078

Yes

1

A collation for the utf16 character set.

utf16_german2_ci

utf16

121

Yes

8

A collation for the utf16 character set.

utf16_hungarian_ci

utf16

119

Yes

8

A collation for the utf16 character set.

utf16_icelandic_ci

utf16

102

Yes

8

A collation for the utf16 character set.

utf16_latvian_ci

utf16

103

Yes

8

A collation for the utf16 character set.

utf16_lithuanian_ci

utf16

113

Yes

8

A collation for the utf16 character set.

utf16_myanmar_ci

utf16

673

Yes

8

A collation for the utf16 character set.

utf16_nopad_bin

utf16

1079

Yes

1

A collation for the utf16 character set.

utf16_persian_ci

utf16

117

Yes

8

A collation for the utf16 character set.

utf16_polish_ci

utf16

106

Yes

8

A collation for the utf16 character set.

utf16_roman_ci

utf16

116

Yes

8

A collation for the utf16 character set.

utf16_romanian_ci

utf16

104

Yes

8

A collation for the utf16 character set.

utf16_sinhala_ci

utf16

120

Yes

8

A collation for the utf16 character set.

utf16_slovak_ci

utf16

114

Yes

8

A collation for the utf16 character set.

utf16_slovenian_ci

utf16

105

Yes

8

A collation for the utf16 character set.

utf16_spanish2_ci

utf16

115

Yes

8

A collation for the utf16 character set.

utf16_spanish_ci

utf16

108

Yes

8

A collation for the utf16 character set.

utf16_swedish_ci

utf16

109

Yes

8

A collation for the utf16 character set.

utf16_thai_520_w2

utf16

674

Yes

4

A collation for the utf16 character set.

utf16_turkish_ci

utf16

110

Yes

8

A collation for the utf16 character set.

utf16_unicode_520_ci

utf16

123

Yes

8

A collation for the utf16 character set.

utf16_unicode_520_nopad_ci

utf16

1147

Yes

8

A collation for the utf16 character set.

utf16_unicode_ci

utf16

101

Yes

8

A collation for the utf16 character set.

utf16_unicode_nopad_ci

utf16

1125

Yes

8

A collation for the utf16 character set.

utf16_vietnamese_ci

utf16

124

Yes

8

A collation for the utf16 character set.

utf16le_bin

utf16le

62

Yes

1

A collation for the utf16le character set.

utf16le_general_ci

utf16le

56

Yes

Yes

1

A collation for the utf16le character set.

utf16le_general_nopad_ci

utf16le

1080

Yes

1

A collation for the utf16le character set.

utf16le_nopad_bin

utf16le

1086

Yes

1

A collation for the utf16le character set.

utf32_bin

utf32

61

Yes

1

A collation for the utf32 character set.

utf32_croatian_ci

utf32

736

Yes

8

A collation for the utf32 character set.

utf32_croatian_mysql561_ci

utf32

181

Yes

8

A collation for the utf32 character set.

utf32_czech_ci

utf32

170

Yes

8

A collation for the utf32 character set.

utf32_danish_ci

utf32

171

Yes

8

A collation for the utf32 character set.

utf32_esperanto_ci

utf32

177

Yes

8

A collation for the utf32 character set.

utf32_estonian_ci

utf32

166

Yes

8

A collation for the utf32 character set.

utf32_general_ci

utf32

60

Yes

Yes

1

A collation for the utf32 character set.

utf32_general_nopad_ci

utf32

1084

Yes

1

A collation for the utf32 character set.

utf32_german2_ci

utf32

180

Yes

8

A collation for the utf32 character set.

utf32_hungarian_ci

utf32

178

Yes

8

A collation for the utf32 character set.

utf32_icelandic_ci

utf32

161

Yes

8

A collation for the utf32 character set.

utf32_latvian_ci

utf32

162

Yes

8

A collation for the utf32 character set.

utf32_lithuanian_ci

utf32

172

Yes

8

A collation for the utf32 character set.

utf32_myanmar_ci

utf32

737

Yes

8

A collation for the utf32 character set.

utf32_nopad_bin

utf32

1085

Yes

1

A collation for the utf32 character set.

utf32_persian_ci

utf32

176

Yes

8

A collation for the utf32 character set.

utf32_polish_ci

utf32

165

Yes

8

A collation for the utf32 character set.

utf32_roman_ci

utf32

175

Yes

8

A collation for the utf32 character set.

utf32_romanian_ci

utf32

163

Yes

8

A collation for the utf32 character set.

utf32_sinhala_ci

utf32

179

Yes

8

A collation for the utf32 character set.

utf32_slovak_ci

utf32

173

Yes

8

A collation for the utf32 character set.

utf32_slovenian_ci

utf32

164

Yes

8

A collation for the utf32 character set.

utf32_spanish2_ci

utf32

174

Yes

8

A collation for the utf32 character set.

utf32_spanish_ci

utf32

167

Yes

8

A collation for the utf32 character set.

utf32_swedish_ci

utf32

168

Yes

8

A collation for the utf32 character set.

utf32_thai_520_w2

utf32

738

Yes

4

A collation for the utf32 character set.

utf32_turkish_ci

utf32

169

Yes

8

A collation for the utf32 character set.

utf32_unicode_520_ci

utf32

182

Yes

8

A collation for the utf32 character set.

utf32_unicode_520_nopad_ci

utf32

1206

Yes

8

A collation for the utf32 character set.

utf32_unicode_ci

utf32

160

Yes

8

A collation for the utf32 character set.

utf32_unicode_nopad_ci

utf32

1184

Yes

8

A collation for the utf32 character set.

utf32_vietnamese_ci

utf32

183

Yes

8

A collation for the utf32 character set.

To see collations supported in other versions, see "Collations by MariaDB Server Version".