mysql_common/
collations.rs

1/// MySql collation type.
2///
3/// Collected via:
4///
5/// ```sql
6/// SELECT CONCAT(
7///     UPPER(COLLATION_NAME), ' = ', ID, ','
8/// )
9/// FROM INFORMATION_SCHEMA.COLLATIONS
10/// ORDER BY ID;
11/// ```
12#[derive(Debug, Clone, Copy, PartialEq, Eq, Hash)]
13#[allow(non_camel_case_types)]
14#[repr(u16)]
15pub enum CollationId {
16    /// This is a stub
17    UNKNOWN_COLLATION_ID = 0,
18    BIG5_CHINESE_CI = 1,
19    LATIN2_CZECH_CS = 2,
20    DEC8_SWEDISH_CI = 3,
21    CP850_GENERAL_CI = 4,
22    LATIN1_GERMAN1_CI = 5,
23    HP8_ENGLISH_CI = 6,
24    KOI8R_GENERAL_CI = 7,
25    LATIN1_SWEDISH_CI = 8,
26    LATIN2_GENERAL_CI = 9,
27    SWE7_SWEDISH_CI = 10,
28    ASCII_GENERAL_CI = 11,
29    UJIS_JAPANESE_CI = 12,
30    SJIS_JAPANESE_CI = 13,
31    CP1251_BULGARIAN_CI = 14,
32    LATIN1_DANISH_CI = 15,
33    HEBREW_GENERAL_CI = 16,
34    TIS620_THAI_CI = 18,
35    EUCKR_KOREAN_CI = 19,
36    LATIN7_ESTONIAN_CS = 20,
37    LATIN2_HUNGARIAN_CI = 21,
38    KOI8U_GENERAL_CI = 22,
39    CP1251_UKRAINIAN_CI = 23,
40    GB2312_CHINESE_CI = 24,
41    GREEK_GENERAL_CI = 25,
42    CP1250_GENERAL_CI = 26,
43    LATIN2_CROATIAN_CI = 27,
44    GBK_CHINESE_CI = 28,
45    CP1257_LITHUANIAN_CI = 29,
46    LATIN5_TURKISH_CI = 30,
47    LATIN1_GERMAN2_CI = 31,
48    ARMSCII8_GENERAL_CI = 32,
49    UTF8MB3_GENERAL_CI = 33,
50    CP1250_CZECH_CS = 34,
51    UCS2_GENERAL_CI = 35,
52    CP866_GENERAL_CI = 36,
53    KEYBCS2_GENERAL_CI = 37,
54    MACCE_GENERAL_CI = 38,
55    MACROMAN_GENERAL_CI = 39,
56    CP852_GENERAL_CI = 40,
57    LATIN7_GENERAL_CI = 41,
58    LATIN7_GENERAL_CS = 42,
59    MACCE_BIN = 43,
60    CP1250_CROATIAN_CI = 44,
61    UTF8MB4_GENERAL_CI = 45,
62    UTF8MB4_BIN = 46,
63    LATIN1_BIN = 47,
64    LATIN1_GENERAL_CI = 48,
65    LATIN1_GENERAL_CS = 49,
66    CP1251_BIN = 50,
67    CP1251_GENERAL_CI = 51,
68    CP1251_GENERAL_CS = 52,
69    MACROMAN_BIN = 53,
70    UTF16_GENERAL_CI = 54,
71    UTF16_BIN = 55,
72    UTF16LE_GENERAL_CI = 56,
73    CP1256_GENERAL_CI = 57,
74    CP1257_BIN = 58,
75    CP1257_GENERAL_CI = 59,
76    UTF32_GENERAL_CI = 60,
77    UTF32_BIN = 61,
78    UTF16LE_BIN = 62,
79    BINARY = 63,
80    ARMSCII8_BIN = 64,
81    ASCII_BIN = 65,
82    CP1250_BIN = 66,
83    CP1256_BIN = 67,
84    CP866_BIN = 68,
85    DEC8_BIN = 69,
86    GREEK_BIN = 70,
87    HEBREW_BIN = 71,
88    HP8_BIN = 72,
89    KEYBCS2_BIN = 73,
90    KOI8R_BIN = 74,
91    KOI8U_BIN = 75,
92    UTF8MB3_TOLOWER_CI = 76,
93    LATIN2_BIN = 77,
94    LATIN5_BIN = 78,
95    LATIN7_BIN = 79,
96    CP850_BIN = 80,
97    CP852_BIN = 81,
98    SWE7_BIN = 82,
99    UTF8MB3_BIN = 83,
100    BIG5_BIN = 84,
101    EUCKR_BIN = 85,
102    GB2312_BIN = 86,
103    GBK_BIN = 87,
104    SJIS_BIN = 88,
105    TIS620_BIN = 89,
106    UCS2_BIN = 90,
107    UJIS_BIN = 91,
108    GEOSTD8_GENERAL_CI = 92,
109    GEOSTD8_BIN = 93,
110    LATIN1_SPANISH_CI = 94,
111    CP932_JAPANESE_CI = 95,
112    CP932_BIN = 96,
113    EUCJPMS_JAPANESE_CI = 97,
114    EUCJPMS_BIN = 98,
115    CP1250_POLISH_CI = 99,
116    UTF16_UNICODE_CI = 101,
117    UTF16_ICELANDIC_CI = 102,
118    UTF16_LATVIAN_CI = 103,
119    UTF16_ROMANIAN_CI = 104,
120    UTF16_SLOVENIAN_CI = 105,
121    UTF16_POLISH_CI = 106,
122    UTF16_ESTONIAN_CI = 107,
123    UTF16_SPANISH_CI = 108,
124    UTF16_SWEDISH_CI = 109,
125    UTF16_TURKISH_CI = 110,
126    UTF16_CZECH_CI = 111,
127    UTF16_DANISH_CI = 112,
128    UTF16_LITHUANIAN_CI = 113,
129    UTF16_SLOVAK_CI = 114,
130    UTF16_SPANISH2_CI = 115,
131    UTF16_ROMAN_CI = 116,
132    UTF16_PERSIAN_CI = 117,
133    UTF16_ESPERANTO_CI = 118,
134    UTF16_HUNGARIAN_CI = 119,
135    UTF16_SINHALA_CI = 120,
136    UTF16_GERMAN2_CI = 121,
137    UTF16_CROATIAN_CI = 122,
138    UTF16_UNICODE_520_CI = 123,
139    UTF16_VIETNAMESE_CI = 124,
140    UCS2_UNICODE_CI = 128,
141    UCS2_ICELANDIC_CI = 129,
142    UCS2_LATVIAN_CI = 130,
143    UCS2_ROMANIAN_CI = 131,
144    UCS2_SLOVENIAN_CI = 132,
145    UCS2_POLISH_CI = 133,
146    UCS2_ESTONIAN_CI = 134,
147    UCS2_SPANISH_CI = 135,
148    UCS2_SWEDISH_CI = 136,
149    UCS2_TURKISH_CI = 137,
150    UCS2_CZECH_CI = 138,
151    UCS2_DANISH_CI = 139,
152    UCS2_LITHUANIAN_CI = 140,
153    UCS2_SLOVAK_CI = 141,
154    UCS2_SPANISH2_CI = 142,
155    UCS2_ROMAN_CI = 143,
156    UCS2_PERSIAN_CI = 144,
157    UCS2_ESPERANTO_CI = 145,
158    UCS2_HUNGARIAN_CI = 146,
159    UCS2_SINHALA_CI = 147,
160    UCS2_GERMAN2_CI = 148,
161    UCS2_CROATIAN_CI = 149,
162    UCS2_UNICODE_520_CI = 150,
163    UCS2_VIETNAMESE_CI = 151,
164    UCS2_GENERAL_MYSQL500_CI = 159,
165    UTF32_UNICODE_CI = 160,
166    UTF32_ICELANDIC_CI = 161,
167    UTF32_LATVIAN_CI = 162,
168    UTF32_ROMANIAN_CI = 163,
169    UTF32_SLOVENIAN_CI = 164,
170    UTF32_POLISH_CI = 165,
171    UTF32_ESTONIAN_CI = 166,
172    UTF32_SPANISH_CI = 167,
173    UTF32_SWEDISH_CI = 168,
174    UTF32_TURKISH_CI = 169,
175    UTF32_CZECH_CI = 170,
176    UTF32_DANISH_CI = 171,
177    UTF32_LITHUANIAN_CI = 172,
178    UTF32_SLOVAK_CI = 173,
179    UTF32_SPANISH2_CI = 174,
180    UTF32_ROMAN_CI = 175,
181    UTF32_PERSIAN_CI = 176,
182    UTF32_ESPERANTO_CI = 177,
183    UTF32_HUNGARIAN_CI = 178,
184    UTF32_SINHALA_CI = 179,
185    UTF32_GERMAN2_CI = 180,
186    UTF32_CROATIAN_CI = 181,
187    UTF32_UNICODE_520_CI = 182,
188    UTF32_VIETNAMESE_CI = 183,
189    UTF8MB3_UNICODE_CI = 192,
190    UTF8MB3_ICELANDIC_CI = 193,
191    UTF8MB3_LATVIAN_CI = 194,
192    UTF8MB3_ROMANIAN_CI = 195,
193    UTF8MB3_SLOVENIAN_CI = 196,
194    UTF8MB3_POLISH_CI = 197,
195    UTF8MB3_ESTONIAN_CI = 198,
196    UTF8MB3_SPANISH_CI = 199,
197    UTF8MB3_SWEDISH_CI = 200,
198    UTF8MB3_TURKISH_CI = 201,
199    UTF8MB3_CZECH_CI = 202,
200    UTF8MB3_DANISH_CI = 203,
201    UTF8MB3_LITHUANIAN_CI = 204,
202    UTF8MB3_SLOVAK_CI = 205,
203    UTF8MB3_SPANISH2_CI = 206,
204    UTF8MB3_ROMAN_CI = 207,
205    UTF8MB3_PERSIAN_CI = 208,
206    UTF8MB3_ESPERANTO_CI = 209,
207    UTF8MB3_HUNGARIAN_CI = 210,
208    UTF8MB3_SINHALA_CI = 211,
209    UTF8MB3_GERMAN2_CI = 212,
210    UTF8MB3_CROATIAN_CI = 213,
211    UTF8MB3_UNICODE_520_CI = 214,
212    UTF8MB3_VIETNAMESE_CI = 215,
213    UTF8MB3_GENERAL_MYSQL500_CI = 223,
214    UTF8MB4_UNICODE_CI = 224,
215    UTF8MB4_ICELANDIC_CI = 225,
216    UTF8MB4_LATVIAN_CI = 226,
217    UTF8MB4_ROMANIAN_CI = 227,
218    UTF8MB4_SLOVENIAN_CI = 228,
219    UTF8MB4_POLISH_CI = 229,
220    UTF8MB4_ESTONIAN_CI = 230,
221    UTF8MB4_SPANISH_CI = 231,
222    UTF8MB4_SWEDISH_CI = 232,
223    UTF8MB4_TURKISH_CI = 233,
224    UTF8MB4_CZECH_CI = 234,
225    UTF8MB4_DANISH_CI = 235,
226    UTF8MB4_LITHUANIAN_CI = 236,
227    UTF8MB4_SLOVAK_CI = 237,
228    UTF8MB4_SPANISH2_CI = 238,
229    UTF8MB4_ROMAN_CI = 239,
230    UTF8MB4_PERSIAN_CI = 240,
231    UTF8MB4_ESPERANTO_CI = 241,
232    UTF8MB4_HUNGARIAN_CI = 242,
233    UTF8MB4_SINHALA_CI = 243,
234    UTF8MB4_GERMAN2_CI = 244,
235    UTF8MB4_CROATIAN_CI = 245,
236    UTF8MB4_UNICODE_520_CI = 246,
237    UTF8MB4_VIETNAMESE_CI = 247,
238    GB18030_CHINESE_CI = 248,
239    GB18030_BIN = 249,
240    GB18030_UNICODE_520_CI = 250,
241    UTF8MB4_0900_AI_CI = 255,
242    UTF8MB4_DE_PB_0900_AI_CI = 256,
243    UTF8MB4_IS_0900_AI_CI = 257,
244    UTF8MB4_LV_0900_AI_CI = 258,
245    UTF8MB4_RO_0900_AI_CI = 259,
246    UTF8MB4_SL_0900_AI_CI = 260,
247    UTF8MB4_PL_0900_AI_CI = 261,
248    UTF8MB4_ET_0900_AI_CI = 262,
249    UTF8MB4_ES_0900_AI_CI = 263,
250    UTF8MB4_SV_0900_AI_CI = 264,
251    UTF8MB4_TR_0900_AI_CI = 265,
252    UTF8MB4_CS_0900_AI_CI = 266,
253    UTF8MB4_DA_0900_AI_CI = 267,
254    UTF8MB4_LT_0900_AI_CI = 268,
255    UTF8MB4_SK_0900_AI_CI = 269,
256    UTF8MB4_ES_TRAD_0900_AI_CI = 270,
257    UTF8MB4_LA_0900_AI_CI = 271,
258    UTF8MB4_EO_0900_AI_CI = 273,
259    UTF8MB4_HU_0900_AI_CI = 274,
260    UTF8MB4_HR_0900_AI_CI = 275,
261    UTF8MB4_VI_0900_AI_CI = 277,
262    UTF8MB4_0900_AS_CS = 278,
263    UTF8MB4_DE_PB_0900_AS_CS = 279,
264    UTF8MB4_IS_0900_AS_CS = 280,
265    UTF8MB4_LV_0900_AS_CS = 281,
266    UTF8MB4_RO_0900_AS_CS = 282,
267    UTF8MB4_SL_0900_AS_CS = 283,
268    UTF8MB4_PL_0900_AS_CS = 284,
269    UTF8MB4_ET_0900_AS_CS = 285,
270    UTF8MB4_ES_0900_AS_CS = 286,
271    UTF8MB4_SV_0900_AS_CS = 287,
272    UTF8MB4_TR_0900_AS_CS = 288,
273    UTF8MB4_CS_0900_AS_CS = 289,
274    UTF8MB4_DA_0900_AS_CS = 290,
275    UTF8MB4_LT_0900_AS_CS = 291,
276    UTF8MB4_SK_0900_AS_CS = 292,
277    UTF8MB4_ES_TRAD_0900_AS_CS = 293,
278    UTF8MB4_LA_0900_AS_CS = 294,
279    UTF8MB4_EO_0900_AS_CS = 296,
280    UTF8MB4_HU_0900_AS_CS = 297,
281    UTF8MB4_HR_0900_AS_CS = 298,
282    UTF8MB4_VI_0900_AS_CS = 300,
283    UTF8MB4_JA_0900_AS_CS = 303,
284    UTF8MB4_JA_0900_AS_CS_KS = 304,
285    UTF8MB4_0900_AS_CI = 305,
286    UTF8MB4_RU_0900_AI_CI = 306,
287    UTF8MB4_RU_0900_AS_CS = 307,
288    UTF8MB4_ZH_0900_AS_CS = 308,
289    UTF8MB4_0900_BIN = 309,
290    UTF8MB4_NB_0900_AI_CI = 310,
291    UTF8MB4_NB_0900_AS_CS = 311,
292    UTF8MB4_NN_0900_AI_CI = 312,
293    UTF8MB4_NN_0900_AS_CS = 313,
294    UTF8MB4_SR_LATN_0900_AI_CI = 314,
295    UTF8MB4_SR_LATN_0900_AS_CS = 315,
296    UTF8MB4_BS_0900_AI_CI = 316,
297    UTF8MB4_BS_0900_AS_CS = 317,
298    UTF8MB4_BG_0900_AI_CI = 318,
299    UTF8MB4_BG_0900_AS_CS = 319,
300    UTF8MB4_GL_0900_AI_CI = 320,
301    UTF8MB4_GL_0900_AS_CS = 321,
302    UTF8MB4_MN_CYRL_0900_AI_CI = 322,
303    UTF8MB4_MN_CYRL_0900_AS_CS = 323,
304}
305
306impl From<u16> for CollationId {
307    /// u16 conversion.
308    ///
309    /// Unknown IDs will be mapped to [`CollationId::UNKNOWN_COLLATION_ID`].
310    ///
311    /// Collected via:
312    ///
313    /// ```sql
314    /// SELECT CONCAT(
315    ///     ID, ' => CollationId::', UPPER(COLLATION_NAME), ','
316    /// )
317    /// FROM INFORMATION_SCHEMA.COLLATIONS
318    /// ORDER BY ID;
319    /// ```
320    fn from(value: u16) -> Self {
321        match value {
322            1 => CollationId::BIG5_CHINESE_CI,
323            2 => CollationId::LATIN2_CZECH_CS,
324            3 => CollationId::DEC8_SWEDISH_CI,
325            4 => CollationId::CP850_GENERAL_CI,
326            5 => CollationId::LATIN1_GERMAN1_CI,
327            6 => CollationId::HP8_ENGLISH_CI,
328            7 => CollationId::KOI8R_GENERAL_CI,
329            8 => CollationId::LATIN1_SWEDISH_CI,
330            9 => CollationId::LATIN2_GENERAL_CI,
331            10 => CollationId::SWE7_SWEDISH_CI,
332            11 => CollationId::ASCII_GENERAL_CI,
333            12 => CollationId::UJIS_JAPANESE_CI,
334            13 => CollationId::SJIS_JAPANESE_CI,
335            14 => CollationId::CP1251_BULGARIAN_CI,
336            15 => CollationId::LATIN1_DANISH_CI,
337            16 => CollationId::HEBREW_GENERAL_CI,
338            18 => CollationId::TIS620_THAI_CI,
339            19 => CollationId::EUCKR_KOREAN_CI,
340            20 => CollationId::LATIN7_ESTONIAN_CS,
341            21 => CollationId::LATIN2_HUNGARIAN_CI,
342            22 => CollationId::KOI8U_GENERAL_CI,
343            23 => CollationId::CP1251_UKRAINIAN_CI,
344            24 => CollationId::GB2312_CHINESE_CI,
345            25 => CollationId::GREEK_GENERAL_CI,
346            26 => CollationId::CP1250_GENERAL_CI,
347            27 => CollationId::LATIN2_CROATIAN_CI,
348            28 => CollationId::GBK_CHINESE_CI,
349            29 => CollationId::CP1257_LITHUANIAN_CI,
350            30 => CollationId::LATIN5_TURKISH_CI,
351            31 => CollationId::LATIN1_GERMAN2_CI,
352            32 => CollationId::ARMSCII8_GENERAL_CI,
353            33 => CollationId::UTF8MB3_GENERAL_CI,
354            34 => CollationId::CP1250_CZECH_CS,
355            35 => CollationId::UCS2_GENERAL_CI,
356            36 => CollationId::CP866_GENERAL_CI,
357            37 => CollationId::KEYBCS2_GENERAL_CI,
358            38 => CollationId::MACCE_GENERAL_CI,
359            39 => CollationId::MACROMAN_GENERAL_CI,
360            40 => CollationId::CP852_GENERAL_CI,
361            41 => CollationId::LATIN7_GENERAL_CI,
362            42 => CollationId::LATIN7_GENERAL_CS,
363            43 => CollationId::MACCE_BIN,
364            44 => CollationId::CP1250_CROATIAN_CI,
365            45 => CollationId::UTF8MB4_GENERAL_CI,
366            46 => CollationId::UTF8MB4_BIN,
367            47 => CollationId::LATIN1_BIN,
368            48 => CollationId::LATIN1_GENERAL_CI,
369            49 => CollationId::LATIN1_GENERAL_CS,
370            50 => CollationId::CP1251_BIN,
371            51 => CollationId::CP1251_GENERAL_CI,
372            52 => CollationId::CP1251_GENERAL_CS,
373            53 => CollationId::MACROMAN_BIN,
374            54 => CollationId::UTF16_GENERAL_CI,
375            55 => CollationId::UTF16_BIN,
376            56 => CollationId::UTF16LE_GENERAL_CI,
377            57 => CollationId::CP1256_GENERAL_CI,
378            58 => CollationId::CP1257_BIN,
379            59 => CollationId::CP1257_GENERAL_CI,
380            60 => CollationId::UTF32_GENERAL_CI,
381            61 => CollationId::UTF32_BIN,
382            62 => CollationId::UTF16LE_BIN,
383            63 => CollationId::BINARY,
384            64 => CollationId::ARMSCII8_BIN,
385            65 => CollationId::ASCII_BIN,
386            66 => CollationId::CP1250_BIN,
387            67 => CollationId::CP1256_BIN,
388            68 => CollationId::CP866_BIN,
389            69 => CollationId::DEC8_BIN,
390            70 => CollationId::GREEK_BIN,
391            71 => CollationId::HEBREW_BIN,
392            72 => CollationId::HP8_BIN,
393            73 => CollationId::KEYBCS2_BIN,
394            74 => CollationId::KOI8R_BIN,
395            75 => CollationId::KOI8U_BIN,
396            76 => CollationId::UTF8MB3_TOLOWER_CI,
397            77 => CollationId::LATIN2_BIN,
398            78 => CollationId::LATIN5_BIN,
399            79 => CollationId::LATIN7_BIN,
400            80 => CollationId::CP850_BIN,
401            81 => CollationId::CP852_BIN,
402            82 => CollationId::SWE7_BIN,
403            83 => CollationId::UTF8MB3_BIN,
404            84 => CollationId::BIG5_BIN,
405            85 => CollationId::EUCKR_BIN,
406            86 => CollationId::GB2312_BIN,
407            87 => CollationId::GBK_BIN,
408            88 => CollationId::SJIS_BIN,
409            89 => CollationId::TIS620_BIN,
410            90 => CollationId::UCS2_BIN,
411            91 => CollationId::UJIS_BIN,
412            92 => CollationId::GEOSTD8_GENERAL_CI,
413            93 => CollationId::GEOSTD8_BIN,
414            94 => CollationId::LATIN1_SPANISH_CI,
415            95 => CollationId::CP932_JAPANESE_CI,
416            96 => CollationId::CP932_BIN,
417            97 => CollationId::EUCJPMS_JAPANESE_CI,
418            98 => CollationId::EUCJPMS_BIN,
419            99 => CollationId::CP1250_POLISH_CI,
420            101 => CollationId::UTF16_UNICODE_CI,
421            102 => CollationId::UTF16_ICELANDIC_CI,
422            103 => CollationId::UTF16_LATVIAN_CI,
423            104 => CollationId::UTF16_ROMANIAN_CI,
424            105 => CollationId::UTF16_SLOVENIAN_CI,
425            106 => CollationId::UTF16_POLISH_CI,
426            107 => CollationId::UTF16_ESTONIAN_CI,
427            108 => CollationId::UTF16_SPANISH_CI,
428            109 => CollationId::UTF16_SWEDISH_CI,
429            110 => CollationId::UTF16_TURKISH_CI,
430            111 => CollationId::UTF16_CZECH_CI,
431            112 => CollationId::UTF16_DANISH_CI,
432            113 => CollationId::UTF16_LITHUANIAN_CI,
433            114 => CollationId::UTF16_SLOVAK_CI,
434            115 => CollationId::UTF16_SPANISH2_CI,
435            116 => CollationId::UTF16_ROMAN_CI,
436            117 => CollationId::UTF16_PERSIAN_CI,
437            118 => CollationId::UTF16_ESPERANTO_CI,
438            119 => CollationId::UTF16_HUNGARIAN_CI,
439            120 => CollationId::UTF16_SINHALA_CI,
440            121 => CollationId::UTF16_GERMAN2_CI,
441            122 => CollationId::UTF16_CROATIAN_CI,
442            123 => CollationId::UTF16_UNICODE_520_CI,
443            124 => CollationId::UTF16_VIETNAMESE_CI,
444            128 => CollationId::UCS2_UNICODE_CI,
445            129 => CollationId::UCS2_ICELANDIC_CI,
446            130 => CollationId::UCS2_LATVIAN_CI,
447            131 => CollationId::UCS2_ROMANIAN_CI,
448            132 => CollationId::UCS2_SLOVENIAN_CI,
449            133 => CollationId::UCS2_POLISH_CI,
450            134 => CollationId::UCS2_ESTONIAN_CI,
451            135 => CollationId::UCS2_SPANISH_CI,
452            136 => CollationId::UCS2_SWEDISH_CI,
453            137 => CollationId::UCS2_TURKISH_CI,
454            138 => CollationId::UCS2_CZECH_CI,
455            139 => CollationId::UCS2_DANISH_CI,
456            140 => CollationId::UCS2_LITHUANIAN_CI,
457            141 => CollationId::UCS2_SLOVAK_CI,
458            142 => CollationId::UCS2_SPANISH2_CI,
459            143 => CollationId::UCS2_ROMAN_CI,
460            144 => CollationId::UCS2_PERSIAN_CI,
461            145 => CollationId::UCS2_ESPERANTO_CI,
462            146 => CollationId::UCS2_HUNGARIAN_CI,
463            147 => CollationId::UCS2_SINHALA_CI,
464            148 => CollationId::UCS2_GERMAN2_CI,
465            149 => CollationId::UCS2_CROATIAN_CI,
466            150 => CollationId::UCS2_UNICODE_520_CI,
467            151 => CollationId::UCS2_VIETNAMESE_CI,
468            159 => CollationId::UCS2_GENERAL_MYSQL500_CI,
469            160 => CollationId::UTF32_UNICODE_CI,
470            161 => CollationId::UTF32_ICELANDIC_CI,
471            162 => CollationId::UTF32_LATVIAN_CI,
472            163 => CollationId::UTF32_ROMANIAN_CI,
473            164 => CollationId::UTF32_SLOVENIAN_CI,
474            165 => CollationId::UTF32_POLISH_CI,
475            166 => CollationId::UTF32_ESTONIAN_CI,
476            167 => CollationId::UTF32_SPANISH_CI,
477            168 => CollationId::UTF32_SWEDISH_CI,
478            169 => CollationId::UTF32_TURKISH_CI,
479            170 => CollationId::UTF32_CZECH_CI,
480            171 => CollationId::UTF32_DANISH_CI,
481            172 => CollationId::UTF32_LITHUANIAN_CI,
482            173 => CollationId::UTF32_SLOVAK_CI,
483            174 => CollationId::UTF32_SPANISH2_CI,
484            175 => CollationId::UTF32_ROMAN_CI,
485            176 => CollationId::UTF32_PERSIAN_CI,
486            177 => CollationId::UTF32_ESPERANTO_CI,
487            178 => CollationId::UTF32_HUNGARIAN_CI,
488            179 => CollationId::UTF32_SINHALA_CI,
489            180 => CollationId::UTF32_GERMAN2_CI,
490            181 => CollationId::UTF32_CROATIAN_CI,
491            182 => CollationId::UTF32_UNICODE_520_CI,
492            183 => CollationId::UTF32_VIETNAMESE_CI,
493            192 => CollationId::UTF8MB3_UNICODE_CI,
494            193 => CollationId::UTF8MB3_ICELANDIC_CI,
495            194 => CollationId::UTF8MB3_LATVIAN_CI,
496            195 => CollationId::UTF8MB3_ROMANIAN_CI,
497            196 => CollationId::UTF8MB3_SLOVENIAN_CI,
498            197 => CollationId::UTF8MB3_POLISH_CI,
499            198 => CollationId::UTF8MB3_ESTONIAN_CI,
500            199 => CollationId::UTF8MB3_SPANISH_CI,
501            200 => CollationId::UTF8MB3_SWEDISH_CI,
502            201 => CollationId::UTF8MB3_TURKISH_CI,
503            202 => CollationId::UTF8MB3_CZECH_CI,
504            203 => CollationId::UTF8MB3_DANISH_CI,
505            204 => CollationId::UTF8MB3_LITHUANIAN_CI,
506            205 => CollationId::UTF8MB3_SLOVAK_CI,
507            206 => CollationId::UTF8MB3_SPANISH2_CI,
508            207 => CollationId::UTF8MB3_ROMAN_CI,
509            208 => CollationId::UTF8MB3_PERSIAN_CI,
510            209 => CollationId::UTF8MB3_ESPERANTO_CI,
511            210 => CollationId::UTF8MB3_HUNGARIAN_CI,
512            211 => CollationId::UTF8MB3_SINHALA_CI,
513            212 => CollationId::UTF8MB3_GERMAN2_CI,
514            213 => CollationId::UTF8MB3_CROATIAN_CI,
515            214 => CollationId::UTF8MB3_UNICODE_520_CI,
516            215 => CollationId::UTF8MB3_VIETNAMESE_CI,
517            223 => CollationId::UTF8MB3_GENERAL_MYSQL500_CI,
518            224 => CollationId::UTF8MB4_UNICODE_CI,
519            225 => CollationId::UTF8MB4_ICELANDIC_CI,
520            226 => CollationId::UTF8MB4_LATVIAN_CI,
521            227 => CollationId::UTF8MB4_ROMANIAN_CI,
522            228 => CollationId::UTF8MB4_SLOVENIAN_CI,
523            229 => CollationId::UTF8MB4_POLISH_CI,
524            230 => CollationId::UTF8MB4_ESTONIAN_CI,
525            231 => CollationId::UTF8MB4_SPANISH_CI,
526            232 => CollationId::UTF8MB4_SWEDISH_CI,
527            233 => CollationId::UTF8MB4_TURKISH_CI,
528            234 => CollationId::UTF8MB4_CZECH_CI,
529            235 => CollationId::UTF8MB4_DANISH_CI,
530            236 => CollationId::UTF8MB4_LITHUANIAN_CI,
531            237 => CollationId::UTF8MB4_SLOVAK_CI,
532            238 => CollationId::UTF8MB4_SPANISH2_CI,
533            239 => CollationId::UTF8MB4_ROMAN_CI,
534            240 => CollationId::UTF8MB4_PERSIAN_CI,
535            241 => CollationId::UTF8MB4_ESPERANTO_CI,
536            242 => CollationId::UTF8MB4_HUNGARIAN_CI,
537            243 => CollationId::UTF8MB4_SINHALA_CI,
538            244 => CollationId::UTF8MB4_GERMAN2_CI,
539            245 => CollationId::UTF8MB4_CROATIAN_CI,
540            246 => CollationId::UTF8MB4_UNICODE_520_CI,
541            247 => CollationId::UTF8MB4_VIETNAMESE_CI,
542            248 => CollationId::GB18030_CHINESE_CI,
543            249 => CollationId::GB18030_BIN,
544            250 => CollationId::GB18030_UNICODE_520_CI,
545            255 => CollationId::UTF8MB4_0900_AI_CI,
546            256 => CollationId::UTF8MB4_DE_PB_0900_AI_CI,
547            257 => CollationId::UTF8MB4_IS_0900_AI_CI,
548            258 => CollationId::UTF8MB4_LV_0900_AI_CI,
549            259 => CollationId::UTF8MB4_RO_0900_AI_CI,
550            260 => CollationId::UTF8MB4_SL_0900_AI_CI,
551            261 => CollationId::UTF8MB4_PL_0900_AI_CI,
552            262 => CollationId::UTF8MB4_ET_0900_AI_CI,
553            263 => CollationId::UTF8MB4_ES_0900_AI_CI,
554            264 => CollationId::UTF8MB4_SV_0900_AI_CI,
555            265 => CollationId::UTF8MB4_TR_0900_AI_CI,
556            266 => CollationId::UTF8MB4_CS_0900_AI_CI,
557            267 => CollationId::UTF8MB4_DA_0900_AI_CI,
558            268 => CollationId::UTF8MB4_LT_0900_AI_CI,
559            269 => CollationId::UTF8MB4_SK_0900_AI_CI,
560            270 => CollationId::UTF8MB4_ES_TRAD_0900_AI_CI,
561            271 => CollationId::UTF8MB4_LA_0900_AI_CI,
562            273 => CollationId::UTF8MB4_EO_0900_AI_CI,
563            274 => CollationId::UTF8MB4_HU_0900_AI_CI,
564            275 => CollationId::UTF8MB4_HR_0900_AI_CI,
565            277 => CollationId::UTF8MB4_VI_0900_AI_CI,
566            278 => CollationId::UTF8MB4_0900_AS_CS,
567            279 => CollationId::UTF8MB4_DE_PB_0900_AS_CS,
568            280 => CollationId::UTF8MB4_IS_0900_AS_CS,
569            281 => CollationId::UTF8MB4_LV_0900_AS_CS,
570            282 => CollationId::UTF8MB4_RO_0900_AS_CS,
571            283 => CollationId::UTF8MB4_SL_0900_AS_CS,
572            284 => CollationId::UTF8MB4_PL_0900_AS_CS,
573            285 => CollationId::UTF8MB4_ET_0900_AS_CS,
574            286 => CollationId::UTF8MB4_ES_0900_AS_CS,
575            287 => CollationId::UTF8MB4_SV_0900_AS_CS,
576            288 => CollationId::UTF8MB4_TR_0900_AS_CS,
577            289 => CollationId::UTF8MB4_CS_0900_AS_CS,
578            290 => CollationId::UTF8MB4_DA_0900_AS_CS,
579            291 => CollationId::UTF8MB4_LT_0900_AS_CS,
580            292 => CollationId::UTF8MB4_SK_0900_AS_CS,
581            293 => CollationId::UTF8MB4_ES_TRAD_0900_AS_CS,
582            294 => CollationId::UTF8MB4_LA_0900_AS_CS,
583            296 => CollationId::UTF8MB4_EO_0900_AS_CS,
584            297 => CollationId::UTF8MB4_HU_0900_AS_CS,
585            298 => CollationId::UTF8MB4_HR_0900_AS_CS,
586            300 => CollationId::UTF8MB4_VI_0900_AS_CS,
587            303 => CollationId::UTF8MB4_JA_0900_AS_CS,
588            304 => CollationId::UTF8MB4_JA_0900_AS_CS_KS,
589            305 => CollationId::UTF8MB4_0900_AS_CI,
590            306 => CollationId::UTF8MB4_RU_0900_AI_CI,
591            307 => CollationId::UTF8MB4_RU_0900_AS_CS,
592            308 => CollationId::UTF8MB4_ZH_0900_AS_CS,
593            309 => CollationId::UTF8MB4_0900_BIN,
594            310 => CollationId::UTF8MB4_NB_0900_AI_CI,
595            311 => CollationId::UTF8MB4_NB_0900_AS_CS,
596            312 => CollationId::UTF8MB4_NN_0900_AI_CI,
597            313 => CollationId::UTF8MB4_NN_0900_AS_CS,
598            314 => CollationId::UTF8MB4_SR_LATN_0900_AI_CI,
599            315 => CollationId::UTF8MB4_SR_LATN_0900_AS_CS,
600            316 => CollationId::UTF8MB4_BS_0900_AI_CI,
601            317 => CollationId::UTF8MB4_BS_0900_AS_CS,
602            318 => CollationId::UTF8MB4_BG_0900_AI_CI,
603            319 => CollationId::UTF8MB4_BG_0900_AS_CS,
604            320 => CollationId::UTF8MB4_GL_0900_AI_CI,
605            321 => CollationId::UTF8MB4_GL_0900_AS_CS,
606            322 => CollationId::UTF8MB4_MN_CYRL_0900_AI_CI,
607            323 => CollationId::UTF8MB4_MN_CYRL_0900_AS_CS,
608            _ => CollationId::UNKNOWN_COLLATION_ID,
609        }
610    }
611}
612
613impl From<&str> for CollationId {
614    /// str conversion.
615    ///
616    /// Unknown collations will be mapped to [`CollationId::UNKNOWN_COLLATION_ID`].
617    ///
618    /// Collected via:
619    ///
620    /// ```sql
621    /// SELECT CONCAT(
622    ///     '"', COLLATION_NAME, '" => CollationId::', UPPER(COLLATION_NAME), ','
623    /// )
624    /// FROM INFORMATION_SCHEMA.COLLATIONS
625    /// ORDER BY ID;
626    /// ```
627    fn from(value: &str) -> Self {
628        match value {
629            "big5_chinese_ci" => CollationId::BIG5_CHINESE_CI,
630            "latin2_czech_cs" => CollationId::LATIN2_CZECH_CS,
631            "dec8_swedish_ci" => CollationId::DEC8_SWEDISH_CI,
632            "cp850_general_ci" => CollationId::CP850_GENERAL_CI,
633            "latin1_german1_ci" => CollationId::LATIN1_GERMAN1_CI,
634            "hp8_english_ci" => CollationId::HP8_ENGLISH_CI,
635            "koi8r_general_ci" => CollationId::KOI8R_GENERAL_CI,
636            "latin1_swedish_ci" => CollationId::LATIN1_SWEDISH_CI,
637            "latin2_general_ci" => CollationId::LATIN2_GENERAL_CI,
638            "swe7_swedish_ci" => CollationId::SWE7_SWEDISH_CI,
639            "ascii_general_ci" => CollationId::ASCII_GENERAL_CI,
640            "ujis_japanese_ci" => CollationId::UJIS_JAPANESE_CI,
641            "sjis_japanese_ci" => CollationId::SJIS_JAPANESE_CI,
642            "cp1251_bulgarian_ci" => CollationId::CP1251_BULGARIAN_CI,
643            "latin1_danish_ci" => CollationId::LATIN1_DANISH_CI,
644            "hebrew_general_ci" => CollationId::HEBREW_GENERAL_CI,
645            "tis620_thai_ci" => CollationId::TIS620_THAI_CI,
646            "euckr_korean_ci" => CollationId::EUCKR_KOREAN_CI,
647            "latin7_estonian_cs" => CollationId::LATIN7_ESTONIAN_CS,
648            "latin2_hungarian_ci" => CollationId::LATIN2_HUNGARIAN_CI,
649            "koi8u_general_ci" => CollationId::KOI8U_GENERAL_CI,
650            "cp1251_ukrainian_ci" => CollationId::CP1251_UKRAINIAN_CI,
651            "gb2312_chinese_ci" => CollationId::GB2312_CHINESE_CI,
652            "greek_general_ci" => CollationId::GREEK_GENERAL_CI,
653            "cp1250_general_ci" => CollationId::CP1250_GENERAL_CI,
654            "latin2_croatian_ci" => CollationId::LATIN2_CROATIAN_CI,
655            "gbk_chinese_ci" => CollationId::GBK_CHINESE_CI,
656            "cp1257_lithuanian_ci" => CollationId::CP1257_LITHUANIAN_CI,
657            "latin5_turkish_ci" => CollationId::LATIN5_TURKISH_CI,
658            "latin1_german2_ci" => CollationId::LATIN1_GERMAN2_CI,
659            "armscii8_general_ci" => CollationId::ARMSCII8_GENERAL_CI,
660            "utf8mb3_general_ci" => CollationId::UTF8MB3_GENERAL_CI,
661            "cp1250_czech_cs" => CollationId::CP1250_CZECH_CS,
662            "ucs2_general_ci" => CollationId::UCS2_GENERAL_CI,
663            "cp866_general_ci" => CollationId::CP866_GENERAL_CI,
664            "keybcs2_general_ci" => CollationId::KEYBCS2_GENERAL_CI,
665            "macce_general_ci" => CollationId::MACCE_GENERAL_CI,
666            "macroman_general_ci" => CollationId::MACROMAN_GENERAL_CI,
667            "cp852_general_ci" => CollationId::CP852_GENERAL_CI,
668            "latin7_general_ci" => CollationId::LATIN7_GENERAL_CI,
669            "latin7_general_cs" => CollationId::LATIN7_GENERAL_CS,
670            "macce_bin" => CollationId::MACCE_BIN,
671            "cp1250_croatian_ci" => CollationId::CP1250_CROATIAN_CI,
672            "utf8mb4_general_ci" => CollationId::UTF8MB4_GENERAL_CI,
673            "utf8mb4_bin" => CollationId::UTF8MB4_BIN,
674            "latin1_bin" => CollationId::LATIN1_BIN,
675            "latin1_general_ci" => CollationId::LATIN1_GENERAL_CI,
676            "latin1_general_cs" => CollationId::LATIN1_GENERAL_CS,
677            "cp1251_bin" => CollationId::CP1251_BIN,
678            "cp1251_general_ci" => CollationId::CP1251_GENERAL_CI,
679            "cp1251_general_cs" => CollationId::CP1251_GENERAL_CS,
680            "macroman_bin" => CollationId::MACROMAN_BIN,
681            "utf16_general_ci" => CollationId::UTF16_GENERAL_CI,
682            "utf16_bin" => CollationId::UTF16_BIN,
683            "utf16le_general_ci" => CollationId::UTF16LE_GENERAL_CI,
684            "cp1256_general_ci" => CollationId::CP1256_GENERAL_CI,
685            "cp1257_bin" => CollationId::CP1257_BIN,
686            "cp1257_general_ci" => CollationId::CP1257_GENERAL_CI,
687            "utf32_general_ci" => CollationId::UTF32_GENERAL_CI,
688            "utf32_bin" => CollationId::UTF32_BIN,
689            "utf16le_bin" => CollationId::UTF16LE_BIN,
690            "binary" => CollationId::BINARY,
691            "armscii8_bin" => CollationId::ARMSCII8_BIN,
692            "ascii_bin" => CollationId::ASCII_BIN,
693            "cp1250_bin" => CollationId::CP1250_BIN,
694            "cp1256_bin" => CollationId::CP1256_BIN,
695            "cp866_bin" => CollationId::CP866_BIN,
696            "dec8_bin" => CollationId::DEC8_BIN,
697            "greek_bin" => CollationId::GREEK_BIN,
698            "hebrew_bin" => CollationId::HEBREW_BIN,
699            "hp8_bin" => CollationId::HP8_BIN,
700            "keybcs2_bin" => CollationId::KEYBCS2_BIN,
701            "koi8r_bin" => CollationId::KOI8R_BIN,
702            "koi8u_bin" => CollationId::KOI8U_BIN,
703            "utf8mb3_tolower_ci" => CollationId::UTF8MB3_TOLOWER_CI,
704            "latin2_bin" => CollationId::LATIN2_BIN,
705            "latin5_bin" => CollationId::LATIN5_BIN,
706            "latin7_bin" => CollationId::LATIN7_BIN,
707            "cp850_bin" => CollationId::CP850_BIN,
708            "cp852_bin" => CollationId::CP852_BIN,
709            "swe7_bin" => CollationId::SWE7_BIN,
710            "utf8mb3_bin" => CollationId::UTF8MB3_BIN,
711            "big5_bin" => CollationId::BIG5_BIN,
712            "euckr_bin" => CollationId::EUCKR_BIN,
713            "gb2312_bin" => CollationId::GB2312_BIN,
714            "gbk_bin" => CollationId::GBK_BIN,
715            "sjis_bin" => CollationId::SJIS_BIN,
716            "tis620_bin" => CollationId::TIS620_BIN,
717            "ucs2_bin" => CollationId::UCS2_BIN,
718            "ujis_bin" => CollationId::UJIS_BIN,
719            "geostd8_general_ci" => CollationId::GEOSTD8_GENERAL_CI,
720            "geostd8_bin" => CollationId::GEOSTD8_BIN,
721            "latin1_spanish_ci" => CollationId::LATIN1_SPANISH_CI,
722            "cp932_japanese_ci" => CollationId::CP932_JAPANESE_CI,
723            "cp932_bin" => CollationId::CP932_BIN,
724            "eucjpms_japanese_ci" => CollationId::EUCJPMS_JAPANESE_CI,
725            "eucjpms_bin" => CollationId::EUCJPMS_BIN,
726            "cp1250_polish_ci" => CollationId::CP1250_POLISH_CI,
727            "utf16_unicode_ci" => CollationId::UTF16_UNICODE_CI,
728            "utf16_icelandic_ci" => CollationId::UTF16_ICELANDIC_CI,
729            "utf16_latvian_ci" => CollationId::UTF16_LATVIAN_CI,
730            "utf16_romanian_ci" => CollationId::UTF16_ROMANIAN_CI,
731            "utf16_slovenian_ci" => CollationId::UTF16_SLOVENIAN_CI,
732            "utf16_polish_ci" => CollationId::UTF16_POLISH_CI,
733            "utf16_estonian_ci" => CollationId::UTF16_ESTONIAN_CI,
734            "utf16_spanish_ci" => CollationId::UTF16_SPANISH_CI,
735            "utf16_swedish_ci" => CollationId::UTF16_SWEDISH_CI,
736            "utf16_turkish_ci" => CollationId::UTF16_TURKISH_CI,
737            "utf16_czech_ci" => CollationId::UTF16_CZECH_CI,
738            "utf16_danish_ci" => CollationId::UTF16_DANISH_CI,
739            "utf16_lithuanian_ci" => CollationId::UTF16_LITHUANIAN_CI,
740            "utf16_slovak_ci" => CollationId::UTF16_SLOVAK_CI,
741            "utf16_spanish2_ci" => CollationId::UTF16_SPANISH2_CI,
742            "utf16_roman_ci" => CollationId::UTF16_ROMAN_CI,
743            "utf16_persian_ci" => CollationId::UTF16_PERSIAN_CI,
744            "utf16_esperanto_ci" => CollationId::UTF16_ESPERANTO_CI,
745            "utf16_hungarian_ci" => CollationId::UTF16_HUNGARIAN_CI,
746            "utf16_sinhala_ci" => CollationId::UTF16_SINHALA_CI,
747            "utf16_german2_ci" => CollationId::UTF16_GERMAN2_CI,
748            "utf16_croatian_ci" => CollationId::UTF16_CROATIAN_CI,
749            "utf16_unicode_520_ci" => CollationId::UTF16_UNICODE_520_CI,
750            "utf16_vietnamese_ci" => CollationId::UTF16_VIETNAMESE_CI,
751            "ucs2_unicode_ci" => CollationId::UCS2_UNICODE_CI,
752            "ucs2_icelandic_ci" => CollationId::UCS2_ICELANDIC_CI,
753            "ucs2_latvian_ci" => CollationId::UCS2_LATVIAN_CI,
754            "ucs2_romanian_ci" => CollationId::UCS2_ROMANIAN_CI,
755            "ucs2_slovenian_ci" => CollationId::UCS2_SLOVENIAN_CI,
756            "ucs2_polish_ci" => CollationId::UCS2_POLISH_CI,
757            "ucs2_estonian_ci" => CollationId::UCS2_ESTONIAN_CI,
758            "ucs2_spanish_ci" => CollationId::UCS2_SPANISH_CI,
759            "ucs2_swedish_ci" => CollationId::UCS2_SWEDISH_CI,
760            "ucs2_turkish_ci" => CollationId::UCS2_TURKISH_CI,
761            "ucs2_czech_ci" => CollationId::UCS2_CZECH_CI,
762            "ucs2_danish_ci" => CollationId::UCS2_DANISH_CI,
763            "ucs2_lithuanian_ci" => CollationId::UCS2_LITHUANIAN_CI,
764            "ucs2_slovak_ci" => CollationId::UCS2_SLOVAK_CI,
765            "ucs2_spanish2_ci" => CollationId::UCS2_SPANISH2_CI,
766            "ucs2_roman_ci" => CollationId::UCS2_ROMAN_CI,
767            "ucs2_persian_ci" => CollationId::UCS2_PERSIAN_CI,
768            "ucs2_esperanto_ci" => CollationId::UCS2_ESPERANTO_CI,
769            "ucs2_hungarian_ci" => CollationId::UCS2_HUNGARIAN_CI,
770            "ucs2_sinhala_ci" => CollationId::UCS2_SINHALA_CI,
771            "ucs2_german2_ci" => CollationId::UCS2_GERMAN2_CI,
772            "ucs2_croatian_ci" => CollationId::UCS2_CROATIAN_CI,
773            "ucs2_unicode_520_ci" => CollationId::UCS2_UNICODE_520_CI,
774            "ucs2_vietnamese_ci" => CollationId::UCS2_VIETNAMESE_CI,
775            "ucs2_general_mysql500_ci" => CollationId::UCS2_GENERAL_MYSQL500_CI,
776            "utf32_unicode_ci" => CollationId::UTF32_UNICODE_CI,
777            "utf32_icelandic_ci" => CollationId::UTF32_ICELANDIC_CI,
778            "utf32_latvian_ci" => CollationId::UTF32_LATVIAN_CI,
779            "utf32_romanian_ci" => CollationId::UTF32_ROMANIAN_CI,
780            "utf32_slovenian_ci" => CollationId::UTF32_SLOVENIAN_CI,
781            "utf32_polish_ci" => CollationId::UTF32_POLISH_CI,
782            "utf32_estonian_ci" => CollationId::UTF32_ESTONIAN_CI,
783            "utf32_spanish_ci" => CollationId::UTF32_SPANISH_CI,
784            "utf32_swedish_ci" => CollationId::UTF32_SWEDISH_CI,
785            "utf32_turkish_ci" => CollationId::UTF32_TURKISH_CI,
786            "utf32_czech_ci" => CollationId::UTF32_CZECH_CI,
787            "utf32_danish_ci" => CollationId::UTF32_DANISH_CI,
788            "utf32_lithuanian_ci" => CollationId::UTF32_LITHUANIAN_CI,
789            "utf32_slovak_ci" => CollationId::UTF32_SLOVAK_CI,
790            "utf32_spanish2_ci" => CollationId::UTF32_SPANISH2_CI,
791            "utf32_roman_ci" => CollationId::UTF32_ROMAN_CI,
792            "utf32_persian_ci" => CollationId::UTF32_PERSIAN_CI,
793            "utf32_esperanto_ci" => CollationId::UTF32_ESPERANTO_CI,
794            "utf32_hungarian_ci" => CollationId::UTF32_HUNGARIAN_CI,
795            "utf32_sinhala_ci" => CollationId::UTF32_SINHALA_CI,
796            "utf32_german2_ci" => CollationId::UTF32_GERMAN2_CI,
797            "utf32_croatian_ci" => CollationId::UTF32_CROATIAN_CI,
798            "utf32_unicode_520_ci" => CollationId::UTF32_UNICODE_520_CI,
799            "utf32_vietnamese_ci" => CollationId::UTF32_VIETNAMESE_CI,
800            "utf8mb3_unicode_ci" => CollationId::UTF8MB3_UNICODE_CI,
801            "utf8mb3_icelandic_ci" => CollationId::UTF8MB3_ICELANDIC_CI,
802            "utf8mb3_latvian_ci" => CollationId::UTF8MB3_LATVIAN_CI,
803            "utf8mb3_romanian_ci" => CollationId::UTF8MB3_ROMANIAN_CI,
804            "utf8mb3_slovenian_ci" => CollationId::UTF8MB3_SLOVENIAN_CI,
805            "utf8mb3_polish_ci" => CollationId::UTF8MB3_POLISH_CI,
806            "utf8mb3_estonian_ci" => CollationId::UTF8MB3_ESTONIAN_CI,
807            "utf8mb3_spanish_ci" => CollationId::UTF8MB3_SPANISH_CI,
808            "utf8mb3_swedish_ci" => CollationId::UTF8MB3_SWEDISH_CI,
809            "utf8mb3_turkish_ci" => CollationId::UTF8MB3_TURKISH_CI,
810            "utf8mb3_czech_ci" => CollationId::UTF8MB3_CZECH_CI,
811            "utf8mb3_danish_ci" => CollationId::UTF8MB3_DANISH_CI,
812            "utf8mb3_lithuanian_ci" => CollationId::UTF8MB3_LITHUANIAN_CI,
813            "utf8mb3_slovak_ci" => CollationId::UTF8MB3_SLOVAK_CI,
814            "utf8mb3_spanish2_ci" => CollationId::UTF8MB3_SPANISH2_CI,
815            "utf8mb3_roman_ci" => CollationId::UTF8MB3_ROMAN_CI,
816            "utf8mb3_persian_ci" => CollationId::UTF8MB3_PERSIAN_CI,
817            "utf8mb3_esperanto_ci" => CollationId::UTF8MB3_ESPERANTO_CI,
818            "utf8mb3_hungarian_ci" => CollationId::UTF8MB3_HUNGARIAN_CI,
819            "utf8mb3_sinhala_ci" => CollationId::UTF8MB3_SINHALA_CI,
820            "utf8mb3_german2_ci" => CollationId::UTF8MB3_GERMAN2_CI,
821            "utf8mb3_croatian_ci" => CollationId::UTF8MB3_CROATIAN_CI,
822            "utf8mb3_unicode_520_ci" => CollationId::UTF8MB3_UNICODE_520_CI,
823            "utf8mb3_vietnamese_ci" => CollationId::UTF8MB3_VIETNAMESE_CI,
824            "utf8mb3_general_mysql500_ci" => CollationId::UTF8MB3_GENERAL_MYSQL500_CI,
825            "utf8mb4_unicode_ci" => CollationId::UTF8MB4_UNICODE_CI,
826            "utf8mb4_icelandic_ci" => CollationId::UTF8MB4_ICELANDIC_CI,
827            "utf8mb4_latvian_ci" => CollationId::UTF8MB4_LATVIAN_CI,
828            "utf8mb4_romanian_ci" => CollationId::UTF8MB4_ROMANIAN_CI,
829            "utf8mb4_slovenian_ci" => CollationId::UTF8MB4_SLOVENIAN_CI,
830            "utf8mb4_polish_ci" => CollationId::UTF8MB4_POLISH_CI,
831            "utf8mb4_estonian_ci" => CollationId::UTF8MB4_ESTONIAN_CI,
832            "utf8mb4_spanish_ci" => CollationId::UTF8MB4_SPANISH_CI,
833            "utf8mb4_swedish_ci" => CollationId::UTF8MB4_SWEDISH_CI,
834            "utf8mb4_turkish_ci" => CollationId::UTF8MB4_TURKISH_CI,
835            "utf8mb4_czech_ci" => CollationId::UTF8MB4_CZECH_CI,
836            "utf8mb4_danish_ci" => CollationId::UTF8MB4_DANISH_CI,
837            "utf8mb4_lithuanian_ci" => CollationId::UTF8MB4_LITHUANIAN_CI,
838            "utf8mb4_slovak_ci" => CollationId::UTF8MB4_SLOVAK_CI,
839            "utf8mb4_spanish2_ci" => CollationId::UTF8MB4_SPANISH2_CI,
840            "utf8mb4_roman_ci" => CollationId::UTF8MB4_ROMAN_CI,
841            "utf8mb4_persian_ci" => CollationId::UTF8MB4_PERSIAN_CI,
842            "utf8mb4_esperanto_ci" => CollationId::UTF8MB4_ESPERANTO_CI,
843            "utf8mb4_hungarian_ci" => CollationId::UTF8MB4_HUNGARIAN_CI,
844            "utf8mb4_sinhala_ci" => CollationId::UTF8MB4_SINHALA_CI,
845            "utf8mb4_german2_ci" => CollationId::UTF8MB4_GERMAN2_CI,
846            "utf8mb4_croatian_ci" => CollationId::UTF8MB4_CROATIAN_CI,
847            "utf8mb4_unicode_520_ci" => CollationId::UTF8MB4_UNICODE_520_CI,
848            "utf8mb4_vietnamese_ci" => CollationId::UTF8MB4_VIETNAMESE_CI,
849            "gb18030_chinese_ci" => CollationId::GB18030_CHINESE_CI,
850            "gb18030_bin" => CollationId::GB18030_BIN,
851            "gb18030_unicode_520_ci" => CollationId::GB18030_UNICODE_520_CI,
852            "utf8mb4_0900_ai_ci" => CollationId::UTF8MB4_0900_AI_CI,
853            "utf8mb4_de_pb_0900_ai_ci" => CollationId::UTF8MB4_DE_PB_0900_AI_CI,
854            "utf8mb4_is_0900_ai_ci" => CollationId::UTF8MB4_IS_0900_AI_CI,
855            "utf8mb4_lv_0900_ai_ci" => CollationId::UTF8MB4_LV_0900_AI_CI,
856            "utf8mb4_ro_0900_ai_ci" => CollationId::UTF8MB4_RO_0900_AI_CI,
857            "utf8mb4_sl_0900_ai_ci" => CollationId::UTF8MB4_SL_0900_AI_CI,
858            "utf8mb4_pl_0900_ai_ci" => CollationId::UTF8MB4_PL_0900_AI_CI,
859            "utf8mb4_et_0900_ai_ci" => CollationId::UTF8MB4_ET_0900_AI_CI,
860            "utf8mb4_es_0900_ai_ci" => CollationId::UTF8MB4_ES_0900_AI_CI,
861            "utf8mb4_sv_0900_ai_ci" => CollationId::UTF8MB4_SV_0900_AI_CI,
862            "utf8mb4_tr_0900_ai_ci" => CollationId::UTF8MB4_TR_0900_AI_CI,
863            "utf8mb4_cs_0900_ai_ci" => CollationId::UTF8MB4_CS_0900_AI_CI,
864            "utf8mb4_da_0900_ai_ci" => CollationId::UTF8MB4_DA_0900_AI_CI,
865            "utf8mb4_lt_0900_ai_ci" => CollationId::UTF8MB4_LT_0900_AI_CI,
866            "utf8mb4_sk_0900_ai_ci" => CollationId::UTF8MB4_SK_0900_AI_CI,
867            "utf8mb4_es_trad_0900_ai_ci" => CollationId::UTF8MB4_ES_TRAD_0900_AI_CI,
868            "utf8mb4_la_0900_ai_ci" => CollationId::UTF8MB4_LA_0900_AI_CI,
869            "utf8mb4_eo_0900_ai_ci" => CollationId::UTF8MB4_EO_0900_AI_CI,
870            "utf8mb4_hu_0900_ai_ci" => CollationId::UTF8MB4_HU_0900_AI_CI,
871            "utf8mb4_hr_0900_ai_ci" => CollationId::UTF8MB4_HR_0900_AI_CI,
872            "utf8mb4_vi_0900_ai_ci" => CollationId::UTF8MB4_VI_0900_AI_CI,
873            "utf8mb4_0900_as_cs" => CollationId::UTF8MB4_0900_AS_CS,
874            "utf8mb4_de_pb_0900_as_cs" => CollationId::UTF8MB4_DE_PB_0900_AS_CS,
875            "utf8mb4_is_0900_as_cs" => CollationId::UTF8MB4_IS_0900_AS_CS,
876            "utf8mb4_lv_0900_as_cs" => CollationId::UTF8MB4_LV_0900_AS_CS,
877            "utf8mb4_ro_0900_as_cs" => CollationId::UTF8MB4_RO_0900_AS_CS,
878            "utf8mb4_sl_0900_as_cs" => CollationId::UTF8MB4_SL_0900_AS_CS,
879            "utf8mb4_pl_0900_as_cs" => CollationId::UTF8MB4_PL_0900_AS_CS,
880            "utf8mb4_et_0900_as_cs" => CollationId::UTF8MB4_ET_0900_AS_CS,
881            "utf8mb4_es_0900_as_cs" => CollationId::UTF8MB4_ES_0900_AS_CS,
882            "utf8mb4_sv_0900_as_cs" => CollationId::UTF8MB4_SV_0900_AS_CS,
883            "utf8mb4_tr_0900_as_cs" => CollationId::UTF8MB4_TR_0900_AS_CS,
884            "utf8mb4_cs_0900_as_cs" => CollationId::UTF8MB4_CS_0900_AS_CS,
885            "utf8mb4_da_0900_as_cs" => CollationId::UTF8MB4_DA_0900_AS_CS,
886            "utf8mb4_lt_0900_as_cs" => CollationId::UTF8MB4_LT_0900_AS_CS,
887            "utf8mb4_sk_0900_as_cs" => CollationId::UTF8MB4_SK_0900_AS_CS,
888            "utf8mb4_es_trad_0900_as_cs" => CollationId::UTF8MB4_ES_TRAD_0900_AS_CS,
889            "utf8mb4_la_0900_as_cs" => CollationId::UTF8MB4_LA_0900_AS_CS,
890            "utf8mb4_eo_0900_as_cs" => CollationId::UTF8MB4_EO_0900_AS_CS,
891            "utf8mb4_hu_0900_as_cs" => CollationId::UTF8MB4_HU_0900_AS_CS,
892            "utf8mb4_hr_0900_as_cs" => CollationId::UTF8MB4_HR_0900_AS_CS,
893            "utf8mb4_vi_0900_as_cs" => CollationId::UTF8MB4_VI_0900_AS_CS,
894            "utf8mb4_ja_0900_as_cs" => CollationId::UTF8MB4_JA_0900_AS_CS,
895            "utf8mb4_ja_0900_as_cs_ks" => CollationId::UTF8MB4_JA_0900_AS_CS_KS,
896            "utf8mb4_0900_as_ci" => CollationId::UTF8MB4_0900_AS_CI,
897            "utf8mb4_ru_0900_ai_ci" => CollationId::UTF8MB4_RU_0900_AI_CI,
898            "utf8mb4_ru_0900_as_cs" => CollationId::UTF8MB4_RU_0900_AS_CS,
899            "utf8mb4_zh_0900_as_cs" => CollationId::UTF8MB4_ZH_0900_AS_CS,
900            "utf8mb4_0900_bin" => CollationId::UTF8MB4_0900_BIN,
901            "utf8mb4_nb_0900_ai_ci" => CollationId::UTF8MB4_NB_0900_AI_CI,
902            "utf8mb4_nb_0900_as_cs" => CollationId::UTF8MB4_NB_0900_AS_CS,
903            "utf8mb4_nn_0900_ai_ci" => CollationId::UTF8MB4_NN_0900_AI_CI,
904            "utf8mb4_nn_0900_as_cs" => CollationId::UTF8MB4_NN_0900_AS_CS,
905            "utf8mb4_sr_latn_0900_ai_ci" => CollationId::UTF8MB4_SR_LATN_0900_AI_CI,
906            "utf8mb4_sr_latn_0900_as_cs" => CollationId::UTF8MB4_SR_LATN_0900_AS_CS,
907            "utf8mb4_bs_0900_ai_ci" => CollationId::UTF8MB4_BS_0900_AI_CI,
908            "utf8mb4_bs_0900_as_cs" => CollationId::UTF8MB4_BS_0900_AS_CS,
909            "utf8mb4_bg_0900_ai_ci" => CollationId::UTF8MB4_BG_0900_AI_CI,
910            "utf8mb4_bg_0900_as_cs" => CollationId::UTF8MB4_BG_0900_AS_CS,
911            "utf8mb4_gl_0900_ai_ci" => CollationId::UTF8MB4_GL_0900_AI_CI,
912            "utf8mb4_gl_0900_as_cs" => CollationId::UTF8MB4_GL_0900_AS_CS,
913            "utf8mb4_mn_cyrl_0900_ai_ci" => CollationId::UTF8MB4_MN_CYRL_0900_AI_CI,
914            "utf8mb4_mn_cyrl_0900_as_cs" => CollationId::UTF8MB4_MN_CYRL_0900_AS_CS,
915            _ => CollationId::UNKNOWN_COLLATION_ID,
916        }
917    }
918}
919
920#[derive(Debug, Clone, Copy, PartialEq, Eq, Hash)]
921pub enum PadAttribute {
922    PadZero,
923    PadSpace,
924}
925
926/// MySQL server collation
927#[derive(Debug, Clone, PartialEq, Eq, Hash)]
928pub struct Collation<'a> {
929    pub id: CollationId,
930    pub charset: &'a str,
931    pub collation: &'a str,
932    pub is_default: bool,
933    pub padding: PadAttribute,
934    pub is_compiled: bool,
935    pub sort_len: u8,
936    pub max_len: u8,
937}
938
939/// Constants are generated using the following statement:
940///
941/// ```sql
942/// SELECT CONCAT(
943///     0x5c5c5c20, DESCRIPTION, 0x0a,
944///     'const ', UPPER(COLLATION_NAME), '_COLLATION: Collation<''static> = Collation {',
945///     'id: CollationId::', UPPER(COLLATION_NAME), ',',
946///     'charset: "', CHARACTER_SET_NAME, '",',
947///     'collation: "', COLLATION_NAME, '",',
948///     'is_default: ', IF(IS_DEFAULT = 'Yes', 'true', 'false'), ',',
949///     'padding: PadAttribute::', IF(PAD_ATTRIBUTE = 'PAD SPACE', 'PadSpace', 'PadZero'), ',',
950///     'is_compiled: ', IF(IS_COMPILED = 'Yes', 'true', 'false'), ',',
951///     'sort_len: ', SORTLEN, ',',
952///     'max_len: ', MAXLEN,
953/// '};')
954/// FROM INFORMATION_SCHEMA.COLLATIONS
955/// JOIN INFORMATION_SCHEMA.CHARACTER_SETS
956/// USING(CHARACTER_SET_NAME) ORDER BY ID;
957/// ```
958impl Collation<'_> {
959    /// This is a stub.
960    const UNKNOWN_COLLATION: Collation<'static> = Collation {
961        id: CollationId::UNKNOWN_COLLATION_ID,
962        charset: "unknown",
963        collation: "unknown",
964        is_default: false,
965        padding: PadAttribute::PadSpace,
966        is_compiled: false,
967        sort_len: 0,
968        max_len: 0,
969    };
970    /// Big5 Traditional Chinese
971    const BIG5_CHINESE_CI_COLLATION: Collation<'static> = Collation {
972        id: CollationId::BIG5_CHINESE_CI,
973        charset: "big5",
974        collation: "big5_chinese_ci",
975        is_default: true,
976        padding: PadAttribute::PadSpace,
977        is_compiled: true,
978        sort_len: 1,
979        max_len: 2,
980    };
981    /// ISO 8859-2 Central European
982    const LATIN2_CZECH_CS_COLLATION: Collation<'static> = Collation {
983        id: CollationId::LATIN2_CZECH_CS,
984        charset: "latin2",
985        collation: "latin2_czech_cs",
986        is_default: false,
987        padding: PadAttribute::PadSpace,
988        is_compiled: true,
989        sort_len: 4,
990        max_len: 1,
991    };
992    /// DEC West European
993    const DEC8_SWEDISH_CI_COLLATION: Collation<'static> = Collation {
994        id: CollationId::DEC8_SWEDISH_CI,
995        charset: "dec8",
996        collation: "dec8_swedish_ci",
997        is_default: true,
998        padding: PadAttribute::PadSpace,
999        is_compiled: true,
1000        sort_len: 1,
1001        max_len: 1,
1002    };
1003    /// DOS West European
1004    const CP850_GENERAL_CI_COLLATION: Collation<'static> = Collation {
1005        id: CollationId::CP850_GENERAL_CI,
1006        charset: "cp850",
1007        collation: "cp850_general_ci",
1008        is_default: true,
1009        padding: PadAttribute::PadSpace,
1010        is_compiled: true,
1011        sort_len: 1,
1012        max_len: 1,
1013    };
1014    /// cp1252 West European
1015    const LATIN1_GERMAN1_CI_COLLATION: Collation<'static> = Collation {
1016        id: CollationId::LATIN1_GERMAN1_CI,
1017        charset: "latin1",
1018        collation: "latin1_german1_ci",
1019        is_default: false,
1020        padding: PadAttribute::PadSpace,
1021        is_compiled: true,
1022        sort_len: 1,
1023        max_len: 1,
1024    };
1025    /// HP West European
1026    const HP8_ENGLISH_CI_COLLATION: Collation<'static> = Collation {
1027        id: CollationId::HP8_ENGLISH_CI,
1028        charset: "hp8",
1029        collation: "hp8_english_ci",
1030        is_default: true,
1031        padding: PadAttribute::PadSpace,
1032        is_compiled: true,
1033        sort_len: 1,
1034        max_len: 1,
1035    };
1036    /// KOI8-R Relcom Russian
1037    const KOI8R_GENERAL_CI_COLLATION: Collation<'static> = Collation {
1038        id: CollationId::KOI8R_GENERAL_CI,
1039        charset: "koi8r",
1040        collation: "koi8r_general_ci",
1041        is_default: true,
1042        padding: PadAttribute::PadSpace,
1043        is_compiled: true,
1044        sort_len: 1,
1045        max_len: 1,
1046    };
1047    /// cp1252 West European
1048    const LATIN1_SWEDISH_CI_COLLATION: Collation<'static> = Collation {
1049        id: CollationId::LATIN1_SWEDISH_CI,
1050        charset: "latin1",
1051        collation: "latin1_swedish_ci",
1052        is_default: true,
1053        padding: PadAttribute::PadSpace,
1054        is_compiled: true,
1055        sort_len: 1,
1056        max_len: 1,
1057    };
1058    /// ISO 8859-2 Central European
1059    const LATIN2_GENERAL_CI_COLLATION: Collation<'static> = Collation {
1060        id: CollationId::LATIN2_GENERAL_CI,
1061        charset: "latin2",
1062        collation: "latin2_general_ci",
1063        is_default: true,
1064        padding: PadAttribute::PadSpace,
1065        is_compiled: true,
1066        sort_len: 1,
1067        max_len: 1,
1068    };
1069    /// 7bit Swedish
1070    const SWE7_SWEDISH_CI_COLLATION: Collation<'static> = Collation {
1071        id: CollationId::SWE7_SWEDISH_CI,
1072        charset: "swe7",
1073        collation: "swe7_swedish_ci",
1074        is_default: true,
1075        padding: PadAttribute::PadSpace,
1076        is_compiled: true,
1077        sort_len: 1,
1078        max_len: 1,
1079    };
1080    /// US ASCII
1081    const ASCII_GENERAL_CI_COLLATION: Collation<'static> = Collation {
1082        id: CollationId::ASCII_GENERAL_CI,
1083        charset: "ascii",
1084        collation: "ascii_general_ci",
1085        is_default: true,
1086        padding: PadAttribute::PadSpace,
1087        is_compiled: true,
1088        sort_len: 1,
1089        max_len: 1,
1090    };
1091    /// EUC-JP Japanese
1092    const UJIS_JAPANESE_CI_COLLATION: Collation<'static> = Collation {
1093        id: CollationId::UJIS_JAPANESE_CI,
1094        charset: "ujis",
1095        collation: "ujis_japanese_ci",
1096        is_default: true,
1097        padding: PadAttribute::PadSpace,
1098        is_compiled: true,
1099        sort_len: 1,
1100        max_len: 3,
1101    };
1102    /// Shift-JIS Japanese
1103    const SJIS_JAPANESE_CI_COLLATION: Collation<'static> = Collation {
1104        id: CollationId::SJIS_JAPANESE_CI,
1105        charset: "sjis",
1106        collation: "sjis_japanese_ci",
1107        is_default: true,
1108        padding: PadAttribute::PadSpace,
1109        is_compiled: true,
1110        sort_len: 1,
1111        max_len: 2,
1112    };
1113    /// Windows Cyrillic
1114    const CP1251_BULGARIAN_CI_COLLATION: Collation<'static> = Collation {
1115        id: CollationId::CP1251_BULGARIAN_CI,
1116        charset: "cp1251",
1117        collation: "cp1251_bulgarian_ci",
1118        is_default: false,
1119        padding: PadAttribute::PadSpace,
1120        is_compiled: true,
1121        sort_len: 1,
1122        max_len: 1,
1123    };
1124    /// cp1252 West European
1125    const LATIN1_DANISH_CI_COLLATION: Collation<'static> = Collation {
1126        id: CollationId::LATIN1_DANISH_CI,
1127        charset: "latin1",
1128        collation: "latin1_danish_ci",
1129        is_default: false,
1130        padding: PadAttribute::PadSpace,
1131        is_compiled: true,
1132        sort_len: 1,
1133        max_len: 1,
1134    };
1135    /// ISO 8859-8 Hebrew
1136    const HEBREW_GENERAL_CI_COLLATION: Collation<'static> = Collation {
1137        id: CollationId::HEBREW_GENERAL_CI,
1138        charset: "hebrew",
1139        collation: "hebrew_general_ci",
1140        is_default: true,
1141        padding: PadAttribute::PadSpace,
1142        is_compiled: true,
1143        sort_len: 1,
1144        max_len: 1,
1145    };
1146    /// TIS620 Thai
1147    const TIS620_THAI_CI_COLLATION: Collation<'static> = Collation {
1148        id: CollationId::TIS620_THAI_CI,
1149        charset: "tis620",
1150        collation: "tis620_thai_ci",
1151        is_default: true,
1152        padding: PadAttribute::PadSpace,
1153        is_compiled: true,
1154        sort_len: 4,
1155        max_len: 1,
1156    };
1157    /// EUC-KR Korean
1158    const EUCKR_KOREAN_CI_COLLATION: Collation<'static> = Collation {
1159        id: CollationId::EUCKR_KOREAN_CI,
1160        charset: "euckr",
1161        collation: "euckr_korean_ci",
1162        is_default: true,
1163        padding: PadAttribute::PadSpace,
1164        is_compiled: true,
1165        sort_len: 1,
1166        max_len: 2,
1167    };
1168    /// ISO 8859-13 Baltic
1169    const LATIN7_ESTONIAN_CS_COLLATION: Collation<'static> = Collation {
1170        id: CollationId::LATIN7_ESTONIAN_CS,
1171        charset: "latin7",
1172        collation: "latin7_estonian_cs",
1173        is_default: false,
1174        padding: PadAttribute::PadSpace,
1175        is_compiled: true,
1176        sort_len: 1,
1177        max_len: 1,
1178    };
1179    /// ISO 8859-2 Central European
1180    const LATIN2_HUNGARIAN_CI_COLLATION: Collation<'static> = Collation {
1181        id: CollationId::LATIN2_HUNGARIAN_CI,
1182        charset: "latin2",
1183        collation: "latin2_hungarian_ci",
1184        is_default: false,
1185        padding: PadAttribute::PadSpace,
1186        is_compiled: true,
1187        sort_len: 1,
1188        max_len: 1,
1189    };
1190    /// KOI8-U Ukrainian
1191    const KOI8U_GENERAL_CI_COLLATION: Collation<'static> = Collation {
1192        id: CollationId::KOI8U_GENERAL_CI,
1193        charset: "koi8u",
1194        collation: "koi8u_general_ci",
1195        is_default: true,
1196        padding: PadAttribute::PadSpace,
1197        is_compiled: true,
1198        sort_len: 1,
1199        max_len: 1,
1200    };
1201    /// Windows Cyrillic
1202    const CP1251_UKRAINIAN_CI_COLLATION: Collation<'static> = Collation {
1203        id: CollationId::CP1251_UKRAINIAN_CI,
1204        charset: "cp1251",
1205        collation: "cp1251_ukrainian_ci",
1206        is_default: false,
1207        padding: PadAttribute::PadSpace,
1208        is_compiled: true,
1209        sort_len: 1,
1210        max_len: 1,
1211    };
1212    /// GB2312 Simplified Chinese
1213    const GB2312_CHINESE_CI_COLLATION: Collation<'static> = Collation {
1214        id: CollationId::GB2312_CHINESE_CI,
1215        charset: "gb2312",
1216        collation: "gb2312_chinese_ci",
1217        is_default: true,
1218        padding: PadAttribute::PadSpace,
1219        is_compiled: true,
1220        sort_len: 1,
1221        max_len: 2,
1222    };
1223    /// ISO 8859-7 Greek
1224    const GREEK_GENERAL_CI_COLLATION: Collation<'static> = Collation {
1225        id: CollationId::GREEK_GENERAL_CI,
1226        charset: "greek",
1227        collation: "greek_general_ci",
1228        is_default: true,
1229        padding: PadAttribute::PadSpace,
1230        is_compiled: true,
1231        sort_len: 1,
1232        max_len: 1,
1233    };
1234    /// Windows Central European
1235    const CP1250_GENERAL_CI_COLLATION: Collation<'static> = Collation {
1236        id: CollationId::CP1250_GENERAL_CI,
1237        charset: "cp1250",
1238        collation: "cp1250_general_ci",
1239        is_default: true,
1240        padding: PadAttribute::PadSpace,
1241        is_compiled: true,
1242        sort_len: 1,
1243        max_len: 1,
1244    };
1245    /// ISO 8859-2 Central European
1246    const LATIN2_CROATIAN_CI_COLLATION: Collation<'static> = Collation {
1247        id: CollationId::LATIN2_CROATIAN_CI,
1248        charset: "latin2",
1249        collation: "latin2_croatian_ci",
1250        is_default: false,
1251        padding: PadAttribute::PadSpace,
1252        is_compiled: true,
1253        sort_len: 1,
1254        max_len: 1,
1255    };
1256    /// GBK Simplified Chinese
1257    const GBK_CHINESE_CI_COLLATION: Collation<'static> = Collation {
1258        id: CollationId::GBK_CHINESE_CI,
1259        charset: "gbk",
1260        collation: "gbk_chinese_ci",
1261        is_default: true,
1262        padding: PadAttribute::PadSpace,
1263        is_compiled: true,
1264        sort_len: 1,
1265        max_len: 2,
1266    };
1267    /// Windows Baltic
1268    const CP1257_LITHUANIAN_CI_COLLATION: Collation<'static> = Collation {
1269        id: CollationId::CP1257_LITHUANIAN_CI,
1270        charset: "cp1257",
1271        collation: "cp1257_lithuanian_ci",
1272        is_default: false,
1273        padding: PadAttribute::PadSpace,
1274        is_compiled: true,
1275        sort_len: 1,
1276        max_len: 1,
1277    };
1278    /// ISO 8859-9 Turkish
1279    const LATIN5_TURKISH_CI_COLLATION: Collation<'static> = Collation {
1280        id: CollationId::LATIN5_TURKISH_CI,
1281        charset: "latin5",
1282        collation: "latin5_turkish_ci",
1283        is_default: true,
1284        padding: PadAttribute::PadSpace,
1285        is_compiled: true,
1286        sort_len: 1,
1287        max_len: 1,
1288    };
1289    /// cp1252 West European
1290    const LATIN1_GERMAN2_CI_COLLATION: Collation<'static> = Collation {
1291        id: CollationId::LATIN1_GERMAN2_CI,
1292        charset: "latin1",
1293        collation: "latin1_german2_ci",
1294        is_default: false,
1295        padding: PadAttribute::PadSpace,
1296        is_compiled: true,
1297        sort_len: 2,
1298        max_len: 1,
1299    };
1300    /// ARMSCII-8 Armenian
1301    const ARMSCII8_GENERAL_CI_COLLATION: Collation<'static> = Collation {
1302        id: CollationId::ARMSCII8_GENERAL_CI,
1303        charset: "armscii8",
1304        collation: "armscii8_general_ci",
1305        is_default: true,
1306        padding: PadAttribute::PadSpace,
1307        is_compiled: true,
1308        sort_len: 1,
1309        max_len: 1,
1310    };
1311    /// UTF-8 Unicode
1312    const UTF8MB3_GENERAL_CI_COLLATION: Collation<'static> = Collation {
1313        id: CollationId::UTF8MB3_GENERAL_CI,
1314        charset: "utf8mb3",
1315        collation: "utf8mb3_general_ci",
1316        is_default: true,
1317        padding: PadAttribute::PadSpace,
1318        is_compiled: true,
1319        sort_len: 1,
1320        max_len: 3,
1321    };
1322    /// Windows Central European
1323    const CP1250_CZECH_CS_COLLATION: Collation<'static> = Collation {
1324        id: CollationId::CP1250_CZECH_CS,
1325        charset: "cp1250",
1326        collation: "cp1250_czech_cs",
1327        is_default: false,
1328        padding: PadAttribute::PadSpace,
1329        is_compiled: true,
1330        sort_len: 2,
1331        max_len: 1,
1332    };
1333    /// UCS-2 Unicode
1334    const UCS2_GENERAL_CI_COLLATION: Collation<'static> = Collation {
1335        id: CollationId::UCS2_GENERAL_CI,
1336        charset: "ucs2",
1337        collation: "ucs2_general_ci",
1338        is_default: true,
1339        padding: PadAttribute::PadSpace,
1340        is_compiled: true,
1341        sort_len: 1,
1342        max_len: 2,
1343    };
1344    /// DOS Russian
1345    const CP866_GENERAL_CI_COLLATION: Collation<'static> = Collation {
1346        id: CollationId::CP866_GENERAL_CI,
1347        charset: "cp866",
1348        collation: "cp866_general_ci",
1349        is_default: true,
1350        padding: PadAttribute::PadSpace,
1351        is_compiled: true,
1352        sort_len: 1,
1353        max_len: 1,
1354    };
1355    /// DOS Kamenicky Czech-Slovak
1356    const KEYBCS2_GENERAL_CI_COLLATION: Collation<'static> = Collation {
1357        id: CollationId::KEYBCS2_GENERAL_CI,
1358        charset: "keybcs2",
1359        collation: "keybcs2_general_ci",
1360        is_default: true,
1361        padding: PadAttribute::PadSpace,
1362        is_compiled: true,
1363        sort_len: 1,
1364        max_len: 1,
1365    };
1366    /// Mac Central European
1367    const MACCE_GENERAL_CI_COLLATION: Collation<'static> = Collation {
1368        id: CollationId::MACCE_GENERAL_CI,
1369        charset: "macce",
1370        collation: "macce_general_ci",
1371        is_default: true,
1372        padding: PadAttribute::PadSpace,
1373        is_compiled: true,
1374        sort_len: 1,
1375        max_len: 1,
1376    };
1377    /// Mac West European
1378    const MACROMAN_GENERAL_CI_COLLATION: Collation<'static> = Collation {
1379        id: CollationId::MACROMAN_GENERAL_CI,
1380        charset: "macroman",
1381        collation: "macroman_general_ci",
1382        is_default: true,
1383        padding: PadAttribute::PadSpace,
1384        is_compiled: true,
1385        sort_len: 1,
1386        max_len: 1,
1387    };
1388    /// DOS Central European
1389    const CP852_GENERAL_CI_COLLATION: Collation<'static> = Collation {
1390        id: CollationId::CP852_GENERAL_CI,
1391        charset: "cp852",
1392        collation: "cp852_general_ci",
1393        is_default: true,
1394        padding: PadAttribute::PadSpace,
1395        is_compiled: true,
1396        sort_len: 1,
1397        max_len: 1,
1398    };
1399    /// ISO 8859-13 Baltic
1400    const LATIN7_GENERAL_CI_COLLATION: Collation<'static> = Collation {
1401        id: CollationId::LATIN7_GENERAL_CI,
1402        charset: "latin7",
1403        collation: "latin7_general_ci",
1404        is_default: true,
1405        padding: PadAttribute::PadSpace,
1406        is_compiled: true,
1407        sort_len: 1,
1408        max_len: 1,
1409    };
1410    /// ISO 8859-13 Baltic
1411    const LATIN7_GENERAL_CS_COLLATION: Collation<'static> = Collation {
1412        id: CollationId::LATIN7_GENERAL_CS,
1413        charset: "latin7",
1414        collation: "latin7_general_cs",
1415        is_default: false,
1416        padding: PadAttribute::PadSpace,
1417        is_compiled: true,
1418        sort_len: 1,
1419        max_len: 1,
1420    };
1421    /// Mac Central European
1422    const MACCE_BIN_COLLATION: Collation<'static> = Collation {
1423        id: CollationId::MACCE_BIN,
1424        charset: "macce",
1425        collation: "macce_bin",
1426        is_default: false,
1427        padding: PadAttribute::PadSpace,
1428        is_compiled: true,
1429        sort_len: 1,
1430        max_len: 1,
1431    };
1432    /// Windows Central European
1433    const CP1250_CROATIAN_CI_COLLATION: Collation<'static> = Collation {
1434        id: CollationId::CP1250_CROATIAN_CI,
1435        charset: "cp1250",
1436        collation: "cp1250_croatian_ci",
1437        is_default: false,
1438        padding: PadAttribute::PadSpace,
1439        is_compiled: true,
1440        sort_len: 1,
1441        max_len: 1,
1442    };
1443    /// UTF-8 Unicode
1444    const UTF8MB4_GENERAL_CI_COLLATION: Collation<'static> = Collation {
1445        id: CollationId::UTF8MB4_GENERAL_CI,
1446        charset: "utf8mb4",
1447        collation: "utf8mb4_general_ci",
1448        is_default: false,
1449        padding: PadAttribute::PadSpace,
1450        is_compiled: true,
1451        sort_len: 1,
1452        max_len: 4,
1453    };
1454    /// UTF-8 Unicode
1455    const UTF8MB4_BIN_COLLATION: Collation<'static> = Collation {
1456        id: CollationId::UTF8MB4_BIN,
1457        charset: "utf8mb4",
1458        collation: "utf8mb4_bin",
1459        is_default: false,
1460        padding: PadAttribute::PadSpace,
1461        is_compiled: true,
1462        sort_len: 1,
1463        max_len: 4,
1464    };
1465    /// cp1252 West European
1466    const LATIN1_BIN_COLLATION: Collation<'static> = Collation {
1467        id: CollationId::LATIN1_BIN,
1468        charset: "latin1",
1469        collation: "latin1_bin",
1470        is_default: false,
1471        padding: PadAttribute::PadSpace,
1472        is_compiled: true,
1473        sort_len: 1,
1474        max_len: 1,
1475    };
1476    /// cp1252 West European
1477    const LATIN1_GENERAL_CI_COLLATION: Collation<'static> = Collation {
1478        id: CollationId::LATIN1_GENERAL_CI,
1479        charset: "latin1",
1480        collation: "latin1_general_ci",
1481        is_default: false,
1482        padding: PadAttribute::PadSpace,
1483        is_compiled: true,
1484        sort_len: 1,
1485        max_len: 1,
1486    };
1487    /// cp1252 West European
1488    const LATIN1_GENERAL_CS_COLLATION: Collation<'static> = Collation {
1489        id: CollationId::LATIN1_GENERAL_CS,
1490        charset: "latin1",
1491        collation: "latin1_general_cs",
1492        is_default: false,
1493        padding: PadAttribute::PadSpace,
1494        is_compiled: true,
1495        sort_len: 1,
1496        max_len: 1,
1497    };
1498    /// Windows Cyrillic
1499    const CP1251_BIN_COLLATION: Collation<'static> = Collation {
1500        id: CollationId::CP1251_BIN,
1501        charset: "cp1251",
1502        collation: "cp1251_bin",
1503        is_default: false,
1504        padding: PadAttribute::PadSpace,
1505        is_compiled: true,
1506        sort_len: 1,
1507        max_len: 1,
1508    };
1509    /// Windows Cyrillic
1510    const CP1251_GENERAL_CI_COLLATION: Collation<'static> = Collation {
1511        id: CollationId::CP1251_GENERAL_CI,
1512        charset: "cp1251",
1513        collation: "cp1251_general_ci",
1514        is_default: true,
1515        padding: PadAttribute::PadSpace,
1516        is_compiled: true,
1517        sort_len: 1,
1518        max_len: 1,
1519    };
1520    /// Windows Cyrillic
1521    const CP1251_GENERAL_CS_COLLATION: Collation<'static> = Collation {
1522        id: CollationId::CP1251_GENERAL_CS,
1523        charset: "cp1251",
1524        collation: "cp1251_general_cs",
1525        is_default: false,
1526        padding: PadAttribute::PadSpace,
1527        is_compiled: true,
1528        sort_len: 1,
1529        max_len: 1,
1530    };
1531    /// Mac West European
1532    const MACROMAN_BIN_COLLATION: Collation<'static> = Collation {
1533        id: CollationId::MACROMAN_BIN,
1534        charset: "macroman",
1535        collation: "macroman_bin",
1536        is_default: false,
1537        padding: PadAttribute::PadSpace,
1538        is_compiled: true,
1539        sort_len: 1,
1540        max_len: 1,
1541    };
1542    /// UTF-16 Unicode
1543    const UTF16_GENERAL_CI_COLLATION: Collation<'static> = Collation {
1544        id: CollationId::UTF16_GENERAL_CI,
1545        charset: "utf16",
1546        collation: "utf16_general_ci",
1547        is_default: true,
1548        padding: PadAttribute::PadSpace,
1549        is_compiled: true,
1550        sort_len: 1,
1551        max_len: 4,
1552    };
1553    /// UTF-16 Unicode
1554    const UTF16_BIN_COLLATION: Collation<'static> = Collation {
1555        id: CollationId::UTF16_BIN,
1556        charset: "utf16",
1557        collation: "utf16_bin",
1558        is_default: false,
1559        padding: PadAttribute::PadSpace,
1560        is_compiled: true,
1561        sort_len: 1,
1562        max_len: 4,
1563    };
1564    /// UTF-16LE Unicode
1565    const UTF16LE_GENERAL_CI_COLLATION: Collation<'static> = Collation {
1566        id: CollationId::UTF16LE_GENERAL_CI,
1567        charset: "utf16le",
1568        collation: "utf16le_general_ci",
1569        is_default: true,
1570        padding: PadAttribute::PadSpace,
1571        is_compiled: true,
1572        sort_len: 1,
1573        max_len: 4,
1574    };
1575    /// Windows Arabic
1576    const CP1256_GENERAL_CI_COLLATION: Collation<'static> = Collation {
1577        id: CollationId::CP1256_GENERAL_CI,
1578        charset: "cp1256",
1579        collation: "cp1256_general_ci",
1580        is_default: true,
1581        padding: PadAttribute::PadSpace,
1582        is_compiled: true,
1583        sort_len: 1,
1584        max_len: 1,
1585    };
1586    /// Windows Baltic
1587    const CP1257_BIN_COLLATION: Collation<'static> = Collation {
1588        id: CollationId::CP1257_BIN,
1589        charset: "cp1257",
1590        collation: "cp1257_bin",
1591        is_default: false,
1592        padding: PadAttribute::PadSpace,
1593        is_compiled: true,
1594        sort_len: 1,
1595        max_len: 1,
1596    };
1597    /// Windows Baltic
1598    const CP1257_GENERAL_CI_COLLATION: Collation<'static> = Collation {
1599        id: CollationId::CP1257_GENERAL_CI,
1600        charset: "cp1257",
1601        collation: "cp1257_general_ci",
1602        is_default: true,
1603        padding: PadAttribute::PadSpace,
1604        is_compiled: true,
1605        sort_len: 1,
1606        max_len: 1,
1607    };
1608    /// UTF-32 Unicode
1609    const UTF32_GENERAL_CI_COLLATION: Collation<'static> = Collation {
1610        id: CollationId::UTF32_GENERAL_CI,
1611        charset: "utf32",
1612        collation: "utf32_general_ci",
1613        is_default: true,
1614        padding: PadAttribute::PadSpace,
1615        is_compiled: true,
1616        sort_len: 1,
1617        max_len: 4,
1618    };
1619    /// UTF-32 Unicode
1620    const UTF32_BIN_COLLATION: Collation<'static> = Collation {
1621        id: CollationId::UTF32_BIN,
1622        charset: "utf32",
1623        collation: "utf32_bin",
1624        is_default: false,
1625        padding: PadAttribute::PadSpace,
1626        is_compiled: true,
1627        sort_len: 1,
1628        max_len: 4,
1629    };
1630    /// UTF-16LE Unicode
1631    const UTF16LE_BIN_COLLATION: Collation<'static> = Collation {
1632        id: CollationId::UTF16LE_BIN,
1633        charset: "utf16le",
1634        collation: "utf16le_bin",
1635        is_default: false,
1636        padding: PadAttribute::PadSpace,
1637        is_compiled: true,
1638        sort_len: 1,
1639        max_len: 4,
1640    };
1641    /// Binary pseudo charset
1642    const BINARY_COLLATION: Collation<'static> = Collation {
1643        id: CollationId::BINARY,
1644        charset: "binary",
1645        collation: "binary",
1646        is_default: true,
1647        padding: PadAttribute::PadZero,
1648        is_compiled: true,
1649        sort_len: 1,
1650        max_len: 1,
1651    };
1652    /// ARMSCII-8 Armenian
1653    const ARMSCII8_BIN_COLLATION: Collation<'static> = Collation {
1654        id: CollationId::ARMSCII8_BIN,
1655        charset: "armscii8",
1656        collation: "armscii8_bin",
1657        is_default: false,
1658        padding: PadAttribute::PadSpace,
1659        is_compiled: true,
1660        sort_len: 1,
1661        max_len: 1,
1662    };
1663    /// US ASCII
1664    const ASCII_BIN_COLLATION: Collation<'static> = Collation {
1665        id: CollationId::ASCII_BIN,
1666        charset: "ascii",
1667        collation: "ascii_bin",
1668        is_default: false,
1669        padding: PadAttribute::PadSpace,
1670        is_compiled: true,
1671        sort_len: 1,
1672        max_len: 1,
1673    };
1674    /// Windows Central European
1675    const CP1250_BIN_COLLATION: Collation<'static> = Collation {
1676        id: CollationId::CP1250_BIN,
1677        charset: "cp1250",
1678        collation: "cp1250_bin",
1679        is_default: false,
1680        padding: PadAttribute::PadSpace,
1681        is_compiled: true,
1682        sort_len: 1,
1683        max_len: 1,
1684    };
1685    /// Windows Arabic
1686    const CP1256_BIN_COLLATION: Collation<'static> = Collation {
1687        id: CollationId::CP1256_BIN,
1688        charset: "cp1256",
1689        collation: "cp1256_bin",
1690        is_default: false,
1691        padding: PadAttribute::PadSpace,
1692        is_compiled: true,
1693        sort_len: 1,
1694        max_len: 1,
1695    };
1696    /// DOS Russian
1697    const CP866_BIN_COLLATION: Collation<'static> = Collation {
1698        id: CollationId::CP866_BIN,
1699        charset: "cp866",
1700        collation: "cp866_bin",
1701        is_default: false,
1702        padding: PadAttribute::PadSpace,
1703        is_compiled: true,
1704        sort_len: 1,
1705        max_len: 1,
1706    };
1707    /// DEC West European
1708    const DEC8_BIN_COLLATION: Collation<'static> = Collation {
1709        id: CollationId::DEC8_BIN,
1710        charset: "dec8",
1711        collation: "dec8_bin",
1712        is_default: false,
1713        padding: PadAttribute::PadSpace,
1714        is_compiled: true,
1715        sort_len: 1,
1716        max_len: 1,
1717    };
1718    /// ISO 8859-7 Greek
1719    const GREEK_BIN_COLLATION: Collation<'static> = Collation {
1720        id: CollationId::GREEK_BIN,
1721        charset: "greek",
1722        collation: "greek_bin",
1723        is_default: false,
1724        padding: PadAttribute::PadSpace,
1725        is_compiled: true,
1726        sort_len: 1,
1727        max_len: 1,
1728    };
1729    /// ISO 8859-8 Hebrew
1730    const HEBREW_BIN_COLLATION: Collation<'static> = Collation {
1731        id: CollationId::HEBREW_BIN,
1732        charset: "hebrew",
1733        collation: "hebrew_bin",
1734        is_default: false,
1735        padding: PadAttribute::PadSpace,
1736        is_compiled: true,
1737        sort_len: 1,
1738        max_len: 1,
1739    };
1740    /// HP West European
1741    const HP8_BIN_COLLATION: Collation<'static> = Collation {
1742        id: CollationId::HP8_BIN,
1743        charset: "hp8",
1744        collation: "hp8_bin",
1745        is_default: false,
1746        padding: PadAttribute::PadSpace,
1747        is_compiled: true,
1748        sort_len: 1,
1749        max_len: 1,
1750    };
1751    /// DOS Kamenicky Czech-Slovak
1752    const KEYBCS2_BIN_COLLATION: Collation<'static> = Collation {
1753        id: CollationId::KEYBCS2_BIN,
1754        charset: "keybcs2",
1755        collation: "keybcs2_bin",
1756        is_default: false,
1757        padding: PadAttribute::PadSpace,
1758        is_compiled: true,
1759        sort_len: 1,
1760        max_len: 1,
1761    };
1762    /// KOI8-R Relcom Russian
1763    const KOI8R_BIN_COLLATION: Collation<'static> = Collation {
1764        id: CollationId::KOI8R_BIN,
1765        charset: "koi8r",
1766        collation: "koi8r_bin",
1767        is_default: false,
1768        padding: PadAttribute::PadSpace,
1769        is_compiled: true,
1770        sort_len: 1,
1771        max_len: 1,
1772    };
1773    /// KOI8-U Ukrainian
1774    const KOI8U_BIN_COLLATION: Collation<'static> = Collation {
1775        id: CollationId::KOI8U_BIN,
1776        charset: "koi8u",
1777        collation: "koi8u_bin",
1778        is_default: false,
1779        padding: PadAttribute::PadSpace,
1780        is_compiled: true,
1781        sort_len: 1,
1782        max_len: 1,
1783    };
1784    /// UTF-8 Unicode
1785    const UTF8MB3_TOLOWER_CI_COLLATION: Collation<'static> = Collation {
1786        id: CollationId::UTF8MB3_TOLOWER_CI,
1787        charset: "utf8mb3",
1788        collation: "utf8mb3_tolower_ci",
1789        is_default: false,
1790        padding: PadAttribute::PadSpace,
1791        is_compiled: true,
1792        sort_len: 1,
1793        max_len: 3,
1794    };
1795    /// ISO 8859-2 Central European
1796    const LATIN2_BIN_COLLATION: Collation<'static> = Collation {
1797        id: CollationId::LATIN2_BIN,
1798        charset: "latin2",
1799        collation: "latin2_bin",
1800        is_default: false,
1801        padding: PadAttribute::PadSpace,
1802        is_compiled: true,
1803        sort_len: 1,
1804        max_len: 1,
1805    };
1806    /// ISO 8859-9 Turkish
1807    const LATIN5_BIN_COLLATION: Collation<'static> = Collation {
1808        id: CollationId::LATIN5_BIN,
1809        charset: "latin5",
1810        collation: "latin5_bin",
1811        is_default: false,
1812        padding: PadAttribute::PadSpace,
1813        is_compiled: true,
1814        sort_len: 1,
1815        max_len: 1,
1816    };
1817    /// ISO 8859-13 Baltic
1818    const LATIN7_BIN_COLLATION: Collation<'static> = Collation {
1819        id: CollationId::LATIN7_BIN,
1820        charset: "latin7",
1821        collation: "latin7_bin",
1822        is_default: false,
1823        padding: PadAttribute::PadSpace,
1824        is_compiled: true,
1825        sort_len: 1,
1826        max_len: 1,
1827    };
1828    /// DOS West European
1829    const CP850_BIN_COLLATION: Collation<'static> = Collation {
1830        id: CollationId::CP850_BIN,
1831        charset: "cp850",
1832        collation: "cp850_bin",
1833        is_default: false,
1834        padding: PadAttribute::PadSpace,
1835        is_compiled: true,
1836        sort_len: 1,
1837        max_len: 1,
1838    };
1839    /// DOS Central European
1840    const CP852_BIN_COLLATION: Collation<'static> = Collation {
1841        id: CollationId::CP852_BIN,
1842        charset: "cp852",
1843        collation: "cp852_bin",
1844        is_default: false,
1845        padding: PadAttribute::PadSpace,
1846        is_compiled: true,
1847        sort_len: 1,
1848        max_len: 1,
1849    };
1850    /// 7bit Swedish
1851    const SWE7_BIN_COLLATION: Collation<'static> = Collation {
1852        id: CollationId::SWE7_BIN,
1853        charset: "swe7",
1854        collation: "swe7_bin",
1855        is_default: false,
1856        padding: PadAttribute::PadSpace,
1857        is_compiled: true,
1858        sort_len: 1,
1859        max_len: 1,
1860    };
1861    /// UTF-8 Unicode
1862    const UTF8MB3_BIN_COLLATION: Collation<'static> = Collation {
1863        id: CollationId::UTF8MB3_BIN,
1864        charset: "utf8mb3",
1865        collation: "utf8mb3_bin",
1866        is_default: false,
1867        padding: PadAttribute::PadSpace,
1868        is_compiled: true,
1869        sort_len: 1,
1870        max_len: 3,
1871    };
1872    /// Big5 Traditional Chinese
1873    const BIG5_BIN_COLLATION: Collation<'static> = Collation {
1874        id: CollationId::BIG5_BIN,
1875        charset: "big5",
1876        collation: "big5_bin",
1877        is_default: false,
1878        padding: PadAttribute::PadSpace,
1879        is_compiled: true,
1880        sort_len: 1,
1881        max_len: 2,
1882    };
1883    /// EUC-KR Korean
1884    const EUCKR_BIN_COLLATION: Collation<'static> = Collation {
1885        id: CollationId::EUCKR_BIN,
1886        charset: "euckr",
1887        collation: "euckr_bin",
1888        is_default: false,
1889        padding: PadAttribute::PadSpace,
1890        is_compiled: true,
1891        sort_len: 1,
1892        max_len: 2,
1893    };
1894    /// GB2312 Simplified Chinese
1895    const GB2312_BIN_COLLATION: Collation<'static> = Collation {
1896        id: CollationId::GB2312_BIN,
1897        charset: "gb2312",
1898        collation: "gb2312_bin",
1899        is_default: false,
1900        padding: PadAttribute::PadSpace,
1901        is_compiled: true,
1902        sort_len: 1,
1903        max_len: 2,
1904    };
1905    /// GBK Simplified Chinese
1906    const GBK_BIN_COLLATION: Collation<'static> = Collation {
1907        id: CollationId::GBK_BIN,
1908        charset: "gbk",
1909        collation: "gbk_bin",
1910        is_default: false,
1911        padding: PadAttribute::PadSpace,
1912        is_compiled: true,
1913        sort_len: 1,
1914        max_len: 2,
1915    };
1916    /// Shift-JIS Japanese
1917    const SJIS_BIN_COLLATION: Collation<'static> = Collation {
1918        id: CollationId::SJIS_BIN,
1919        charset: "sjis",
1920        collation: "sjis_bin",
1921        is_default: false,
1922        padding: PadAttribute::PadSpace,
1923        is_compiled: true,
1924        sort_len: 1,
1925        max_len: 2,
1926    };
1927    /// TIS620 Thai
1928    const TIS620_BIN_COLLATION: Collation<'static> = Collation {
1929        id: CollationId::TIS620_BIN,
1930        charset: "tis620",
1931        collation: "tis620_bin",
1932        is_default: false,
1933        padding: PadAttribute::PadSpace,
1934        is_compiled: true,
1935        sort_len: 1,
1936        max_len: 1,
1937    };
1938    /// UCS-2 Unicode
1939    const UCS2_BIN_COLLATION: Collation<'static> = Collation {
1940        id: CollationId::UCS2_BIN,
1941        charset: "ucs2",
1942        collation: "ucs2_bin",
1943        is_default: false,
1944        padding: PadAttribute::PadSpace,
1945        is_compiled: true,
1946        sort_len: 1,
1947        max_len: 2,
1948    };
1949    /// EUC-JP Japanese
1950    const UJIS_BIN_COLLATION: Collation<'static> = Collation {
1951        id: CollationId::UJIS_BIN,
1952        charset: "ujis",
1953        collation: "ujis_bin",
1954        is_default: false,
1955        padding: PadAttribute::PadSpace,
1956        is_compiled: true,
1957        sort_len: 1,
1958        max_len: 3,
1959    };
1960    /// GEOSTD8 Georgian
1961    const GEOSTD8_GENERAL_CI_COLLATION: Collation<'static> = Collation {
1962        id: CollationId::GEOSTD8_GENERAL_CI,
1963        charset: "geostd8",
1964        collation: "geostd8_general_ci",
1965        is_default: true,
1966        padding: PadAttribute::PadSpace,
1967        is_compiled: true,
1968        sort_len: 1,
1969        max_len: 1,
1970    };
1971    /// GEOSTD8 Georgian
1972    const GEOSTD8_BIN_COLLATION: Collation<'static> = Collation {
1973        id: CollationId::GEOSTD8_BIN,
1974        charset: "geostd8",
1975        collation: "geostd8_bin",
1976        is_default: false,
1977        padding: PadAttribute::PadSpace,
1978        is_compiled: true,
1979        sort_len: 1,
1980        max_len: 1,
1981    };
1982    /// cp1252 West European
1983    const LATIN1_SPANISH_CI_COLLATION: Collation<'static> = Collation {
1984        id: CollationId::LATIN1_SPANISH_CI,
1985        charset: "latin1",
1986        collation: "latin1_spanish_ci",
1987        is_default: false,
1988        padding: PadAttribute::PadSpace,
1989        is_compiled: true,
1990        sort_len: 1,
1991        max_len: 1,
1992    };
1993    /// SJIS for Windows Japanese
1994    const CP932_JAPANESE_CI_COLLATION: Collation<'static> = Collation {
1995        id: CollationId::CP932_JAPANESE_CI,
1996        charset: "cp932",
1997        collation: "cp932_japanese_ci",
1998        is_default: true,
1999        padding: PadAttribute::PadSpace,
2000        is_compiled: true,
2001        sort_len: 1,
2002        max_len: 2,
2003    };
2004    /// SJIS for Windows Japanese
2005    const CP932_BIN_COLLATION: Collation<'static> = Collation {
2006        id: CollationId::CP932_BIN,
2007        charset: "cp932",
2008        collation: "cp932_bin",
2009        is_default: false,
2010        padding: PadAttribute::PadSpace,
2011        is_compiled: true,
2012        sort_len: 1,
2013        max_len: 2,
2014    };
2015    /// UJIS for Windows Japanese
2016    const EUCJPMS_JAPANESE_CI_COLLATION: Collation<'static> = Collation {
2017        id: CollationId::EUCJPMS_JAPANESE_CI,
2018        charset: "eucjpms",
2019        collation: "eucjpms_japanese_ci",
2020        is_default: true,
2021        padding: PadAttribute::PadSpace,
2022        is_compiled: true,
2023        sort_len: 1,
2024        max_len: 3,
2025    };
2026    /// UJIS for Windows Japanese
2027    const EUCJPMS_BIN_COLLATION: Collation<'static> = Collation {
2028        id: CollationId::EUCJPMS_BIN,
2029        charset: "eucjpms",
2030        collation: "eucjpms_bin",
2031        is_default: false,
2032        padding: PadAttribute::PadSpace,
2033        is_compiled: true,
2034        sort_len: 1,
2035        max_len: 3,
2036    };
2037    /// Windows Central European
2038    const CP1250_POLISH_CI_COLLATION: Collation<'static> = Collation {
2039        id: CollationId::CP1250_POLISH_CI,
2040        charset: "cp1250",
2041        collation: "cp1250_polish_ci",
2042        is_default: false,
2043        padding: PadAttribute::PadSpace,
2044        is_compiled: true,
2045        sort_len: 1,
2046        max_len: 1,
2047    };
2048    /// UTF-16 Unicode
2049    const UTF16_UNICODE_CI_COLLATION: Collation<'static> = Collation {
2050        id: CollationId::UTF16_UNICODE_CI,
2051        charset: "utf16",
2052        collation: "utf16_unicode_ci",
2053        is_default: false,
2054        padding: PadAttribute::PadSpace,
2055        is_compiled: true,
2056        sort_len: 8,
2057        max_len: 4,
2058    };
2059    /// UTF-16 Unicode
2060    const UTF16_ICELANDIC_CI_COLLATION: Collation<'static> = Collation {
2061        id: CollationId::UTF16_ICELANDIC_CI,
2062        charset: "utf16",
2063        collation: "utf16_icelandic_ci",
2064        is_default: false,
2065        padding: PadAttribute::PadSpace,
2066        is_compiled: true,
2067        sort_len: 8,
2068        max_len: 4,
2069    };
2070    /// UTF-16 Unicode
2071    const UTF16_LATVIAN_CI_COLLATION: Collation<'static> = Collation {
2072        id: CollationId::UTF16_LATVIAN_CI,
2073        charset: "utf16",
2074        collation: "utf16_latvian_ci",
2075        is_default: false,
2076        padding: PadAttribute::PadSpace,
2077        is_compiled: true,
2078        sort_len: 8,
2079        max_len: 4,
2080    };
2081    /// UTF-16 Unicode
2082    const UTF16_ROMANIAN_CI_COLLATION: Collation<'static> = Collation {
2083        id: CollationId::UTF16_ROMANIAN_CI,
2084        charset: "utf16",
2085        collation: "utf16_romanian_ci",
2086        is_default: false,
2087        padding: PadAttribute::PadSpace,
2088        is_compiled: true,
2089        sort_len: 8,
2090        max_len: 4,
2091    };
2092    /// UTF-16 Unicode
2093    const UTF16_SLOVENIAN_CI_COLLATION: Collation<'static> = Collation {
2094        id: CollationId::UTF16_SLOVENIAN_CI,
2095        charset: "utf16",
2096        collation: "utf16_slovenian_ci",
2097        is_default: false,
2098        padding: PadAttribute::PadSpace,
2099        is_compiled: true,
2100        sort_len: 8,
2101        max_len: 4,
2102    };
2103    /// UTF-16 Unicode
2104    const UTF16_POLISH_CI_COLLATION: Collation<'static> = Collation {
2105        id: CollationId::UTF16_POLISH_CI,
2106        charset: "utf16",
2107        collation: "utf16_polish_ci",
2108        is_default: false,
2109        padding: PadAttribute::PadSpace,
2110        is_compiled: true,
2111        sort_len: 8,
2112        max_len: 4,
2113    };
2114    /// UTF-16 Unicode
2115    const UTF16_ESTONIAN_CI_COLLATION: Collation<'static> = Collation {
2116        id: CollationId::UTF16_ESTONIAN_CI,
2117        charset: "utf16",
2118        collation: "utf16_estonian_ci",
2119        is_default: false,
2120        padding: PadAttribute::PadSpace,
2121        is_compiled: true,
2122        sort_len: 8,
2123        max_len: 4,
2124    };
2125    /// UTF-16 Unicode
2126    const UTF16_SPANISH_CI_COLLATION: Collation<'static> = Collation {
2127        id: CollationId::UTF16_SPANISH_CI,
2128        charset: "utf16",
2129        collation: "utf16_spanish_ci",
2130        is_default: false,
2131        padding: PadAttribute::PadSpace,
2132        is_compiled: true,
2133        sort_len: 8,
2134        max_len: 4,
2135    };
2136    /// UTF-16 Unicode
2137    const UTF16_SWEDISH_CI_COLLATION: Collation<'static> = Collation {
2138        id: CollationId::UTF16_SWEDISH_CI,
2139        charset: "utf16",
2140        collation: "utf16_swedish_ci",
2141        is_default: false,
2142        padding: PadAttribute::PadSpace,
2143        is_compiled: true,
2144        sort_len: 8,
2145        max_len: 4,
2146    };
2147    /// UTF-16 Unicode
2148    const UTF16_TURKISH_CI_COLLATION: Collation<'static> = Collation {
2149        id: CollationId::UTF16_TURKISH_CI,
2150        charset: "utf16",
2151        collation: "utf16_turkish_ci",
2152        is_default: false,
2153        padding: PadAttribute::PadSpace,
2154        is_compiled: true,
2155        sort_len: 8,
2156        max_len: 4,
2157    };
2158    /// UTF-16 Unicode
2159    const UTF16_CZECH_CI_COLLATION: Collation<'static> = Collation {
2160        id: CollationId::UTF16_CZECH_CI,
2161        charset: "utf16",
2162        collation: "utf16_czech_ci",
2163        is_default: false,
2164        padding: PadAttribute::PadSpace,
2165        is_compiled: true,
2166        sort_len: 8,
2167        max_len: 4,
2168    };
2169    /// UTF-16 Unicode
2170    const UTF16_DANISH_CI_COLLATION: Collation<'static> = Collation {
2171        id: CollationId::UTF16_DANISH_CI,
2172        charset: "utf16",
2173        collation: "utf16_danish_ci",
2174        is_default: false,
2175        padding: PadAttribute::PadSpace,
2176        is_compiled: true,
2177        sort_len: 8,
2178        max_len: 4,
2179    };
2180    /// UTF-16 Unicode
2181    const UTF16_LITHUANIAN_CI_COLLATION: Collation<'static> = Collation {
2182        id: CollationId::UTF16_LITHUANIAN_CI,
2183        charset: "utf16",
2184        collation: "utf16_lithuanian_ci",
2185        is_default: false,
2186        padding: PadAttribute::PadSpace,
2187        is_compiled: true,
2188        sort_len: 8,
2189        max_len: 4,
2190    };
2191    /// UTF-16 Unicode
2192    const UTF16_SLOVAK_CI_COLLATION: Collation<'static> = Collation {
2193        id: CollationId::UTF16_SLOVAK_CI,
2194        charset: "utf16",
2195        collation: "utf16_slovak_ci",
2196        is_default: false,
2197        padding: PadAttribute::PadSpace,
2198        is_compiled: true,
2199        sort_len: 8,
2200        max_len: 4,
2201    };
2202    /// UTF-16 Unicode
2203    const UTF16_SPANISH2_CI_COLLATION: Collation<'static> = Collation {
2204        id: CollationId::UTF16_SPANISH2_CI,
2205        charset: "utf16",
2206        collation: "utf16_spanish2_ci",
2207        is_default: false,
2208        padding: PadAttribute::PadSpace,
2209        is_compiled: true,
2210        sort_len: 8,
2211        max_len: 4,
2212    };
2213    /// UTF-16 Unicode
2214    const UTF16_ROMAN_CI_COLLATION: Collation<'static> = Collation {
2215        id: CollationId::UTF16_ROMAN_CI,
2216        charset: "utf16",
2217        collation: "utf16_roman_ci",
2218        is_default: false,
2219        padding: PadAttribute::PadSpace,
2220        is_compiled: true,
2221        sort_len: 8,
2222        max_len: 4,
2223    };
2224    /// UTF-16 Unicode
2225    const UTF16_PERSIAN_CI_COLLATION: Collation<'static> = Collation {
2226        id: CollationId::UTF16_PERSIAN_CI,
2227        charset: "utf16",
2228        collation: "utf16_persian_ci",
2229        is_default: false,
2230        padding: PadAttribute::PadSpace,
2231        is_compiled: true,
2232        sort_len: 8,
2233        max_len: 4,
2234    };
2235    /// UTF-16 Unicode
2236    const UTF16_ESPERANTO_CI_COLLATION: Collation<'static> = Collation {
2237        id: CollationId::UTF16_ESPERANTO_CI,
2238        charset: "utf16",
2239        collation: "utf16_esperanto_ci",
2240        is_default: false,
2241        padding: PadAttribute::PadSpace,
2242        is_compiled: true,
2243        sort_len: 8,
2244        max_len: 4,
2245    };
2246    /// UTF-16 Unicode
2247    const UTF16_HUNGARIAN_CI_COLLATION: Collation<'static> = Collation {
2248        id: CollationId::UTF16_HUNGARIAN_CI,
2249        charset: "utf16",
2250        collation: "utf16_hungarian_ci",
2251        is_default: false,
2252        padding: PadAttribute::PadSpace,
2253        is_compiled: true,
2254        sort_len: 8,
2255        max_len: 4,
2256    };
2257    /// UTF-16 Unicode
2258    const UTF16_SINHALA_CI_COLLATION: Collation<'static> = Collation {
2259        id: CollationId::UTF16_SINHALA_CI,
2260        charset: "utf16",
2261        collation: "utf16_sinhala_ci",
2262        is_default: false,
2263        padding: PadAttribute::PadSpace,
2264        is_compiled: true,
2265        sort_len: 8,
2266        max_len: 4,
2267    };
2268    /// UTF-16 Unicode
2269    const UTF16_GERMAN2_CI_COLLATION: Collation<'static> = Collation {
2270        id: CollationId::UTF16_GERMAN2_CI,
2271        charset: "utf16",
2272        collation: "utf16_german2_ci",
2273        is_default: false,
2274        padding: PadAttribute::PadSpace,
2275        is_compiled: true,
2276        sort_len: 8,
2277        max_len: 4,
2278    };
2279    /// UTF-16 Unicode
2280    const UTF16_CROATIAN_CI_COLLATION: Collation<'static> = Collation {
2281        id: CollationId::UTF16_CROATIAN_CI,
2282        charset: "utf16",
2283        collation: "utf16_croatian_ci",
2284        is_default: false,
2285        padding: PadAttribute::PadSpace,
2286        is_compiled: true,
2287        sort_len: 8,
2288        max_len: 4,
2289    };
2290    /// UTF-16 Unicode
2291    const UTF16_UNICODE_520_CI_COLLATION: Collation<'static> = Collation {
2292        id: CollationId::UTF16_UNICODE_520_CI,
2293        charset: "utf16",
2294        collation: "utf16_unicode_520_ci",
2295        is_default: false,
2296        padding: PadAttribute::PadSpace,
2297        is_compiled: true,
2298        sort_len: 8,
2299        max_len: 4,
2300    };
2301    /// UTF-16 Unicode
2302    const UTF16_VIETNAMESE_CI_COLLATION: Collation<'static> = Collation {
2303        id: CollationId::UTF16_VIETNAMESE_CI,
2304        charset: "utf16",
2305        collation: "utf16_vietnamese_ci",
2306        is_default: false,
2307        padding: PadAttribute::PadSpace,
2308        is_compiled: true,
2309        sort_len: 8,
2310        max_len: 4,
2311    };
2312    /// UCS-2 Unicode
2313    const UCS2_UNICODE_CI_COLLATION: Collation<'static> = Collation {
2314        id: CollationId::UCS2_UNICODE_CI,
2315        charset: "ucs2",
2316        collation: "ucs2_unicode_ci",
2317        is_default: false,
2318        padding: PadAttribute::PadSpace,
2319        is_compiled: true,
2320        sort_len: 8,
2321        max_len: 2,
2322    };
2323    /// UCS-2 Unicode
2324    const UCS2_ICELANDIC_CI_COLLATION: Collation<'static> = Collation {
2325        id: CollationId::UCS2_ICELANDIC_CI,
2326        charset: "ucs2",
2327        collation: "ucs2_icelandic_ci",
2328        is_default: false,
2329        padding: PadAttribute::PadSpace,
2330        is_compiled: true,
2331        sort_len: 8,
2332        max_len: 2,
2333    };
2334    /// UCS-2 Unicode
2335    const UCS2_LATVIAN_CI_COLLATION: Collation<'static> = Collation {
2336        id: CollationId::UCS2_LATVIAN_CI,
2337        charset: "ucs2",
2338        collation: "ucs2_latvian_ci",
2339        is_default: false,
2340        padding: PadAttribute::PadSpace,
2341        is_compiled: true,
2342        sort_len: 8,
2343        max_len: 2,
2344    };
2345    /// UCS-2 Unicode
2346    const UCS2_ROMANIAN_CI_COLLATION: Collation<'static> = Collation {
2347        id: CollationId::UCS2_ROMANIAN_CI,
2348        charset: "ucs2",
2349        collation: "ucs2_romanian_ci",
2350        is_default: false,
2351        padding: PadAttribute::PadSpace,
2352        is_compiled: true,
2353        sort_len: 8,
2354        max_len: 2,
2355    };
2356    /// UCS-2 Unicode
2357    const UCS2_SLOVENIAN_CI_COLLATION: Collation<'static> = Collation {
2358        id: CollationId::UCS2_SLOVENIAN_CI,
2359        charset: "ucs2",
2360        collation: "ucs2_slovenian_ci",
2361        is_default: false,
2362        padding: PadAttribute::PadSpace,
2363        is_compiled: true,
2364        sort_len: 8,
2365        max_len: 2,
2366    };
2367    /// UCS-2 Unicode
2368    const UCS2_POLISH_CI_COLLATION: Collation<'static> = Collation {
2369        id: CollationId::UCS2_POLISH_CI,
2370        charset: "ucs2",
2371        collation: "ucs2_polish_ci",
2372        is_default: false,
2373        padding: PadAttribute::PadSpace,
2374        is_compiled: true,
2375        sort_len: 8,
2376        max_len: 2,
2377    };
2378    /// UCS-2 Unicode
2379    const UCS2_ESTONIAN_CI_COLLATION: Collation<'static> = Collation {
2380        id: CollationId::UCS2_ESTONIAN_CI,
2381        charset: "ucs2",
2382        collation: "ucs2_estonian_ci",
2383        is_default: false,
2384        padding: PadAttribute::PadSpace,
2385        is_compiled: true,
2386        sort_len: 8,
2387        max_len: 2,
2388    };
2389    /// UCS-2 Unicode
2390    const UCS2_SPANISH_CI_COLLATION: Collation<'static> = Collation {
2391        id: CollationId::UCS2_SPANISH_CI,
2392        charset: "ucs2",
2393        collation: "ucs2_spanish_ci",
2394        is_default: false,
2395        padding: PadAttribute::PadSpace,
2396        is_compiled: true,
2397        sort_len: 8,
2398        max_len: 2,
2399    };
2400    /// UCS-2 Unicode
2401    const UCS2_SWEDISH_CI_COLLATION: Collation<'static> = Collation {
2402        id: CollationId::UCS2_SWEDISH_CI,
2403        charset: "ucs2",
2404        collation: "ucs2_swedish_ci",
2405        is_default: false,
2406        padding: PadAttribute::PadSpace,
2407        is_compiled: true,
2408        sort_len: 8,
2409        max_len: 2,
2410    };
2411    /// UCS-2 Unicode
2412    const UCS2_TURKISH_CI_COLLATION: Collation<'static> = Collation {
2413        id: CollationId::UCS2_TURKISH_CI,
2414        charset: "ucs2",
2415        collation: "ucs2_turkish_ci",
2416        is_default: false,
2417        padding: PadAttribute::PadSpace,
2418        is_compiled: true,
2419        sort_len: 8,
2420        max_len: 2,
2421    };
2422    /// UCS-2 Unicode
2423    const UCS2_CZECH_CI_COLLATION: Collation<'static> = Collation {
2424        id: CollationId::UCS2_CZECH_CI,
2425        charset: "ucs2",
2426        collation: "ucs2_czech_ci",
2427        is_default: false,
2428        padding: PadAttribute::PadSpace,
2429        is_compiled: true,
2430        sort_len: 8,
2431        max_len: 2,
2432    };
2433    /// UCS-2 Unicode
2434    const UCS2_DANISH_CI_COLLATION: Collation<'static> = Collation {
2435        id: CollationId::UCS2_DANISH_CI,
2436        charset: "ucs2",
2437        collation: "ucs2_danish_ci",
2438        is_default: false,
2439        padding: PadAttribute::PadSpace,
2440        is_compiled: true,
2441        sort_len: 8,
2442        max_len: 2,
2443    };
2444    /// UCS-2 Unicode
2445    const UCS2_LITHUANIAN_CI_COLLATION: Collation<'static> = Collation {
2446        id: CollationId::UCS2_LITHUANIAN_CI,
2447        charset: "ucs2",
2448        collation: "ucs2_lithuanian_ci",
2449        is_default: false,
2450        padding: PadAttribute::PadSpace,
2451        is_compiled: true,
2452        sort_len: 8,
2453        max_len: 2,
2454    };
2455    /// UCS-2 Unicode
2456    const UCS2_SLOVAK_CI_COLLATION: Collation<'static> = Collation {
2457        id: CollationId::UCS2_SLOVAK_CI,
2458        charset: "ucs2",
2459        collation: "ucs2_slovak_ci",
2460        is_default: false,
2461        padding: PadAttribute::PadSpace,
2462        is_compiled: true,
2463        sort_len: 8,
2464        max_len: 2,
2465    };
2466    /// UCS-2 Unicode
2467    const UCS2_SPANISH2_CI_COLLATION: Collation<'static> = Collation {
2468        id: CollationId::UCS2_SPANISH2_CI,
2469        charset: "ucs2",
2470        collation: "ucs2_spanish2_ci",
2471        is_default: false,
2472        padding: PadAttribute::PadSpace,
2473        is_compiled: true,
2474        sort_len: 8,
2475        max_len: 2,
2476    };
2477    /// UCS-2 Unicode
2478    const UCS2_ROMAN_CI_COLLATION: Collation<'static> = Collation {
2479        id: CollationId::UCS2_ROMAN_CI,
2480        charset: "ucs2",
2481        collation: "ucs2_roman_ci",
2482        is_default: false,
2483        padding: PadAttribute::PadSpace,
2484        is_compiled: true,
2485        sort_len: 8,
2486        max_len: 2,
2487    };
2488    /// UCS-2 Unicode
2489    const UCS2_PERSIAN_CI_COLLATION: Collation<'static> = Collation {
2490        id: CollationId::UCS2_PERSIAN_CI,
2491        charset: "ucs2",
2492        collation: "ucs2_persian_ci",
2493        is_default: false,
2494        padding: PadAttribute::PadSpace,
2495        is_compiled: true,
2496        sort_len: 8,
2497        max_len: 2,
2498    };
2499    /// UCS-2 Unicode
2500    const UCS2_ESPERANTO_CI_COLLATION: Collation<'static> = Collation {
2501        id: CollationId::UCS2_ESPERANTO_CI,
2502        charset: "ucs2",
2503        collation: "ucs2_esperanto_ci",
2504        is_default: false,
2505        padding: PadAttribute::PadSpace,
2506        is_compiled: true,
2507        sort_len: 8,
2508        max_len: 2,
2509    };
2510    /// UCS-2 Unicode
2511    const UCS2_HUNGARIAN_CI_COLLATION: Collation<'static> = Collation {
2512        id: CollationId::UCS2_HUNGARIAN_CI,
2513        charset: "ucs2",
2514        collation: "ucs2_hungarian_ci",
2515        is_default: false,
2516        padding: PadAttribute::PadSpace,
2517        is_compiled: true,
2518        sort_len: 8,
2519        max_len: 2,
2520    };
2521    /// UCS-2 Unicode
2522    const UCS2_SINHALA_CI_COLLATION: Collation<'static> = Collation {
2523        id: CollationId::UCS2_SINHALA_CI,
2524        charset: "ucs2",
2525        collation: "ucs2_sinhala_ci",
2526        is_default: false,
2527        padding: PadAttribute::PadSpace,
2528        is_compiled: true,
2529        sort_len: 8,
2530        max_len: 2,
2531    };
2532    /// UCS-2 Unicode
2533    const UCS2_GERMAN2_CI_COLLATION: Collation<'static> = Collation {
2534        id: CollationId::UCS2_GERMAN2_CI,
2535        charset: "ucs2",
2536        collation: "ucs2_german2_ci",
2537        is_default: false,
2538        padding: PadAttribute::PadSpace,
2539        is_compiled: true,
2540        sort_len: 8,
2541        max_len: 2,
2542    };
2543    /// UCS-2 Unicode
2544    const UCS2_CROATIAN_CI_COLLATION: Collation<'static> = Collation {
2545        id: CollationId::UCS2_CROATIAN_CI,
2546        charset: "ucs2",
2547        collation: "ucs2_croatian_ci",
2548        is_default: false,
2549        padding: PadAttribute::PadSpace,
2550        is_compiled: true,
2551        sort_len: 8,
2552        max_len: 2,
2553    };
2554    /// UCS-2 Unicode
2555    const UCS2_UNICODE_520_CI_COLLATION: Collation<'static> = Collation {
2556        id: CollationId::UCS2_UNICODE_520_CI,
2557        charset: "ucs2",
2558        collation: "ucs2_unicode_520_ci",
2559        is_default: false,
2560        padding: PadAttribute::PadSpace,
2561        is_compiled: true,
2562        sort_len: 8,
2563        max_len: 2,
2564    };
2565    /// UCS-2 Unicode
2566    const UCS2_VIETNAMESE_CI_COLLATION: Collation<'static> = Collation {
2567        id: CollationId::UCS2_VIETNAMESE_CI,
2568        charset: "ucs2",
2569        collation: "ucs2_vietnamese_ci",
2570        is_default: false,
2571        padding: PadAttribute::PadSpace,
2572        is_compiled: true,
2573        sort_len: 8,
2574        max_len: 2,
2575    };
2576    /// UCS-2 Unicode
2577    const UCS2_GENERAL_MYSQL500_CI_COLLATION: Collation<'static> = Collation {
2578        id: CollationId::UCS2_GENERAL_MYSQL500_CI,
2579        charset: "ucs2",
2580        collation: "ucs2_general_mysql500_ci",
2581        is_default: false,
2582        padding: PadAttribute::PadSpace,
2583        is_compiled: true,
2584        sort_len: 1,
2585        max_len: 2,
2586    };
2587    /// UTF-32 Unicode
2588    const UTF32_UNICODE_CI_COLLATION: Collation<'static> = Collation {
2589        id: CollationId::UTF32_UNICODE_CI,
2590        charset: "utf32",
2591        collation: "utf32_unicode_ci",
2592        is_default: false,
2593        padding: PadAttribute::PadSpace,
2594        is_compiled: true,
2595        sort_len: 8,
2596        max_len: 4,
2597    };
2598    /// UTF-32 Unicode
2599    const UTF32_ICELANDIC_CI_COLLATION: Collation<'static> = Collation {
2600        id: CollationId::UTF32_ICELANDIC_CI,
2601        charset: "utf32",
2602        collation: "utf32_icelandic_ci",
2603        is_default: false,
2604        padding: PadAttribute::PadSpace,
2605        is_compiled: true,
2606        sort_len: 8,
2607        max_len: 4,
2608    };
2609    /// UTF-32 Unicode
2610    const UTF32_LATVIAN_CI_COLLATION: Collation<'static> = Collation {
2611        id: CollationId::UTF32_LATVIAN_CI,
2612        charset: "utf32",
2613        collation: "utf32_latvian_ci",
2614        is_default: false,
2615        padding: PadAttribute::PadSpace,
2616        is_compiled: true,
2617        sort_len: 8,
2618        max_len: 4,
2619    };
2620    /// UTF-32 Unicode
2621    const UTF32_ROMANIAN_CI_COLLATION: Collation<'static> = Collation {
2622        id: CollationId::UTF32_ROMANIAN_CI,
2623        charset: "utf32",
2624        collation: "utf32_romanian_ci",
2625        is_default: false,
2626        padding: PadAttribute::PadSpace,
2627        is_compiled: true,
2628        sort_len: 8,
2629        max_len: 4,
2630    };
2631    /// UTF-32 Unicode
2632    const UTF32_SLOVENIAN_CI_COLLATION: Collation<'static> = Collation {
2633        id: CollationId::UTF32_SLOVENIAN_CI,
2634        charset: "utf32",
2635        collation: "utf32_slovenian_ci",
2636        is_default: false,
2637        padding: PadAttribute::PadSpace,
2638        is_compiled: true,
2639        sort_len: 8,
2640        max_len: 4,
2641    };
2642    /// UTF-32 Unicode
2643    const UTF32_POLISH_CI_COLLATION: Collation<'static> = Collation {
2644        id: CollationId::UTF32_POLISH_CI,
2645        charset: "utf32",
2646        collation: "utf32_polish_ci",
2647        is_default: false,
2648        padding: PadAttribute::PadSpace,
2649        is_compiled: true,
2650        sort_len: 8,
2651        max_len: 4,
2652    };
2653    /// UTF-32 Unicode
2654    const UTF32_ESTONIAN_CI_COLLATION: Collation<'static> = Collation {
2655        id: CollationId::UTF32_ESTONIAN_CI,
2656        charset: "utf32",
2657        collation: "utf32_estonian_ci",
2658        is_default: false,
2659        padding: PadAttribute::PadSpace,
2660        is_compiled: true,
2661        sort_len: 8,
2662        max_len: 4,
2663    };
2664    /// UTF-32 Unicode
2665    const UTF32_SPANISH_CI_COLLATION: Collation<'static> = Collation {
2666        id: CollationId::UTF32_SPANISH_CI,
2667        charset: "utf32",
2668        collation: "utf32_spanish_ci",
2669        is_default: false,
2670        padding: PadAttribute::PadSpace,
2671        is_compiled: true,
2672        sort_len: 8,
2673        max_len: 4,
2674    };
2675    /// UTF-32 Unicode
2676    const UTF32_SWEDISH_CI_COLLATION: Collation<'static> = Collation {
2677        id: CollationId::UTF32_SWEDISH_CI,
2678        charset: "utf32",
2679        collation: "utf32_swedish_ci",
2680        is_default: false,
2681        padding: PadAttribute::PadSpace,
2682        is_compiled: true,
2683        sort_len: 8,
2684        max_len: 4,
2685    };
2686    /// UTF-32 Unicode
2687    const UTF32_TURKISH_CI_COLLATION: Collation<'static> = Collation {
2688        id: CollationId::UTF32_TURKISH_CI,
2689        charset: "utf32",
2690        collation: "utf32_turkish_ci",
2691        is_default: false,
2692        padding: PadAttribute::PadSpace,
2693        is_compiled: true,
2694        sort_len: 8,
2695        max_len: 4,
2696    };
2697    /// UTF-32 Unicode
2698    const UTF32_CZECH_CI_COLLATION: Collation<'static> = Collation {
2699        id: CollationId::UTF32_CZECH_CI,
2700        charset: "utf32",
2701        collation: "utf32_czech_ci",
2702        is_default: false,
2703        padding: PadAttribute::PadSpace,
2704        is_compiled: true,
2705        sort_len: 8,
2706        max_len: 4,
2707    };
2708    /// UTF-32 Unicode
2709    const UTF32_DANISH_CI_COLLATION: Collation<'static> = Collation {
2710        id: CollationId::UTF32_DANISH_CI,
2711        charset: "utf32",
2712        collation: "utf32_danish_ci",
2713        is_default: false,
2714        padding: PadAttribute::PadSpace,
2715        is_compiled: true,
2716        sort_len: 8,
2717        max_len: 4,
2718    };
2719    /// UTF-32 Unicode
2720    const UTF32_LITHUANIAN_CI_COLLATION: Collation<'static> = Collation {
2721        id: CollationId::UTF32_LITHUANIAN_CI,
2722        charset: "utf32",
2723        collation: "utf32_lithuanian_ci",
2724        is_default: false,
2725        padding: PadAttribute::PadSpace,
2726        is_compiled: true,
2727        sort_len: 8,
2728        max_len: 4,
2729    };
2730    /// UTF-32 Unicode
2731    const UTF32_SLOVAK_CI_COLLATION: Collation<'static> = Collation {
2732        id: CollationId::UTF32_SLOVAK_CI,
2733        charset: "utf32",
2734        collation: "utf32_slovak_ci",
2735        is_default: false,
2736        padding: PadAttribute::PadSpace,
2737        is_compiled: true,
2738        sort_len: 8,
2739        max_len: 4,
2740    };
2741    /// UTF-32 Unicode
2742    const UTF32_SPANISH2_CI_COLLATION: Collation<'static> = Collation {
2743        id: CollationId::UTF32_SPANISH2_CI,
2744        charset: "utf32",
2745        collation: "utf32_spanish2_ci",
2746        is_default: false,
2747        padding: PadAttribute::PadSpace,
2748        is_compiled: true,
2749        sort_len: 8,
2750        max_len: 4,
2751    };
2752    /// UTF-32 Unicode
2753    const UTF32_ROMAN_CI_COLLATION: Collation<'static> = Collation {
2754        id: CollationId::UTF32_ROMAN_CI,
2755        charset: "utf32",
2756        collation: "utf32_roman_ci",
2757        is_default: false,
2758        padding: PadAttribute::PadSpace,
2759        is_compiled: true,
2760        sort_len: 8,
2761        max_len: 4,
2762    };
2763    /// UTF-32 Unicode
2764    const UTF32_PERSIAN_CI_COLLATION: Collation<'static> = Collation {
2765        id: CollationId::UTF32_PERSIAN_CI,
2766        charset: "utf32",
2767        collation: "utf32_persian_ci",
2768        is_default: false,
2769        padding: PadAttribute::PadSpace,
2770        is_compiled: true,
2771        sort_len: 8,
2772        max_len: 4,
2773    };
2774    /// UTF-32 Unicode
2775    const UTF32_ESPERANTO_CI_COLLATION: Collation<'static> = Collation {
2776        id: CollationId::UTF32_ESPERANTO_CI,
2777        charset: "utf32",
2778        collation: "utf32_esperanto_ci",
2779        is_default: false,
2780        padding: PadAttribute::PadSpace,
2781        is_compiled: true,
2782        sort_len: 8,
2783        max_len: 4,
2784    };
2785    /// UTF-32 Unicode
2786    const UTF32_HUNGARIAN_CI_COLLATION: Collation<'static> = Collation {
2787        id: CollationId::UTF32_HUNGARIAN_CI,
2788        charset: "utf32",
2789        collation: "utf32_hungarian_ci",
2790        is_default: false,
2791        padding: PadAttribute::PadSpace,
2792        is_compiled: true,
2793        sort_len: 8,
2794        max_len: 4,
2795    };
2796    /// UTF-32 Unicode
2797    const UTF32_SINHALA_CI_COLLATION: Collation<'static> = Collation {
2798        id: CollationId::UTF32_SINHALA_CI,
2799        charset: "utf32",
2800        collation: "utf32_sinhala_ci",
2801        is_default: false,
2802        padding: PadAttribute::PadSpace,
2803        is_compiled: true,
2804        sort_len: 8,
2805        max_len: 4,
2806    };
2807    /// UTF-32 Unicode
2808    const UTF32_GERMAN2_CI_COLLATION: Collation<'static> = Collation {
2809        id: CollationId::UTF32_GERMAN2_CI,
2810        charset: "utf32",
2811        collation: "utf32_german2_ci",
2812        is_default: false,
2813        padding: PadAttribute::PadSpace,
2814        is_compiled: true,
2815        sort_len: 8,
2816        max_len: 4,
2817    };
2818    /// UTF-32 Unicode
2819    const UTF32_CROATIAN_CI_COLLATION: Collation<'static> = Collation {
2820        id: CollationId::UTF32_CROATIAN_CI,
2821        charset: "utf32",
2822        collation: "utf32_croatian_ci",
2823        is_default: false,
2824        padding: PadAttribute::PadSpace,
2825        is_compiled: true,
2826        sort_len: 8,
2827        max_len: 4,
2828    };
2829    /// UTF-32 Unicode
2830    const UTF32_UNICODE_520_CI_COLLATION: Collation<'static> = Collation {
2831        id: CollationId::UTF32_UNICODE_520_CI,
2832        charset: "utf32",
2833        collation: "utf32_unicode_520_ci",
2834        is_default: false,
2835        padding: PadAttribute::PadSpace,
2836        is_compiled: true,
2837        sort_len: 8,
2838        max_len: 4,
2839    };
2840    /// UTF-32 Unicode
2841    const UTF32_VIETNAMESE_CI_COLLATION: Collation<'static> = Collation {
2842        id: CollationId::UTF32_VIETNAMESE_CI,
2843        charset: "utf32",
2844        collation: "utf32_vietnamese_ci",
2845        is_default: false,
2846        padding: PadAttribute::PadSpace,
2847        is_compiled: true,
2848        sort_len: 8,
2849        max_len: 4,
2850    };
2851    /// UTF-8 Unicode
2852    const UTF8MB3_UNICODE_CI_COLLATION: Collation<'static> = Collation {
2853        id: CollationId::UTF8MB3_UNICODE_CI,
2854        charset: "utf8mb3",
2855        collation: "utf8mb3_unicode_ci",
2856        is_default: false,
2857        padding: PadAttribute::PadSpace,
2858        is_compiled: true,
2859        sort_len: 8,
2860        max_len: 3,
2861    };
2862    /// UTF-8 Unicode
2863    const UTF8MB3_ICELANDIC_CI_COLLATION: Collation<'static> = Collation {
2864        id: CollationId::UTF8MB3_ICELANDIC_CI,
2865        charset: "utf8mb3",
2866        collation: "utf8mb3_icelandic_ci",
2867        is_default: false,
2868        padding: PadAttribute::PadSpace,
2869        is_compiled: true,
2870        sort_len: 8,
2871        max_len: 3,
2872    };
2873    /// UTF-8 Unicode
2874    const UTF8MB3_LATVIAN_CI_COLLATION: Collation<'static> = Collation {
2875        id: CollationId::UTF8MB3_LATVIAN_CI,
2876        charset: "utf8mb3",
2877        collation: "utf8mb3_latvian_ci",
2878        is_default: false,
2879        padding: PadAttribute::PadSpace,
2880        is_compiled: true,
2881        sort_len: 8,
2882        max_len: 3,
2883    };
2884    /// UTF-8 Unicode
2885    const UTF8MB3_ROMANIAN_CI_COLLATION: Collation<'static> = Collation {
2886        id: CollationId::UTF8MB3_ROMANIAN_CI,
2887        charset: "utf8mb3",
2888        collation: "utf8mb3_romanian_ci",
2889        is_default: false,
2890        padding: PadAttribute::PadSpace,
2891        is_compiled: true,
2892        sort_len: 8,
2893        max_len: 3,
2894    };
2895    /// UTF-8 Unicode
2896    const UTF8MB3_SLOVENIAN_CI_COLLATION: Collation<'static> = Collation {
2897        id: CollationId::UTF8MB3_SLOVENIAN_CI,
2898        charset: "utf8mb3",
2899        collation: "utf8mb3_slovenian_ci",
2900        is_default: false,
2901        padding: PadAttribute::PadSpace,
2902        is_compiled: true,
2903        sort_len: 8,
2904        max_len: 3,
2905    };
2906    /// UTF-8 Unicode
2907    const UTF8MB3_POLISH_CI_COLLATION: Collation<'static> = Collation {
2908        id: CollationId::UTF8MB3_POLISH_CI,
2909        charset: "utf8mb3",
2910        collation: "utf8mb3_polish_ci",
2911        is_default: false,
2912        padding: PadAttribute::PadSpace,
2913        is_compiled: true,
2914        sort_len: 8,
2915        max_len: 3,
2916    };
2917    /// UTF-8 Unicode
2918    const UTF8MB3_ESTONIAN_CI_COLLATION: Collation<'static> = Collation {
2919        id: CollationId::UTF8MB3_ESTONIAN_CI,
2920        charset: "utf8mb3",
2921        collation: "utf8mb3_estonian_ci",
2922        is_default: false,
2923        padding: PadAttribute::PadSpace,
2924        is_compiled: true,
2925        sort_len: 8,
2926        max_len: 3,
2927    };
2928    /// UTF-8 Unicode
2929    const UTF8MB3_SPANISH_CI_COLLATION: Collation<'static> = Collation {
2930        id: CollationId::UTF8MB3_SPANISH_CI,
2931        charset: "utf8mb3",
2932        collation: "utf8mb3_spanish_ci",
2933        is_default: false,
2934        padding: PadAttribute::PadSpace,
2935        is_compiled: true,
2936        sort_len: 8,
2937        max_len: 3,
2938    };
2939    /// UTF-8 Unicode
2940    const UTF8MB3_SWEDISH_CI_COLLATION: Collation<'static> = Collation {
2941        id: CollationId::UTF8MB3_SWEDISH_CI,
2942        charset: "utf8mb3",
2943        collation: "utf8mb3_swedish_ci",
2944        is_default: false,
2945        padding: PadAttribute::PadSpace,
2946        is_compiled: true,
2947        sort_len: 8,
2948        max_len: 3,
2949    };
2950    /// UTF-8 Unicode
2951    const UTF8MB3_TURKISH_CI_COLLATION: Collation<'static> = Collation {
2952        id: CollationId::UTF8MB3_TURKISH_CI,
2953        charset: "utf8mb3",
2954        collation: "utf8mb3_turkish_ci",
2955        is_default: false,
2956        padding: PadAttribute::PadSpace,
2957        is_compiled: true,
2958        sort_len: 8,
2959        max_len: 3,
2960    };
2961    /// UTF-8 Unicode
2962    const UTF8MB3_CZECH_CI_COLLATION: Collation<'static> = Collation {
2963        id: CollationId::UTF8MB3_CZECH_CI,
2964        charset: "utf8mb3",
2965        collation: "utf8mb3_czech_ci",
2966        is_default: false,
2967        padding: PadAttribute::PadSpace,
2968        is_compiled: true,
2969        sort_len: 8,
2970        max_len: 3,
2971    };
2972    /// UTF-8 Unicode
2973    const UTF8MB3_DANISH_CI_COLLATION: Collation<'static> = Collation {
2974        id: CollationId::UTF8MB3_DANISH_CI,
2975        charset: "utf8mb3",
2976        collation: "utf8mb3_danish_ci",
2977        is_default: false,
2978        padding: PadAttribute::PadSpace,
2979        is_compiled: true,
2980        sort_len: 8,
2981        max_len: 3,
2982    };
2983    /// UTF-8 Unicode
2984    const UTF8MB3_LITHUANIAN_CI_COLLATION: Collation<'static> = Collation {
2985        id: CollationId::UTF8MB3_LITHUANIAN_CI,
2986        charset: "utf8mb3",
2987        collation: "utf8mb3_lithuanian_ci",
2988        is_default: false,
2989        padding: PadAttribute::PadSpace,
2990        is_compiled: true,
2991        sort_len: 8,
2992        max_len: 3,
2993    };
2994    /// UTF-8 Unicode
2995    const UTF8MB3_SLOVAK_CI_COLLATION: Collation<'static> = Collation {
2996        id: CollationId::UTF8MB3_SLOVAK_CI,
2997        charset: "utf8mb3",
2998        collation: "utf8mb3_slovak_ci",
2999        is_default: false,
3000        padding: PadAttribute::PadSpace,
3001        is_compiled: true,
3002        sort_len: 8,
3003        max_len: 3,
3004    };
3005    /// UTF-8 Unicode
3006    const UTF8MB3_SPANISH2_CI_COLLATION: Collation<'static> = Collation {
3007        id: CollationId::UTF8MB3_SPANISH2_CI,
3008        charset: "utf8mb3",
3009        collation: "utf8mb3_spanish2_ci",
3010        is_default: false,
3011        padding: PadAttribute::PadSpace,
3012        is_compiled: true,
3013        sort_len: 8,
3014        max_len: 3,
3015    };
3016    /// UTF-8 Unicode
3017    const UTF8MB3_ROMAN_CI_COLLATION: Collation<'static> = Collation {
3018        id: CollationId::UTF8MB3_ROMAN_CI,
3019        charset: "utf8mb3",
3020        collation: "utf8mb3_roman_ci",
3021        is_default: false,
3022        padding: PadAttribute::PadSpace,
3023        is_compiled: true,
3024        sort_len: 8,
3025        max_len: 3,
3026    };
3027    /// UTF-8 Unicode
3028    const UTF8MB3_PERSIAN_CI_COLLATION: Collation<'static> = Collation {
3029        id: CollationId::UTF8MB3_PERSIAN_CI,
3030        charset: "utf8mb3",
3031        collation: "utf8mb3_persian_ci",
3032        is_default: false,
3033        padding: PadAttribute::PadSpace,
3034        is_compiled: true,
3035        sort_len: 8,
3036        max_len: 3,
3037    };
3038    /// UTF-8 Unicode
3039    const UTF8MB3_ESPERANTO_CI_COLLATION: Collation<'static> = Collation {
3040        id: CollationId::UTF8MB3_ESPERANTO_CI,
3041        charset: "utf8mb3",
3042        collation: "utf8mb3_esperanto_ci",
3043        is_default: false,
3044        padding: PadAttribute::PadSpace,
3045        is_compiled: true,
3046        sort_len: 8,
3047        max_len: 3,
3048    };
3049    /// UTF-8 Unicode
3050    const UTF8MB3_HUNGARIAN_CI_COLLATION: Collation<'static> = Collation {
3051        id: CollationId::UTF8MB3_HUNGARIAN_CI,
3052        charset: "utf8mb3",
3053        collation: "utf8mb3_hungarian_ci",
3054        is_default: false,
3055        padding: PadAttribute::PadSpace,
3056        is_compiled: true,
3057        sort_len: 8,
3058        max_len: 3,
3059    };
3060    /// UTF-8 Unicode
3061    const UTF8MB3_SINHALA_CI_COLLATION: Collation<'static> = Collation {
3062        id: CollationId::UTF8MB3_SINHALA_CI,
3063        charset: "utf8mb3",
3064        collation: "utf8mb3_sinhala_ci",
3065        is_default: false,
3066        padding: PadAttribute::PadSpace,
3067        is_compiled: true,
3068        sort_len: 8,
3069        max_len: 3,
3070    };
3071    /// UTF-8 Unicode
3072    const UTF8MB3_GERMAN2_CI_COLLATION: Collation<'static> = Collation {
3073        id: CollationId::UTF8MB3_GERMAN2_CI,
3074        charset: "utf8mb3",
3075        collation: "utf8mb3_german2_ci",
3076        is_default: false,
3077        padding: PadAttribute::PadSpace,
3078        is_compiled: true,
3079        sort_len: 8,
3080        max_len: 3,
3081    };
3082    /// UTF-8 Unicode
3083    const UTF8MB3_CROATIAN_CI_COLLATION: Collation<'static> = Collation {
3084        id: CollationId::UTF8MB3_CROATIAN_CI,
3085        charset: "utf8mb3",
3086        collation: "utf8mb3_croatian_ci",
3087        is_default: false,
3088        padding: PadAttribute::PadSpace,
3089        is_compiled: true,
3090        sort_len: 8,
3091        max_len: 3,
3092    };
3093    /// UTF-8 Unicode
3094    const UTF8MB3_UNICODE_520_CI_COLLATION: Collation<'static> = Collation {
3095        id: CollationId::UTF8MB3_UNICODE_520_CI,
3096        charset: "utf8mb3",
3097        collation: "utf8mb3_unicode_520_ci",
3098        is_default: false,
3099        padding: PadAttribute::PadSpace,
3100        is_compiled: true,
3101        sort_len: 8,
3102        max_len: 3,
3103    };
3104    /// UTF-8 Unicode
3105    const UTF8MB3_VIETNAMESE_CI_COLLATION: Collation<'static> = Collation {
3106        id: CollationId::UTF8MB3_VIETNAMESE_CI,
3107        charset: "utf8mb3",
3108        collation: "utf8mb3_vietnamese_ci",
3109        is_default: false,
3110        padding: PadAttribute::PadSpace,
3111        is_compiled: true,
3112        sort_len: 8,
3113        max_len: 3,
3114    };
3115    /// UTF-8 Unicode
3116    const UTF8MB3_GENERAL_MYSQL500_CI_COLLATION: Collation<'static> = Collation {
3117        id: CollationId::UTF8MB3_GENERAL_MYSQL500_CI,
3118        charset: "utf8mb3",
3119        collation: "utf8mb3_general_mysql500_ci",
3120        is_default: false,
3121        padding: PadAttribute::PadSpace,
3122        is_compiled: true,
3123        sort_len: 1,
3124        max_len: 3,
3125    };
3126    /// UTF-8 Unicode
3127    const UTF8MB4_UNICODE_CI_COLLATION: Collation<'static> = Collation {
3128        id: CollationId::UTF8MB4_UNICODE_CI,
3129        charset: "utf8mb4",
3130        collation: "utf8mb4_unicode_ci",
3131        is_default: false,
3132        padding: PadAttribute::PadSpace,
3133        is_compiled: true,
3134        sort_len: 8,
3135        max_len: 4,
3136    };
3137    /// UTF-8 Unicode
3138    const UTF8MB4_ICELANDIC_CI_COLLATION: Collation<'static> = Collation {
3139        id: CollationId::UTF8MB4_ICELANDIC_CI,
3140        charset: "utf8mb4",
3141        collation: "utf8mb4_icelandic_ci",
3142        is_default: false,
3143        padding: PadAttribute::PadSpace,
3144        is_compiled: true,
3145        sort_len: 8,
3146        max_len: 4,
3147    };
3148    /// UTF-8 Unicode
3149    const UTF8MB4_LATVIAN_CI_COLLATION: Collation<'static> = Collation {
3150        id: CollationId::UTF8MB4_LATVIAN_CI,
3151        charset: "utf8mb4",
3152        collation: "utf8mb4_latvian_ci",
3153        is_default: false,
3154        padding: PadAttribute::PadSpace,
3155        is_compiled: true,
3156        sort_len: 8,
3157        max_len: 4,
3158    };
3159    /// UTF-8 Unicode
3160    const UTF8MB4_ROMANIAN_CI_COLLATION: Collation<'static> = Collation {
3161        id: CollationId::UTF8MB4_ROMANIAN_CI,
3162        charset: "utf8mb4",
3163        collation: "utf8mb4_romanian_ci",
3164        is_default: false,
3165        padding: PadAttribute::PadSpace,
3166        is_compiled: true,
3167        sort_len: 8,
3168        max_len: 4,
3169    };
3170    /// UTF-8 Unicode
3171    const UTF8MB4_SLOVENIAN_CI_COLLATION: Collation<'static> = Collation {
3172        id: CollationId::UTF8MB4_SLOVENIAN_CI,
3173        charset: "utf8mb4",
3174        collation: "utf8mb4_slovenian_ci",
3175        is_default: false,
3176        padding: PadAttribute::PadSpace,
3177        is_compiled: true,
3178        sort_len: 8,
3179        max_len: 4,
3180    };
3181    /// UTF-8 Unicode
3182    const UTF8MB4_POLISH_CI_COLLATION: Collation<'static> = Collation {
3183        id: CollationId::UTF8MB4_POLISH_CI,
3184        charset: "utf8mb4",
3185        collation: "utf8mb4_polish_ci",
3186        is_default: false,
3187        padding: PadAttribute::PadSpace,
3188        is_compiled: true,
3189        sort_len: 8,
3190        max_len: 4,
3191    };
3192    /// UTF-8 Unicode
3193    const UTF8MB4_ESTONIAN_CI_COLLATION: Collation<'static> = Collation {
3194        id: CollationId::UTF8MB4_ESTONIAN_CI,
3195        charset: "utf8mb4",
3196        collation: "utf8mb4_estonian_ci",
3197        is_default: false,
3198        padding: PadAttribute::PadSpace,
3199        is_compiled: true,
3200        sort_len: 8,
3201        max_len: 4,
3202    };
3203    /// UTF-8 Unicode
3204    const UTF8MB4_SPANISH_CI_COLLATION: Collation<'static> = Collation {
3205        id: CollationId::UTF8MB4_SPANISH_CI,
3206        charset: "utf8mb4",
3207        collation: "utf8mb4_spanish_ci",
3208        is_default: false,
3209        padding: PadAttribute::PadSpace,
3210        is_compiled: true,
3211        sort_len: 8,
3212        max_len: 4,
3213    };
3214    /// UTF-8 Unicode
3215    const UTF8MB4_SWEDISH_CI_COLLATION: Collation<'static> = Collation {
3216        id: CollationId::UTF8MB4_SWEDISH_CI,
3217        charset: "utf8mb4",
3218        collation: "utf8mb4_swedish_ci",
3219        is_default: false,
3220        padding: PadAttribute::PadSpace,
3221        is_compiled: true,
3222        sort_len: 8,
3223        max_len: 4,
3224    };
3225    /// UTF-8 Unicode
3226    const UTF8MB4_TURKISH_CI_COLLATION: Collation<'static> = Collation {
3227        id: CollationId::UTF8MB4_TURKISH_CI,
3228        charset: "utf8mb4",
3229        collation: "utf8mb4_turkish_ci",
3230        is_default: false,
3231        padding: PadAttribute::PadSpace,
3232        is_compiled: true,
3233        sort_len: 8,
3234        max_len: 4,
3235    };
3236    /// UTF-8 Unicode
3237    const UTF8MB4_CZECH_CI_COLLATION: Collation<'static> = Collation {
3238        id: CollationId::UTF8MB4_CZECH_CI,
3239        charset: "utf8mb4",
3240        collation: "utf8mb4_czech_ci",
3241        is_default: false,
3242        padding: PadAttribute::PadSpace,
3243        is_compiled: true,
3244        sort_len: 8,
3245        max_len: 4,
3246    };
3247    /// UTF-8 Unicode
3248    const UTF8MB4_DANISH_CI_COLLATION: Collation<'static> = Collation {
3249        id: CollationId::UTF8MB4_DANISH_CI,
3250        charset: "utf8mb4",
3251        collation: "utf8mb4_danish_ci",
3252        is_default: false,
3253        padding: PadAttribute::PadSpace,
3254        is_compiled: true,
3255        sort_len: 8,
3256        max_len: 4,
3257    };
3258    /// UTF-8 Unicode
3259    const UTF8MB4_LITHUANIAN_CI_COLLATION: Collation<'static> = Collation {
3260        id: CollationId::UTF8MB4_LITHUANIAN_CI,
3261        charset: "utf8mb4",
3262        collation: "utf8mb4_lithuanian_ci",
3263        is_default: false,
3264        padding: PadAttribute::PadSpace,
3265        is_compiled: true,
3266        sort_len: 8,
3267        max_len: 4,
3268    };
3269    /// UTF-8 Unicode
3270    const UTF8MB4_SLOVAK_CI_COLLATION: Collation<'static> = Collation {
3271        id: CollationId::UTF8MB4_SLOVAK_CI,
3272        charset: "utf8mb4",
3273        collation: "utf8mb4_slovak_ci",
3274        is_default: false,
3275        padding: PadAttribute::PadSpace,
3276        is_compiled: true,
3277        sort_len: 8,
3278        max_len: 4,
3279    };
3280    /// UTF-8 Unicode
3281    const UTF8MB4_SPANISH2_CI_COLLATION: Collation<'static> = Collation {
3282        id: CollationId::UTF8MB4_SPANISH2_CI,
3283        charset: "utf8mb4",
3284        collation: "utf8mb4_spanish2_ci",
3285        is_default: false,
3286        padding: PadAttribute::PadSpace,
3287        is_compiled: true,
3288        sort_len: 8,
3289        max_len: 4,
3290    };
3291    /// UTF-8 Unicode
3292    const UTF8MB4_ROMAN_CI_COLLATION: Collation<'static> = Collation {
3293        id: CollationId::UTF8MB4_ROMAN_CI,
3294        charset: "utf8mb4",
3295        collation: "utf8mb4_roman_ci",
3296        is_default: false,
3297        padding: PadAttribute::PadSpace,
3298        is_compiled: true,
3299        sort_len: 8,
3300        max_len: 4,
3301    };
3302    /// UTF-8 Unicode
3303    const UTF8MB4_PERSIAN_CI_COLLATION: Collation<'static> = Collation {
3304        id: CollationId::UTF8MB4_PERSIAN_CI,
3305        charset: "utf8mb4",
3306        collation: "utf8mb4_persian_ci",
3307        is_default: false,
3308        padding: PadAttribute::PadSpace,
3309        is_compiled: true,
3310        sort_len: 8,
3311        max_len: 4,
3312    };
3313    /// UTF-8 Unicode
3314    const UTF8MB4_ESPERANTO_CI_COLLATION: Collation<'static> = Collation {
3315        id: CollationId::UTF8MB4_ESPERANTO_CI,
3316        charset: "utf8mb4",
3317        collation: "utf8mb4_esperanto_ci",
3318        is_default: false,
3319        padding: PadAttribute::PadSpace,
3320        is_compiled: true,
3321        sort_len: 8,
3322        max_len: 4,
3323    };
3324    /// UTF-8 Unicode
3325    const UTF8MB4_HUNGARIAN_CI_COLLATION: Collation<'static> = Collation {
3326        id: CollationId::UTF8MB4_HUNGARIAN_CI,
3327        charset: "utf8mb4",
3328        collation: "utf8mb4_hungarian_ci",
3329        is_default: false,
3330        padding: PadAttribute::PadSpace,
3331        is_compiled: true,
3332        sort_len: 8,
3333        max_len: 4,
3334    };
3335    /// UTF-8 Unicode
3336    const UTF8MB4_SINHALA_CI_COLLATION: Collation<'static> = Collation {
3337        id: CollationId::UTF8MB4_SINHALA_CI,
3338        charset: "utf8mb4",
3339        collation: "utf8mb4_sinhala_ci",
3340        is_default: false,
3341        padding: PadAttribute::PadSpace,
3342        is_compiled: true,
3343        sort_len: 8,
3344        max_len: 4,
3345    };
3346    /// UTF-8 Unicode
3347    const UTF8MB4_GERMAN2_CI_COLLATION: Collation<'static> = Collation {
3348        id: CollationId::UTF8MB4_GERMAN2_CI,
3349        charset: "utf8mb4",
3350        collation: "utf8mb4_german2_ci",
3351        is_default: false,
3352        padding: PadAttribute::PadSpace,
3353        is_compiled: true,
3354        sort_len: 8,
3355        max_len: 4,
3356    };
3357    /// UTF-8 Unicode
3358    const UTF8MB4_CROATIAN_CI_COLLATION: Collation<'static> = Collation {
3359        id: CollationId::UTF8MB4_CROATIAN_CI,
3360        charset: "utf8mb4",
3361        collation: "utf8mb4_croatian_ci",
3362        is_default: false,
3363        padding: PadAttribute::PadSpace,
3364        is_compiled: true,
3365        sort_len: 8,
3366        max_len: 4,
3367    };
3368    /// UTF-8 Unicode
3369    const UTF8MB4_UNICODE_520_CI_COLLATION: Collation<'static> = Collation {
3370        id: CollationId::UTF8MB4_UNICODE_520_CI,
3371        charset: "utf8mb4",
3372        collation: "utf8mb4_unicode_520_ci",
3373        is_default: false,
3374        padding: PadAttribute::PadSpace,
3375        is_compiled: true,
3376        sort_len: 8,
3377        max_len: 4,
3378    };
3379    /// UTF-8 Unicode
3380    const UTF8MB4_VIETNAMESE_CI_COLLATION: Collation<'static> = Collation {
3381        id: CollationId::UTF8MB4_VIETNAMESE_CI,
3382        charset: "utf8mb4",
3383        collation: "utf8mb4_vietnamese_ci",
3384        is_default: false,
3385        padding: PadAttribute::PadSpace,
3386        is_compiled: true,
3387        sort_len: 8,
3388        max_len: 4,
3389    };
3390    /// China National Standard GB18030
3391    const GB18030_CHINESE_CI_COLLATION: Collation<'static> = Collation {
3392        id: CollationId::GB18030_CHINESE_CI,
3393        charset: "gb18030",
3394        collation: "gb18030_chinese_ci",
3395        is_default: true,
3396        padding: PadAttribute::PadSpace,
3397        is_compiled: true,
3398        sort_len: 2,
3399        max_len: 4,
3400    };
3401    /// China National Standard GB18030
3402    const GB18030_BIN_COLLATION: Collation<'static> = Collation {
3403        id: CollationId::GB18030_BIN,
3404        charset: "gb18030",
3405        collation: "gb18030_bin",
3406        is_default: false,
3407        padding: PadAttribute::PadSpace,
3408        is_compiled: true,
3409        sort_len: 1,
3410        max_len: 4,
3411    };
3412    /// China National Standard GB18030
3413    const GB18030_UNICODE_520_CI_COLLATION: Collation<'static> = Collation {
3414        id: CollationId::GB18030_UNICODE_520_CI,
3415        charset: "gb18030",
3416        collation: "gb18030_unicode_520_ci",
3417        is_default: false,
3418        padding: PadAttribute::PadSpace,
3419        is_compiled: true,
3420        sort_len: 8,
3421        max_len: 4,
3422    };
3423    /// UTF-8 Unicode
3424    const UTF8MB4_0900_AI_CI_COLLATION: Collation<'static> = Collation {
3425        id: CollationId::UTF8MB4_0900_AI_CI,
3426        charset: "utf8mb4",
3427        collation: "utf8mb4_0900_ai_ci",
3428        is_default: true,
3429        padding: PadAttribute::PadZero,
3430        is_compiled: true,
3431        sort_len: 0,
3432        max_len: 4,
3433    };
3434    /// UTF-8 Unicode
3435    const UTF8MB4_DE_PB_0900_AI_CI_COLLATION: Collation<'static> = Collation {
3436        id: CollationId::UTF8MB4_DE_PB_0900_AI_CI,
3437        charset: "utf8mb4",
3438        collation: "utf8mb4_de_pb_0900_ai_ci",
3439        is_default: false,
3440        padding: PadAttribute::PadZero,
3441        is_compiled: true,
3442        sort_len: 0,
3443        max_len: 4,
3444    };
3445    /// UTF-8 Unicode
3446    const UTF8MB4_IS_0900_AI_CI_COLLATION: Collation<'static> = Collation {
3447        id: CollationId::UTF8MB4_IS_0900_AI_CI,
3448        charset: "utf8mb4",
3449        collation: "utf8mb4_is_0900_ai_ci",
3450        is_default: false,
3451        padding: PadAttribute::PadZero,
3452        is_compiled: true,
3453        sort_len: 0,
3454        max_len: 4,
3455    };
3456    /// UTF-8 Unicode
3457    const UTF8MB4_LV_0900_AI_CI_COLLATION: Collation<'static> = Collation {
3458        id: CollationId::UTF8MB4_LV_0900_AI_CI,
3459        charset: "utf8mb4",
3460        collation: "utf8mb4_lv_0900_ai_ci",
3461        is_default: false,
3462        padding: PadAttribute::PadZero,
3463        is_compiled: true,
3464        sort_len: 0,
3465        max_len: 4,
3466    };
3467    /// UTF-8 Unicode
3468    const UTF8MB4_RO_0900_AI_CI_COLLATION: Collation<'static> = Collation {
3469        id: CollationId::UTF8MB4_RO_0900_AI_CI,
3470        charset: "utf8mb4",
3471        collation: "utf8mb4_ro_0900_ai_ci",
3472        is_default: false,
3473        padding: PadAttribute::PadZero,
3474        is_compiled: true,
3475        sort_len: 0,
3476        max_len: 4,
3477    };
3478    /// UTF-8 Unicode
3479    const UTF8MB4_SL_0900_AI_CI_COLLATION: Collation<'static> = Collation {
3480        id: CollationId::UTF8MB4_SL_0900_AI_CI,
3481        charset: "utf8mb4",
3482        collation: "utf8mb4_sl_0900_ai_ci",
3483        is_default: false,
3484        padding: PadAttribute::PadZero,
3485        is_compiled: true,
3486        sort_len: 0,
3487        max_len: 4,
3488    };
3489    /// UTF-8 Unicode
3490    const UTF8MB4_PL_0900_AI_CI_COLLATION: Collation<'static> = Collation {
3491        id: CollationId::UTF8MB4_PL_0900_AI_CI,
3492        charset: "utf8mb4",
3493        collation: "utf8mb4_pl_0900_ai_ci",
3494        is_default: false,
3495        padding: PadAttribute::PadZero,
3496        is_compiled: true,
3497        sort_len: 0,
3498        max_len: 4,
3499    };
3500    /// UTF-8 Unicode
3501    const UTF8MB4_ET_0900_AI_CI_COLLATION: Collation<'static> = Collation {
3502        id: CollationId::UTF8MB4_ET_0900_AI_CI,
3503        charset: "utf8mb4",
3504        collation: "utf8mb4_et_0900_ai_ci",
3505        is_default: false,
3506        padding: PadAttribute::PadZero,
3507        is_compiled: true,
3508        sort_len: 0,
3509        max_len: 4,
3510    };
3511    /// UTF-8 Unicode
3512    const UTF8MB4_ES_0900_AI_CI_COLLATION: Collation<'static> = Collation {
3513        id: CollationId::UTF8MB4_ES_0900_AI_CI,
3514        charset: "utf8mb4",
3515        collation: "utf8mb4_es_0900_ai_ci",
3516        is_default: false,
3517        padding: PadAttribute::PadZero,
3518        is_compiled: true,
3519        sort_len: 0,
3520        max_len: 4,
3521    };
3522    /// UTF-8 Unicode
3523    const UTF8MB4_SV_0900_AI_CI_COLLATION: Collation<'static> = Collation {
3524        id: CollationId::UTF8MB4_SV_0900_AI_CI,
3525        charset: "utf8mb4",
3526        collation: "utf8mb4_sv_0900_ai_ci",
3527        is_default: false,
3528        padding: PadAttribute::PadZero,
3529        is_compiled: true,
3530        sort_len: 0,
3531        max_len: 4,
3532    };
3533    /// UTF-8 Unicode
3534    const UTF8MB4_TR_0900_AI_CI_COLLATION: Collation<'static> = Collation {
3535        id: CollationId::UTF8MB4_TR_0900_AI_CI,
3536        charset: "utf8mb4",
3537        collation: "utf8mb4_tr_0900_ai_ci",
3538        is_default: false,
3539        padding: PadAttribute::PadZero,
3540        is_compiled: true,
3541        sort_len: 0,
3542        max_len: 4,
3543    };
3544    /// UTF-8 Unicode
3545    const UTF8MB4_CS_0900_AI_CI_COLLATION: Collation<'static> = Collation {
3546        id: CollationId::UTF8MB4_CS_0900_AI_CI,
3547        charset: "utf8mb4",
3548        collation: "utf8mb4_cs_0900_ai_ci",
3549        is_default: false,
3550        padding: PadAttribute::PadZero,
3551        is_compiled: true,
3552        sort_len: 0,
3553        max_len: 4,
3554    };
3555    /// UTF-8 Unicode
3556    const UTF8MB4_DA_0900_AI_CI_COLLATION: Collation<'static> = Collation {
3557        id: CollationId::UTF8MB4_DA_0900_AI_CI,
3558        charset: "utf8mb4",
3559        collation: "utf8mb4_da_0900_ai_ci",
3560        is_default: false,
3561        padding: PadAttribute::PadZero,
3562        is_compiled: true,
3563        sort_len: 0,
3564        max_len: 4,
3565    };
3566    /// UTF-8 Unicode
3567    const UTF8MB4_LT_0900_AI_CI_COLLATION: Collation<'static> = Collation {
3568        id: CollationId::UTF8MB4_LT_0900_AI_CI,
3569        charset: "utf8mb4",
3570        collation: "utf8mb4_lt_0900_ai_ci",
3571        is_default: false,
3572        padding: PadAttribute::PadZero,
3573        is_compiled: true,
3574        sort_len: 0,
3575        max_len: 4,
3576    };
3577    /// UTF-8 Unicode
3578    const UTF8MB4_SK_0900_AI_CI_COLLATION: Collation<'static> = Collation {
3579        id: CollationId::UTF8MB4_SK_0900_AI_CI,
3580        charset: "utf8mb4",
3581        collation: "utf8mb4_sk_0900_ai_ci",
3582        is_default: false,
3583        padding: PadAttribute::PadZero,
3584        is_compiled: true,
3585        sort_len: 0,
3586        max_len: 4,
3587    };
3588    /// UTF-8 Unicode
3589    const UTF8MB4_ES_TRAD_0900_AI_CI_COLLATION: Collation<'static> = Collation {
3590        id: CollationId::UTF8MB4_ES_TRAD_0900_AI_CI,
3591        charset: "utf8mb4",
3592        collation: "utf8mb4_es_trad_0900_ai_ci",
3593        is_default: false,
3594        padding: PadAttribute::PadZero,
3595        is_compiled: true,
3596        sort_len: 0,
3597        max_len: 4,
3598    };
3599    /// UTF-8 Unicode
3600    const UTF8MB4_LA_0900_AI_CI_COLLATION: Collation<'static> = Collation {
3601        id: CollationId::UTF8MB4_LA_0900_AI_CI,
3602        charset: "utf8mb4",
3603        collation: "utf8mb4_la_0900_ai_ci",
3604        is_default: false,
3605        padding: PadAttribute::PadZero,
3606        is_compiled: true,
3607        sort_len: 0,
3608        max_len: 4,
3609    };
3610    /// UTF-8 Unicode
3611    const UTF8MB4_EO_0900_AI_CI_COLLATION: Collation<'static> = Collation {
3612        id: CollationId::UTF8MB4_EO_0900_AI_CI,
3613        charset: "utf8mb4",
3614        collation: "utf8mb4_eo_0900_ai_ci",
3615        is_default: false,
3616        padding: PadAttribute::PadZero,
3617        is_compiled: true,
3618        sort_len: 0,
3619        max_len: 4,
3620    };
3621    /// UTF-8 Unicode
3622    const UTF8MB4_HU_0900_AI_CI_COLLATION: Collation<'static> = Collation {
3623        id: CollationId::UTF8MB4_HU_0900_AI_CI,
3624        charset: "utf8mb4",
3625        collation: "utf8mb4_hu_0900_ai_ci",
3626        is_default: false,
3627        padding: PadAttribute::PadZero,
3628        is_compiled: true,
3629        sort_len: 0,
3630        max_len: 4,
3631    };
3632    /// UTF-8 Unicode
3633    const UTF8MB4_HR_0900_AI_CI_COLLATION: Collation<'static> = Collation {
3634        id: CollationId::UTF8MB4_HR_0900_AI_CI,
3635        charset: "utf8mb4",
3636        collation: "utf8mb4_hr_0900_ai_ci",
3637        is_default: false,
3638        padding: PadAttribute::PadZero,
3639        is_compiled: true,
3640        sort_len: 0,
3641        max_len: 4,
3642    };
3643    /// UTF-8 Unicode
3644    const UTF8MB4_VI_0900_AI_CI_COLLATION: Collation<'static> = Collation {
3645        id: CollationId::UTF8MB4_VI_0900_AI_CI,
3646        charset: "utf8mb4",
3647        collation: "utf8mb4_vi_0900_ai_ci",
3648        is_default: false,
3649        padding: PadAttribute::PadZero,
3650        is_compiled: true,
3651        sort_len: 0,
3652        max_len: 4,
3653    };
3654    /// UTF-8 Unicode
3655    const UTF8MB4_0900_AS_CS_COLLATION: Collation<'static> = Collation {
3656        id: CollationId::UTF8MB4_0900_AS_CS,
3657        charset: "utf8mb4",
3658        collation: "utf8mb4_0900_as_cs",
3659        is_default: false,
3660        padding: PadAttribute::PadZero,
3661        is_compiled: true,
3662        sort_len: 0,
3663        max_len: 4,
3664    };
3665    /// UTF-8 Unicode
3666    const UTF8MB4_DE_PB_0900_AS_CS_COLLATION: Collation<'static> = Collation {
3667        id: CollationId::UTF8MB4_DE_PB_0900_AS_CS,
3668        charset: "utf8mb4",
3669        collation: "utf8mb4_de_pb_0900_as_cs",
3670        is_default: false,
3671        padding: PadAttribute::PadZero,
3672        is_compiled: true,
3673        sort_len: 0,
3674        max_len: 4,
3675    };
3676    /// UTF-8 Unicode
3677    const UTF8MB4_IS_0900_AS_CS_COLLATION: Collation<'static> = Collation {
3678        id: CollationId::UTF8MB4_IS_0900_AS_CS,
3679        charset: "utf8mb4",
3680        collation: "utf8mb4_is_0900_as_cs",
3681        is_default: false,
3682        padding: PadAttribute::PadZero,
3683        is_compiled: true,
3684        sort_len: 0,
3685        max_len: 4,
3686    };
3687    /// UTF-8 Unicode
3688    const UTF8MB4_LV_0900_AS_CS_COLLATION: Collation<'static> = Collation {
3689        id: CollationId::UTF8MB4_LV_0900_AS_CS,
3690        charset: "utf8mb4",
3691        collation: "utf8mb4_lv_0900_as_cs",
3692        is_default: false,
3693        padding: PadAttribute::PadZero,
3694        is_compiled: true,
3695        sort_len: 0,
3696        max_len: 4,
3697    };
3698    /// UTF-8 Unicode
3699    const UTF8MB4_RO_0900_AS_CS_COLLATION: Collation<'static> = Collation {
3700        id: CollationId::UTF8MB4_RO_0900_AS_CS,
3701        charset: "utf8mb4",
3702        collation: "utf8mb4_ro_0900_as_cs",
3703        is_default: false,
3704        padding: PadAttribute::PadZero,
3705        is_compiled: true,
3706        sort_len: 0,
3707        max_len: 4,
3708    };
3709    /// UTF-8 Unicode
3710    const UTF8MB4_SL_0900_AS_CS_COLLATION: Collation<'static> = Collation {
3711        id: CollationId::UTF8MB4_SL_0900_AS_CS,
3712        charset: "utf8mb4",
3713        collation: "utf8mb4_sl_0900_as_cs",
3714        is_default: false,
3715        padding: PadAttribute::PadZero,
3716        is_compiled: true,
3717        sort_len: 0,
3718        max_len: 4,
3719    };
3720    /// UTF-8 Unicode
3721    const UTF8MB4_PL_0900_AS_CS_COLLATION: Collation<'static> = Collation {
3722        id: CollationId::UTF8MB4_PL_0900_AS_CS,
3723        charset: "utf8mb4",
3724        collation: "utf8mb4_pl_0900_as_cs",
3725        is_default: false,
3726        padding: PadAttribute::PadZero,
3727        is_compiled: true,
3728        sort_len: 0,
3729        max_len: 4,
3730    };
3731    /// UTF-8 Unicode
3732    const UTF8MB4_ET_0900_AS_CS_COLLATION: Collation<'static> = Collation {
3733        id: CollationId::UTF8MB4_ET_0900_AS_CS,
3734        charset: "utf8mb4",
3735        collation: "utf8mb4_et_0900_as_cs",
3736        is_default: false,
3737        padding: PadAttribute::PadZero,
3738        is_compiled: true,
3739        sort_len: 0,
3740        max_len: 4,
3741    };
3742    /// UTF-8 Unicode
3743    const UTF8MB4_ES_0900_AS_CS_COLLATION: Collation<'static> = Collation {
3744        id: CollationId::UTF8MB4_ES_0900_AS_CS,
3745        charset: "utf8mb4",
3746        collation: "utf8mb4_es_0900_as_cs",
3747        is_default: false,
3748        padding: PadAttribute::PadZero,
3749        is_compiled: true,
3750        sort_len: 0,
3751        max_len: 4,
3752    };
3753    /// UTF-8 Unicode
3754    const UTF8MB4_SV_0900_AS_CS_COLLATION: Collation<'static> = Collation {
3755        id: CollationId::UTF8MB4_SV_0900_AS_CS,
3756        charset: "utf8mb4",
3757        collation: "utf8mb4_sv_0900_as_cs",
3758        is_default: false,
3759        padding: PadAttribute::PadZero,
3760        is_compiled: true,
3761        sort_len: 0,
3762        max_len: 4,
3763    };
3764    /// UTF-8 Unicode
3765    const UTF8MB4_TR_0900_AS_CS_COLLATION: Collation<'static> = Collation {
3766        id: CollationId::UTF8MB4_TR_0900_AS_CS,
3767        charset: "utf8mb4",
3768        collation: "utf8mb4_tr_0900_as_cs",
3769        is_default: false,
3770        padding: PadAttribute::PadZero,
3771        is_compiled: true,
3772        sort_len: 0,
3773        max_len: 4,
3774    };
3775    /// UTF-8 Unicode
3776    const UTF8MB4_CS_0900_AS_CS_COLLATION: Collation<'static> = Collation {
3777        id: CollationId::UTF8MB4_CS_0900_AS_CS,
3778        charset: "utf8mb4",
3779        collation: "utf8mb4_cs_0900_as_cs",
3780        is_default: false,
3781        padding: PadAttribute::PadZero,
3782        is_compiled: true,
3783        sort_len: 0,
3784        max_len: 4,
3785    };
3786    /// UTF-8 Unicode
3787    const UTF8MB4_DA_0900_AS_CS_COLLATION: Collation<'static> = Collation {
3788        id: CollationId::UTF8MB4_DA_0900_AS_CS,
3789        charset: "utf8mb4",
3790        collation: "utf8mb4_da_0900_as_cs",
3791        is_default: false,
3792        padding: PadAttribute::PadZero,
3793        is_compiled: true,
3794        sort_len: 0,
3795        max_len: 4,
3796    };
3797    /// UTF-8 Unicode
3798    const UTF8MB4_LT_0900_AS_CS_COLLATION: Collation<'static> = Collation {
3799        id: CollationId::UTF8MB4_LT_0900_AS_CS,
3800        charset: "utf8mb4",
3801        collation: "utf8mb4_lt_0900_as_cs",
3802        is_default: false,
3803        padding: PadAttribute::PadZero,
3804        is_compiled: true,
3805        sort_len: 0,
3806        max_len: 4,
3807    };
3808    /// UTF-8 Unicode
3809    const UTF8MB4_SK_0900_AS_CS_COLLATION: Collation<'static> = Collation {
3810        id: CollationId::UTF8MB4_SK_0900_AS_CS,
3811        charset: "utf8mb4",
3812        collation: "utf8mb4_sk_0900_as_cs",
3813        is_default: false,
3814        padding: PadAttribute::PadZero,
3815        is_compiled: true,
3816        sort_len: 0,
3817        max_len: 4,
3818    };
3819    /// UTF-8 Unicode
3820    const UTF8MB4_ES_TRAD_0900_AS_CS_COLLATION: Collation<'static> = Collation {
3821        id: CollationId::UTF8MB4_ES_TRAD_0900_AS_CS,
3822        charset: "utf8mb4",
3823        collation: "utf8mb4_es_trad_0900_as_cs",
3824        is_default: false,
3825        padding: PadAttribute::PadZero,
3826        is_compiled: true,
3827        sort_len: 0,
3828        max_len: 4,
3829    };
3830    /// UTF-8 Unicode
3831    const UTF8MB4_LA_0900_AS_CS_COLLATION: Collation<'static> = Collation {
3832        id: CollationId::UTF8MB4_LA_0900_AS_CS,
3833        charset: "utf8mb4",
3834        collation: "utf8mb4_la_0900_as_cs",
3835        is_default: false,
3836        padding: PadAttribute::PadZero,
3837        is_compiled: true,
3838        sort_len: 0,
3839        max_len: 4,
3840    };
3841    /// UTF-8 Unicode
3842    const UTF8MB4_EO_0900_AS_CS_COLLATION: Collation<'static> = Collation {
3843        id: CollationId::UTF8MB4_EO_0900_AS_CS,
3844        charset: "utf8mb4",
3845        collation: "utf8mb4_eo_0900_as_cs",
3846        is_default: false,
3847        padding: PadAttribute::PadZero,
3848        is_compiled: true,
3849        sort_len: 0,
3850        max_len: 4,
3851    };
3852    /// UTF-8 Unicode
3853    const UTF8MB4_HU_0900_AS_CS_COLLATION: Collation<'static> = Collation {
3854        id: CollationId::UTF8MB4_HU_0900_AS_CS,
3855        charset: "utf8mb4",
3856        collation: "utf8mb4_hu_0900_as_cs",
3857        is_default: false,
3858        padding: PadAttribute::PadZero,
3859        is_compiled: true,
3860        sort_len: 0,
3861        max_len: 4,
3862    };
3863    /// UTF-8 Unicode
3864    const UTF8MB4_HR_0900_AS_CS_COLLATION: Collation<'static> = Collation {
3865        id: CollationId::UTF8MB4_HR_0900_AS_CS,
3866        charset: "utf8mb4",
3867        collation: "utf8mb4_hr_0900_as_cs",
3868        is_default: false,
3869        padding: PadAttribute::PadZero,
3870        is_compiled: true,
3871        sort_len: 0,
3872        max_len: 4,
3873    };
3874    /// UTF-8 Unicode
3875    const UTF8MB4_VI_0900_AS_CS_COLLATION: Collation<'static> = Collation {
3876        id: CollationId::UTF8MB4_VI_0900_AS_CS,
3877        charset: "utf8mb4",
3878        collation: "utf8mb4_vi_0900_as_cs",
3879        is_default: false,
3880        padding: PadAttribute::PadZero,
3881        is_compiled: true,
3882        sort_len: 0,
3883        max_len: 4,
3884    };
3885    /// UTF-8 Unicode
3886    const UTF8MB4_JA_0900_AS_CS_COLLATION: Collation<'static> = Collation {
3887        id: CollationId::UTF8MB4_JA_0900_AS_CS,
3888        charset: "utf8mb4",
3889        collation: "utf8mb4_ja_0900_as_cs",
3890        is_default: false,
3891        padding: PadAttribute::PadZero,
3892        is_compiled: true,
3893        sort_len: 0,
3894        max_len: 4,
3895    };
3896    /// UTF-8 Unicode
3897    const UTF8MB4_JA_0900_AS_CS_KS_COLLATION: Collation<'static> = Collation {
3898        id: CollationId::UTF8MB4_JA_0900_AS_CS_KS,
3899        charset: "utf8mb4",
3900        collation: "utf8mb4_ja_0900_as_cs_ks",
3901        is_default: false,
3902        padding: PadAttribute::PadZero,
3903        is_compiled: true,
3904        sort_len: 24,
3905        max_len: 4,
3906    };
3907    /// UTF-8 Unicode
3908    const UTF8MB4_0900_AS_CI_COLLATION: Collation<'static> = Collation {
3909        id: CollationId::UTF8MB4_0900_AS_CI,
3910        charset: "utf8mb4",
3911        collation: "utf8mb4_0900_as_ci",
3912        is_default: false,
3913        padding: PadAttribute::PadZero,
3914        is_compiled: true,
3915        sort_len: 0,
3916        max_len: 4,
3917    };
3918    /// UTF-8 Unicode
3919    const UTF8MB4_RU_0900_AI_CI_COLLATION: Collation<'static> = Collation {
3920        id: CollationId::UTF8MB4_RU_0900_AI_CI,
3921        charset: "utf8mb4",
3922        collation: "utf8mb4_ru_0900_ai_ci",
3923        is_default: false,
3924        padding: PadAttribute::PadZero,
3925        is_compiled: true,
3926        sort_len: 0,
3927        max_len: 4,
3928    };
3929    /// UTF-8 Unicode
3930    const UTF8MB4_RU_0900_AS_CS_COLLATION: Collation<'static> = Collation {
3931        id: CollationId::UTF8MB4_RU_0900_AS_CS,
3932        charset: "utf8mb4",
3933        collation: "utf8mb4_ru_0900_as_cs",
3934        is_default: false,
3935        padding: PadAttribute::PadZero,
3936        is_compiled: true,
3937        sort_len: 0,
3938        max_len: 4,
3939    };
3940    /// UTF-8 Unicode
3941    const UTF8MB4_ZH_0900_AS_CS_COLLATION: Collation<'static> = Collation {
3942        id: CollationId::UTF8MB4_ZH_0900_AS_CS,
3943        charset: "utf8mb4",
3944        collation: "utf8mb4_zh_0900_as_cs",
3945        is_default: false,
3946        padding: PadAttribute::PadZero,
3947        is_compiled: true,
3948        sort_len: 0,
3949        max_len: 4,
3950    };
3951    /// UTF-8 Unicode
3952    const UTF8MB4_0900_BIN_COLLATION: Collation<'static> = Collation {
3953        id: CollationId::UTF8MB4_0900_BIN,
3954        charset: "utf8mb4",
3955        collation: "utf8mb4_0900_bin",
3956        is_default: false,
3957        padding: PadAttribute::PadZero,
3958        is_compiled: true,
3959        sort_len: 1,
3960        max_len: 4,
3961    };
3962    /// UTF-8 Unicode
3963    const UTF8MB4_NB_0900_AI_CI_COLLATION: Collation<'static> = Collation {
3964        id: CollationId::UTF8MB4_NB_0900_AI_CI,
3965        charset: "utf8mb4",
3966        collation: "utf8mb4_nb_0900_ai_ci",
3967        is_default: false,
3968        padding: PadAttribute::PadZero,
3969        is_compiled: true,
3970        sort_len: 0,
3971        max_len: 4,
3972    };
3973    /// UTF-8 Unicode
3974    const UTF8MB4_NB_0900_AS_CS_COLLATION: Collation<'static> = Collation {
3975        id: CollationId::UTF8MB4_NB_0900_AS_CS,
3976        charset: "utf8mb4",
3977        collation: "utf8mb4_nb_0900_as_cs",
3978        is_default: false,
3979        padding: PadAttribute::PadZero,
3980        is_compiled: true,
3981        sort_len: 0,
3982        max_len: 4,
3983    };
3984    /// UTF-8 Unicode
3985    const UTF8MB4_NN_0900_AI_CI_COLLATION: Collation<'static> = Collation {
3986        id: CollationId::UTF8MB4_NN_0900_AI_CI,
3987        charset: "utf8mb4",
3988        collation: "utf8mb4_nn_0900_ai_ci",
3989        is_default: false,
3990        padding: PadAttribute::PadZero,
3991        is_compiled: true,
3992        sort_len: 0,
3993        max_len: 4,
3994    };
3995    /// UTF-8 Unicode
3996    const UTF8MB4_NN_0900_AS_CS_COLLATION: Collation<'static> = Collation {
3997        id: CollationId::UTF8MB4_NN_0900_AS_CS,
3998        charset: "utf8mb4",
3999        collation: "utf8mb4_nn_0900_as_cs",
4000        is_default: false,
4001        padding: PadAttribute::PadZero,
4002        is_compiled: true,
4003        sort_len: 0,
4004        max_len: 4,
4005    };
4006    /// UTF-8 Unicode
4007    const UTF8MB4_SR_LATN_0900_AI_CI_COLLATION: Collation<'static> = Collation {
4008        id: CollationId::UTF8MB4_SR_LATN_0900_AI_CI,
4009        charset: "utf8mb4",
4010        collation: "utf8mb4_sr_latn_0900_ai_ci",
4011        is_default: false,
4012        padding: PadAttribute::PadZero,
4013        is_compiled: true,
4014        sort_len: 0,
4015        max_len: 4,
4016    };
4017    /// UTF-8 Unicode
4018    const UTF8MB4_SR_LATN_0900_AS_CS_COLLATION: Collation<'static> = Collation {
4019        id: CollationId::UTF8MB4_SR_LATN_0900_AS_CS,
4020        charset: "utf8mb4",
4021        collation: "utf8mb4_sr_latn_0900_as_cs",
4022        is_default: false,
4023        padding: PadAttribute::PadZero,
4024        is_compiled: true,
4025        sort_len: 0,
4026        max_len: 4,
4027    };
4028    /// UTF-8 Unicode
4029    const UTF8MB4_BS_0900_AI_CI_COLLATION: Collation<'static> = Collation {
4030        id: CollationId::UTF8MB4_BS_0900_AI_CI,
4031        charset: "utf8mb4",
4032        collation: "utf8mb4_bs_0900_ai_ci",
4033        is_default: false,
4034        padding: PadAttribute::PadZero,
4035        is_compiled: true,
4036        sort_len: 0,
4037        max_len: 4,
4038    };
4039    /// UTF-8 Unicode
4040    const UTF8MB4_BS_0900_AS_CS_COLLATION: Collation<'static> = Collation {
4041        id: CollationId::UTF8MB4_BS_0900_AS_CS,
4042        charset: "utf8mb4",
4043        collation: "utf8mb4_bs_0900_as_cs",
4044        is_default: false,
4045        padding: PadAttribute::PadZero,
4046        is_compiled: true,
4047        sort_len: 0,
4048        max_len: 4,
4049    };
4050    /// UTF-8 Unicode
4051    const UTF8MB4_BG_0900_AI_CI_COLLATION: Collation<'static> = Collation {
4052        id: CollationId::UTF8MB4_BG_0900_AI_CI,
4053        charset: "utf8mb4",
4054        collation: "utf8mb4_bg_0900_ai_ci",
4055        is_default: false,
4056        padding: PadAttribute::PadZero,
4057        is_compiled: true,
4058        sort_len: 0,
4059        max_len: 4,
4060    };
4061    /// UTF-8 Unicode
4062    const UTF8MB4_BG_0900_AS_CS_COLLATION: Collation<'static> = Collation {
4063        id: CollationId::UTF8MB4_BG_0900_AS_CS,
4064        charset: "utf8mb4",
4065        collation: "utf8mb4_bg_0900_as_cs",
4066        is_default: false,
4067        padding: PadAttribute::PadZero,
4068        is_compiled: true,
4069        sort_len: 0,
4070        max_len: 4,
4071    };
4072    /// UTF-8 Unicode
4073    const UTF8MB4_GL_0900_AI_CI_COLLATION: Collation<'static> = Collation {
4074        id: CollationId::UTF8MB4_GL_0900_AI_CI,
4075        charset: "utf8mb4",
4076        collation: "utf8mb4_gl_0900_ai_ci",
4077        is_default: false,
4078        padding: PadAttribute::PadZero,
4079        is_compiled: true,
4080        sort_len: 0,
4081        max_len: 4,
4082    };
4083    /// UTF-8 Unicode
4084    const UTF8MB4_GL_0900_AS_CS_COLLATION: Collation<'static> = Collation {
4085        id: CollationId::UTF8MB4_GL_0900_AS_CS,
4086        charset: "utf8mb4",
4087        collation: "utf8mb4_gl_0900_as_cs",
4088        is_default: false,
4089        padding: PadAttribute::PadZero,
4090        is_compiled: true,
4091        sort_len: 0,
4092        max_len: 4,
4093    };
4094    /// UTF-8 Unicode
4095    const UTF8MB4_MN_CYRL_0900_AI_CI_COLLATION: Collation<'static> = Collation {
4096        id: CollationId::UTF8MB4_MN_CYRL_0900_AI_CI,
4097        charset: "utf8mb4",
4098        collation: "utf8mb4_mn_cyrl_0900_ai_ci",
4099        is_default: false,
4100        padding: PadAttribute::PadZero,
4101        is_compiled: true,
4102        sort_len: 0,
4103        max_len: 4,
4104    };
4105    /// UTF-8 Unicode
4106    const UTF8MB4_MN_CYRL_0900_AS_CS_COLLATION: Collation<'static> = Collation {
4107        id: CollationId::UTF8MB4_MN_CYRL_0900_AS_CS,
4108        charset: "utf8mb4",
4109        collation: "utf8mb4_mn_cyrl_0900_as_cs",
4110        is_default: false,
4111        padding: PadAttribute::PadZero,
4112        is_compiled: true,
4113        sort_len: 0,
4114        max_len: 4,
4115    };
4116
4117    /// Get the collation ID.
4118    pub fn id(&self) -> CollationId {
4119        self.id
4120    }
4121
4122    /// Get the charset.
4123    pub fn charset(&self) -> &str {
4124        self.charset
4125    }
4126
4127    /// Get the collation.
4128    pub fn collation(&self) -> &str {
4129        self.collation
4130    }
4131
4132    /// Is the collation default?
4133    pub fn is_default(&self) -> bool {
4134        self.is_default
4135    }
4136
4137    /// Get the padding attribute.
4138    pub fn padding(&self) -> PadAttribute {
4139        self.padding
4140    }
4141
4142    /// Is the collation compiled?
4143    pub fn is_compiled(&self) -> bool {
4144        self.is_compiled
4145    }
4146
4147    /// Get the sort length.
4148    pub fn sort_len(&self) -> u8 {
4149        self.sort_len
4150    }
4151
4152    /// Get the max length.
4153    pub fn max_len(&self) -> u8 {
4154        self.max_len
4155    }
4156
4157    /// Resolve collation id into a collation.
4158    pub const fn resolve(id: CollationId) -> Collation<'static> {
4159        match id {
4160            CollationId::UNKNOWN_COLLATION_ID => Self::UNKNOWN_COLLATION,
4161            CollationId::BIG5_CHINESE_CI => Self::BIG5_CHINESE_CI_COLLATION,
4162            CollationId::LATIN2_CZECH_CS => Self::LATIN2_CZECH_CS_COLLATION,
4163            CollationId::DEC8_SWEDISH_CI => Self::DEC8_SWEDISH_CI_COLLATION,
4164            CollationId::CP850_GENERAL_CI => Self::CP850_GENERAL_CI_COLLATION,
4165            CollationId::LATIN1_GERMAN1_CI => Self::LATIN1_GERMAN1_CI_COLLATION,
4166            CollationId::HP8_ENGLISH_CI => Self::HP8_ENGLISH_CI_COLLATION,
4167            CollationId::KOI8R_GENERAL_CI => Self::KOI8R_GENERAL_CI_COLLATION,
4168            CollationId::LATIN1_SWEDISH_CI => Self::LATIN1_SWEDISH_CI_COLLATION,
4169            CollationId::LATIN2_GENERAL_CI => Self::LATIN2_GENERAL_CI_COLLATION,
4170            CollationId::SWE7_SWEDISH_CI => Self::SWE7_SWEDISH_CI_COLLATION,
4171            CollationId::ASCII_GENERAL_CI => Self::ASCII_GENERAL_CI_COLLATION,
4172            CollationId::UJIS_JAPANESE_CI => Self::UJIS_JAPANESE_CI_COLLATION,
4173            CollationId::SJIS_JAPANESE_CI => Self::SJIS_JAPANESE_CI_COLLATION,
4174            CollationId::CP1251_BULGARIAN_CI => Self::CP1251_BULGARIAN_CI_COLLATION,
4175            CollationId::LATIN1_DANISH_CI => Self::LATIN1_DANISH_CI_COLLATION,
4176            CollationId::HEBREW_GENERAL_CI => Self::HEBREW_GENERAL_CI_COLLATION,
4177            CollationId::TIS620_THAI_CI => Self::TIS620_THAI_CI_COLLATION,
4178            CollationId::EUCKR_KOREAN_CI => Self::EUCKR_KOREAN_CI_COLLATION,
4179            CollationId::LATIN7_ESTONIAN_CS => Self::LATIN7_ESTONIAN_CS_COLLATION,
4180            CollationId::LATIN2_HUNGARIAN_CI => Self::LATIN2_HUNGARIAN_CI_COLLATION,
4181            CollationId::KOI8U_GENERAL_CI => Self::KOI8U_GENERAL_CI_COLLATION,
4182            CollationId::CP1251_UKRAINIAN_CI => Self::CP1251_UKRAINIAN_CI_COLLATION,
4183            CollationId::GB2312_CHINESE_CI => Self::GB2312_CHINESE_CI_COLLATION,
4184            CollationId::GREEK_GENERAL_CI => Self::GREEK_GENERAL_CI_COLLATION,
4185            CollationId::CP1250_GENERAL_CI => Self::CP1250_GENERAL_CI_COLLATION,
4186            CollationId::LATIN2_CROATIAN_CI => Self::LATIN2_CROATIAN_CI_COLLATION,
4187            CollationId::GBK_CHINESE_CI => Self::GBK_CHINESE_CI_COLLATION,
4188            CollationId::CP1257_LITHUANIAN_CI => Self::CP1257_LITHUANIAN_CI_COLLATION,
4189            CollationId::LATIN5_TURKISH_CI => Self::LATIN5_TURKISH_CI_COLLATION,
4190            CollationId::LATIN1_GERMAN2_CI => Self::LATIN1_GERMAN2_CI_COLLATION,
4191            CollationId::ARMSCII8_GENERAL_CI => Self::ARMSCII8_GENERAL_CI_COLLATION,
4192            CollationId::UTF8MB3_GENERAL_CI => Self::UTF8MB3_GENERAL_CI_COLLATION,
4193            CollationId::CP1250_CZECH_CS => Self::CP1250_CZECH_CS_COLLATION,
4194            CollationId::UCS2_GENERAL_CI => Self::UCS2_GENERAL_CI_COLLATION,
4195            CollationId::CP866_GENERAL_CI => Self::CP866_GENERAL_CI_COLLATION,
4196            CollationId::KEYBCS2_GENERAL_CI => Self::KEYBCS2_GENERAL_CI_COLLATION,
4197            CollationId::MACCE_GENERAL_CI => Self::MACCE_GENERAL_CI_COLLATION,
4198            CollationId::MACROMAN_GENERAL_CI => Self::MACROMAN_GENERAL_CI_COLLATION,
4199            CollationId::CP852_GENERAL_CI => Self::CP852_GENERAL_CI_COLLATION,
4200            CollationId::LATIN7_GENERAL_CI => Self::LATIN7_GENERAL_CI_COLLATION,
4201            CollationId::LATIN7_GENERAL_CS => Self::LATIN7_GENERAL_CS_COLLATION,
4202            CollationId::MACCE_BIN => Self::MACCE_BIN_COLLATION,
4203            CollationId::CP1250_CROATIAN_CI => Self::CP1250_CROATIAN_CI_COLLATION,
4204            CollationId::UTF8MB4_GENERAL_CI => Self::UTF8MB4_GENERAL_CI_COLLATION,
4205            CollationId::UTF8MB4_BIN => Self::UTF8MB4_BIN_COLLATION,
4206            CollationId::LATIN1_BIN => Self::LATIN1_BIN_COLLATION,
4207            CollationId::LATIN1_GENERAL_CI => Self::LATIN1_GENERAL_CI_COLLATION,
4208            CollationId::LATIN1_GENERAL_CS => Self::LATIN1_GENERAL_CS_COLLATION,
4209            CollationId::CP1251_BIN => Self::CP1251_BIN_COLLATION,
4210            CollationId::CP1251_GENERAL_CI => Self::CP1251_GENERAL_CI_COLLATION,
4211            CollationId::CP1251_GENERAL_CS => Self::CP1251_GENERAL_CS_COLLATION,
4212            CollationId::MACROMAN_BIN => Self::MACROMAN_BIN_COLLATION,
4213            CollationId::UTF16_GENERAL_CI => Self::UTF16_GENERAL_CI_COLLATION,
4214            CollationId::UTF16_BIN => Self::UTF16_BIN_COLLATION,
4215            CollationId::UTF16LE_GENERAL_CI => Self::UTF16LE_GENERAL_CI_COLLATION,
4216            CollationId::CP1256_GENERAL_CI => Self::CP1256_GENERAL_CI_COLLATION,
4217            CollationId::CP1257_BIN => Self::CP1257_BIN_COLLATION,
4218            CollationId::CP1257_GENERAL_CI => Self::CP1257_GENERAL_CI_COLLATION,
4219            CollationId::UTF32_GENERAL_CI => Self::UTF32_GENERAL_CI_COLLATION,
4220            CollationId::UTF32_BIN => Self::UTF32_BIN_COLLATION,
4221            CollationId::UTF16LE_BIN => Self::UTF16LE_BIN_COLLATION,
4222            CollationId::BINARY => Self::BINARY_COLLATION,
4223            CollationId::ARMSCII8_BIN => Self::ARMSCII8_BIN_COLLATION,
4224            CollationId::ASCII_BIN => Self::ASCII_BIN_COLLATION,
4225            CollationId::CP1250_BIN => Self::CP1250_BIN_COLLATION,
4226            CollationId::CP1256_BIN => Self::CP1256_BIN_COLLATION,
4227            CollationId::CP866_BIN => Self::CP866_BIN_COLLATION,
4228            CollationId::DEC8_BIN => Self::DEC8_BIN_COLLATION,
4229            CollationId::GREEK_BIN => Self::GREEK_BIN_COLLATION,
4230            CollationId::HEBREW_BIN => Self::HEBREW_BIN_COLLATION,
4231            CollationId::HP8_BIN => Self::HP8_BIN_COLLATION,
4232            CollationId::KEYBCS2_BIN => Self::KEYBCS2_BIN_COLLATION,
4233            CollationId::KOI8R_BIN => Self::KOI8R_BIN_COLLATION,
4234            CollationId::KOI8U_BIN => Self::KOI8U_BIN_COLLATION,
4235            CollationId::UTF8MB3_TOLOWER_CI => Self::UTF8MB3_TOLOWER_CI_COLLATION,
4236            CollationId::LATIN2_BIN => Self::LATIN2_BIN_COLLATION,
4237            CollationId::LATIN5_BIN => Self::LATIN5_BIN_COLLATION,
4238            CollationId::LATIN7_BIN => Self::LATIN7_BIN_COLLATION,
4239            CollationId::CP850_BIN => Self::CP850_BIN_COLLATION,
4240            CollationId::CP852_BIN => Self::CP852_BIN_COLLATION,
4241            CollationId::SWE7_BIN => Self::SWE7_BIN_COLLATION,
4242            CollationId::UTF8MB3_BIN => Self::UTF8MB3_BIN_COLLATION,
4243            CollationId::BIG5_BIN => Self::BIG5_BIN_COLLATION,
4244            CollationId::EUCKR_BIN => Self::EUCKR_BIN_COLLATION,
4245            CollationId::GB2312_BIN => Self::GB2312_BIN_COLLATION,
4246            CollationId::GBK_BIN => Self::GBK_BIN_COLLATION,
4247            CollationId::SJIS_BIN => Self::SJIS_BIN_COLLATION,
4248            CollationId::TIS620_BIN => Self::TIS620_BIN_COLLATION,
4249            CollationId::UCS2_BIN => Self::UCS2_BIN_COLLATION,
4250            CollationId::UJIS_BIN => Self::UJIS_BIN_COLLATION,
4251            CollationId::GEOSTD8_GENERAL_CI => Self::GEOSTD8_GENERAL_CI_COLLATION,
4252            CollationId::GEOSTD8_BIN => Self::GEOSTD8_BIN_COLLATION,
4253            CollationId::LATIN1_SPANISH_CI => Self::LATIN1_SPANISH_CI_COLLATION,
4254            CollationId::CP932_JAPANESE_CI => Self::CP932_JAPANESE_CI_COLLATION,
4255            CollationId::CP932_BIN => Self::CP932_BIN_COLLATION,
4256            CollationId::EUCJPMS_JAPANESE_CI => Self::EUCJPMS_JAPANESE_CI_COLLATION,
4257            CollationId::EUCJPMS_BIN => Self::EUCJPMS_BIN_COLLATION,
4258            CollationId::CP1250_POLISH_CI => Self::CP1250_POLISH_CI_COLLATION,
4259            CollationId::UTF16_UNICODE_CI => Self::UTF16_UNICODE_CI_COLLATION,
4260            CollationId::UTF16_ICELANDIC_CI => Self::UTF16_ICELANDIC_CI_COLLATION,
4261            CollationId::UTF16_LATVIAN_CI => Self::UTF16_LATVIAN_CI_COLLATION,
4262            CollationId::UTF16_ROMANIAN_CI => Self::UTF16_ROMANIAN_CI_COLLATION,
4263            CollationId::UTF16_SLOVENIAN_CI => Self::UTF16_SLOVENIAN_CI_COLLATION,
4264            CollationId::UTF16_POLISH_CI => Self::UTF16_POLISH_CI_COLLATION,
4265            CollationId::UTF16_ESTONIAN_CI => Self::UTF16_ESTONIAN_CI_COLLATION,
4266            CollationId::UTF16_SPANISH_CI => Self::UTF16_SPANISH_CI_COLLATION,
4267            CollationId::UTF16_SWEDISH_CI => Self::UTF16_SWEDISH_CI_COLLATION,
4268            CollationId::UTF16_TURKISH_CI => Self::UTF16_TURKISH_CI_COLLATION,
4269            CollationId::UTF16_CZECH_CI => Self::UTF16_CZECH_CI_COLLATION,
4270            CollationId::UTF16_DANISH_CI => Self::UTF16_DANISH_CI_COLLATION,
4271            CollationId::UTF16_LITHUANIAN_CI => Self::UTF16_LITHUANIAN_CI_COLLATION,
4272            CollationId::UTF16_SLOVAK_CI => Self::UTF16_SLOVAK_CI_COLLATION,
4273            CollationId::UTF16_SPANISH2_CI => Self::UTF16_SPANISH2_CI_COLLATION,
4274            CollationId::UTF16_ROMAN_CI => Self::UTF16_ROMAN_CI_COLLATION,
4275            CollationId::UTF16_PERSIAN_CI => Self::UTF16_PERSIAN_CI_COLLATION,
4276            CollationId::UTF16_ESPERANTO_CI => Self::UTF16_ESPERANTO_CI_COLLATION,
4277            CollationId::UTF16_HUNGARIAN_CI => Self::UTF16_HUNGARIAN_CI_COLLATION,
4278            CollationId::UTF16_SINHALA_CI => Self::UTF16_SINHALA_CI_COLLATION,
4279            CollationId::UTF16_GERMAN2_CI => Self::UTF16_GERMAN2_CI_COLLATION,
4280            CollationId::UTF16_CROATIAN_CI => Self::UTF16_CROATIAN_CI_COLLATION,
4281            CollationId::UTF16_UNICODE_520_CI => Self::UTF16_UNICODE_520_CI_COLLATION,
4282            CollationId::UTF16_VIETNAMESE_CI => Self::UTF16_VIETNAMESE_CI_COLLATION,
4283            CollationId::UCS2_UNICODE_CI => Self::UCS2_UNICODE_CI_COLLATION,
4284            CollationId::UCS2_ICELANDIC_CI => Self::UCS2_ICELANDIC_CI_COLLATION,
4285            CollationId::UCS2_LATVIAN_CI => Self::UCS2_LATVIAN_CI_COLLATION,
4286            CollationId::UCS2_ROMANIAN_CI => Self::UCS2_ROMANIAN_CI_COLLATION,
4287            CollationId::UCS2_SLOVENIAN_CI => Self::UCS2_SLOVENIAN_CI_COLLATION,
4288            CollationId::UCS2_POLISH_CI => Self::UCS2_POLISH_CI_COLLATION,
4289            CollationId::UCS2_ESTONIAN_CI => Self::UCS2_ESTONIAN_CI_COLLATION,
4290            CollationId::UCS2_SPANISH_CI => Self::UCS2_SPANISH_CI_COLLATION,
4291            CollationId::UCS2_SWEDISH_CI => Self::UCS2_SWEDISH_CI_COLLATION,
4292            CollationId::UCS2_TURKISH_CI => Self::UCS2_TURKISH_CI_COLLATION,
4293            CollationId::UCS2_CZECH_CI => Self::UCS2_CZECH_CI_COLLATION,
4294            CollationId::UCS2_DANISH_CI => Self::UCS2_DANISH_CI_COLLATION,
4295            CollationId::UCS2_LITHUANIAN_CI => Self::UCS2_LITHUANIAN_CI_COLLATION,
4296            CollationId::UCS2_SLOVAK_CI => Self::UCS2_SLOVAK_CI_COLLATION,
4297            CollationId::UCS2_SPANISH2_CI => Self::UCS2_SPANISH2_CI_COLLATION,
4298            CollationId::UCS2_ROMAN_CI => Self::UCS2_ROMAN_CI_COLLATION,
4299            CollationId::UCS2_PERSIAN_CI => Self::UCS2_PERSIAN_CI_COLLATION,
4300            CollationId::UCS2_ESPERANTO_CI => Self::UCS2_ESPERANTO_CI_COLLATION,
4301            CollationId::UCS2_HUNGARIAN_CI => Self::UCS2_HUNGARIAN_CI_COLLATION,
4302            CollationId::UCS2_SINHALA_CI => Self::UCS2_SINHALA_CI_COLLATION,
4303            CollationId::UCS2_GERMAN2_CI => Self::UCS2_GERMAN2_CI_COLLATION,
4304            CollationId::UCS2_CROATIAN_CI => Self::UCS2_CROATIAN_CI_COLLATION,
4305            CollationId::UCS2_UNICODE_520_CI => Self::UCS2_UNICODE_520_CI_COLLATION,
4306            CollationId::UCS2_VIETNAMESE_CI => Self::UCS2_VIETNAMESE_CI_COLLATION,
4307            CollationId::UCS2_GENERAL_MYSQL500_CI => Self::UCS2_GENERAL_MYSQL500_CI_COLLATION,
4308            CollationId::UTF32_UNICODE_CI => Self::UTF32_UNICODE_CI_COLLATION,
4309            CollationId::UTF32_ICELANDIC_CI => Self::UTF32_ICELANDIC_CI_COLLATION,
4310            CollationId::UTF32_LATVIAN_CI => Self::UTF32_LATVIAN_CI_COLLATION,
4311            CollationId::UTF32_ROMANIAN_CI => Self::UTF32_ROMANIAN_CI_COLLATION,
4312            CollationId::UTF32_SLOVENIAN_CI => Self::UTF32_SLOVENIAN_CI_COLLATION,
4313            CollationId::UTF32_POLISH_CI => Self::UTF32_POLISH_CI_COLLATION,
4314            CollationId::UTF32_ESTONIAN_CI => Self::UTF32_ESTONIAN_CI_COLLATION,
4315            CollationId::UTF32_SPANISH_CI => Self::UTF32_SPANISH_CI_COLLATION,
4316            CollationId::UTF32_SWEDISH_CI => Self::UTF32_SWEDISH_CI_COLLATION,
4317            CollationId::UTF32_TURKISH_CI => Self::UTF32_TURKISH_CI_COLLATION,
4318            CollationId::UTF32_CZECH_CI => Self::UTF32_CZECH_CI_COLLATION,
4319            CollationId::UTF32_DANISH_CI => Self::UTF32_DANISH_CI_COLLATION,
4320            CollationId::UTF32_LITHUANIAN_CI => Self::UTF32_LITHUANIAN_CI_COLLATION,
4321            CollationId::UTF32_SLOVAK_CI => Self::UTF32_SLOVAK_CI_COLLATION,
4322            CollationId::UTF32_SPANISH2_CI => Self::UTF32_SPANISH2_CI_COLLATION,
4323            CollationId::UTF32_ROMAN_CI => Self::UTF32_ROMAN_CI_COLLATION,
4324            CollationId::UTF32_PERSIAN_CI => Self::UTF32_PERSIAN_CI_COLLATION,
4325            CollationId::UTF32_ESPERANTO_CI => Self::UTF32_ESPERANTO_CI_COLLATION,
4326            CollationId::UTF32_HUNGARIAN_CI => Self::UTF32_HUNGARIAN_CI_COLLATION,
4327            CollationId::UTF32_SINHALA_CI => Self::UTF32_SINHALA_CI_COLLATION,
4328            CollationId::UTF32_GERMAN2_CI => Self::UTF32_GERMAN2_CI_COLLATION,
4329            CollationId::UTF32_CROATIAN_CI => Self::UTF32_CROATIAN_CI_COLLATION,
4330            CollationId::UTF32_UNICODE_520_CI => Self::UTF32_UNICODE_520_CI_COLLATION,
4331            CollationId::UTF32_VIETNAMESE_CI => Self::UTF32_VIETNAMESE_CI_COLLATION,
4332            CollationId::UTF8MB3_UNICODE_CI => Self::UTF8MB3_UNICODE_CI_COLLATION,
4333            CollationId::UTF8MB3_ICELANDIC_CI => Self::UTF8MB3_ICELANDIC_CI_COLLATION,
4334            CollationId::UTF8MB3_LATVIAN_CI => Self::UTF8MB3_LATVIAN_CI_COLLATION,
4335            CollationId::UTF8MB3_ROMANIAN_CI => Self::UTF8MB3_ROMANIAN_CI_COLLATION,
4336            CollationId::UTF8MB3_SLOVENIAN_CI => Self::UTF8MB3_SLOVENIAN_CI_COLLATION,
4337            CollationId::UTF8MB3_POLISH_CI => Self::UTF8MB3_POLISH_CI_COLLATION,
4338            CollationId::UTF8MB3_ESTONIAN_CI => Self::UTF8MB3_ESTONIAN_CI_COLLATION,
4339            CollationId::UTF8MB3_SPANISH_CI => Self::UTF8MB3_SPANISH_CI_COLLATION,
4340            CollationId::UTF8MB3_SWEDISH_CI => Self::UTF8MB3_SWEDISH_CI_COLLATION,
4341            CollationId::UTF8MB3_TURKISH_CI => Self::UTF8MB3_TURKISH_CI_COLLATION,
4342            CollationId::UTF8MB3_CZECH_CI => Self::UTF8MB3_CZECH_CI_COLLATION,
4343            CollationId::UTF8MB3_DANISH_CI => Self::UTF8MB3_DANISH_CI_COLLATION,
4344            CollationId::UTF8MB3_LITHUANIAN_CI => Self::UTF8MB3_LITHUANIAN_CI_COLLATION,
4345            CollationId::UTF8MB3_SLOVAK_CI => Self::UTF8MB3_SLOVAK_CI_COLLATION,
4346            CollationId::UTF8MB3_SPANISH2_CI => Self::UTF8MB3_SPANISH2_CI_COLLATION,
4347            CollationId::UTF8MB3_ROMAN_CI => Self::UTF8MB3_ROMAN_CI_COLLATION,
4348            CollationId::UTF8MB3_PERSIAN_CI => Self::UTF8MB3_PERSIAN_CI_COLLATION,
4349            CollationId::UTF8MB3_ESPERANTO_CI => Self::UTF8MB3_ESPERANTO_CI_COLLATION,
4350            CollationId::UTF8MB3_HUNGARIAN_CI => Self::UTF8MB3_HUNGARIAN_CI_COLLATION,
4351            CollationId::UTF8MB3_SINHALA_CI => Self::UTF8MB3_SINHALA_CI_COLLATION,
4352            CollationId::UTF8MB3_GERMAN2_CI => Self::UTF8MB3_GERMAN2_CI_COLLATION,
4353            CollationId::UTF8MB3_CROATIAN_CI => Self::UTF8MB3_CROATIAN_CI_COLLATION,
4354            CollationId::UTF8MB3_UNICODE_520_CI => Self::UTF8MB3_UNICODE_520_CI_COLLATION,
4355            CollationId::UTF8MB3_VIETNAMESE_CI => Self::UTF8MB3_VIETNAMESE_CI_COLLATION,
4356            CollationId::UTF8MB3_GENERAL_MYSQL500_CI => Self::UTF8MB3_GENERAL_MYSQL500_CI_COLLATION,
4357            CollationId::UTF8MB4_UNICODE_CI => Self::UTF8MB4_UNICODE_CI_COLLATION,
4358            CollationId::UTF8MB4_ICELANDIC_CI => Self::UTF8MB4_ICELANDIC_CI_COLLATION,
4359            CollationId::UTF8MB4_LATVIAN_CI => Self::UTF8MB4_LATVIAN_CI_COLLATION,
4360            CollationId::UTF8MB4_ROMANIAN_CI => Self::UTF8MB4_ROMANIAN_CI_COLLATION,
4361            CollationId::UTF8MB4_SLOVENIAN_CI => Self::UTF8MB4_SLOVENIAN_CI_COLLATION,
4362            CollationId::UTF8MB4_POLISH_CI => Self::UTF8MB4_POLISH_CI_COLLATION,
4363            CollationId::UTF8MB4_ESTONIAN_CI => Self::UTF8MB4_ESTONIAN_CI_COLLATION,
4364            CollationId::UTF8MB4_SPANISH_CI => Self::UTF8MB4_SPANISH_CI_COLLATION,
4365            CollationId::UTF8MB4_SWEDISH_CI => Self::UTF8MB4_SWEDISH_CI_COLLATION,
4366            CollationId::UTF8MB4_TURKISH_CI => Self::UTF8MB4_TURKISH_CI_COLLATION,
4367            CollationId::UTF8MB4_CZECH_CI => Self::UTF8MB4_CZECH_CI_COLLATION,
4368            CollationId::UTF8MB4_DANISH_CI => Self::UTF8MB4_DANISH_CI_COLLATION,
4369            CollationId::UTF8MB4_LITHUANIAN_CI => Self::UTF8MB4_LITHUANIAN_CI_COLLATION,
4370            CollationId::UTF8MB4_SLOVAK_CI => Self::UTF8MB4_SLOVAK_CI_COLLATION,
4371            CollationId::UTF8MB4_SPANISH2_CI => Self::UTF8MB4_SPANISH2_CI_COLLATION,
4372            CollationId::UTF8MB4_ROMAN_CI => Self::UTF8MB4_ROMAN_CI_COLLATION,
4373            CollationId::UTF8MB4_PERSIAN_CI => Self::UTF8MB4_PERSIAN_CI_COLLATION,
4374            CollationId::UTF8MB4_ESPERANTO_CI => Self::UTF8MB4_ESPERANTO_CI_COLLATION,
4375            CollationId::UTF8MB4_HUNGARIAN_CI => Self::UTF8MB4_HUNGARIAN_CI_COLLATION,
4376            CollationId::UTF8MB4_SINHALA_CI => Self::UTF8MB4_SINHALA_CI_COLLATION,
4377            CollationId::UTF8MB4_GERMAN2_CI => Self::UTF8MB4_GERMAN2_CI_COLLATION,
4378            CollationId::UTF8MB4_CROATIAN_CI => Self::UTF8MB4_CROATIAN_CI_COLLATION,
4379            CollationId::UTF8MB4_UNICODE_520_CI => Self::UTF8MB4_UNICODE_520_CI_COLLATION,
4380            CollationId::UTF8MB4_VIETNAMESE_CI => Self::UTF8MB4_VIETNAMESE_CI_COLLATION,
4381            CollationId::GB18030_CHINESE_CI => Self::GB18030_CHINESE_CI_COLLATION,
4382            CollationId::GB18030_BIN => Self::GB18030_BIN_COLLATION,
4383            CollationId::GB18030_UNICODE_520_CI => Self::GB18030_UNICODE_520_CI_COLLATION,
4384            CollationId::UTF8MB4_0900_AI_CI => Self::UTF8MB4_0900_AI_CI_COLLATION,
4385            CollationId::UTF8MB4_DE_PB_0900_AI_CI => Self::UTF8MB4_DE_PB_0900_AI_CI_COLLATION,
4386            CollationId::UTF8MB4_IS_0900_AI_CI => Self::UTF8MB4_IS_0900_AI_CI_COLLATION,
4387            CollationId::UTF8MB4_LV_0900_AI_CI => Self::UTF8MB4_LV_0900_AI_CI_COLLATION,
4388            CollationId::UTF8MB4_RO_0900_AI_CI => Self::UTF8MB4_RO_0900_AI_CI_COLLATION,
4389            CollationId::UTF8MB4_SL_0900_AI_CI => Self::UTF8MB4_SL_0900_AI_CI_COLLATION,
4390            CollationId::UTF8MB4_PL_0900_AI_CI => Self::UTF8MB4_PL_0900_AI_CI_COLLATION,
4391            CollationId::UTF8MB4_ET_0900_AI_CI => Self::UTF8MB4_ET_0900_AI_CI_COLLATION,
4392            CollationId::UTF8MB4_ES_0900_AI_CI => Self::UTF8MB4_ES_0900_AI_CI_COLLATION,
4393            CollationId::UTF8MB4_SV_0900_AI_CI => Self::UTF8MB4_SV_0900_AI_CI_COLLATION,
4394            CollationId::UTF8MB4_TR_0900_AI_CI => Self::UTF8MB4_TR_0900_AI_CI_COLLATION,
4395            CollationId::UTF8MB4_CS_0900_AI_CI => Self::UTF8MB4_CS_0900_AI_CI_COLLATION,
4396            CollationId::UTF8MB4_DA_0900_AI_CI => Self::UTF8MB4_DA_0900_AI_CI_COLLATION,
4397            CollationId::UTF8MB4_LT_0900_AI_CI => Self::UTF8MB4_LT_0900_AI_CI_COLLATION,
4398            CollationId::UTF8MB4_SK_0900_AI_CI => Self::UTF8MB4_SK_0900_AI_CI_COLLATION,
4399            CollationId::UTF8MB4_ES_TRAD_0900_AI_CI => Self::UTF8MB4_ES_TRAD_0900_AI_CI_COLLATION,
4400            CollationId::UTF8MB4_LA_0900_AI_CI => Self::UTF8MB4_LA_0900_AI_CI_COLLATION,
4401            CollationId::UTF8MB4_EO_0900_AI_CI => Self::UTF8MB4_EO_0900_AI_CI_COLLATION,
4402            CollationId::UTF8MB4_HU_0900_AI_CI => Self::UTF8MB4_HU_0900_AI_CI_COLLATION,
4403            CollationId::UTF8MB4_HR_0900_AI_CI => Self::UTF8MB4_HR_0900_AI_CI_COLLATION,
4404            CollationId::UTF8MB4_VI_0900_AI_CI => Self::UTF8MB4_VI_0900_AI_CI_COLLATION,
4405            CollationId::UTF8MB4_0900_AS_CS => Self::UTF8MB4_0900_AS_CS_COLLATION,
4406            CollationId::UTF8MB4_DE_PB_0900_AS_CS => Self::UTF8MB4_DE_PB_0900_AS_CS_COLLATION,
4407            CollationId::UTF8MB4_IS_0900_AS_CS => Self::UTF8MB4_IS_0900_AS_CS_COLLATION,
4408            CollationId::UTF8MB4_LV_0900_AS_CS => Self::UTF8MB4_LV_0900_AS_CS_COLLATION,
4409            CollationId::UTF8MB4_RO_0900_AS_CS => Self::UTF8MB4_RO_0900_AS_CS_COLLATION,
4410            CollationId::UTF8MB4_SL_0900_AS_CS => Self::UTF8MB4_SL_0900_AS_CS_COLLATION,
4411            CollationId::UTF8MB4_PL_0900_AS_CS => Self::UTF8MB4_PL_0900_AS_CS_COLLATION,
4412            CollationId::UTF8MB4_ET_0900_AS_CS => Self::UTF8MB4_ET_0900_AS_CS_COLLATION,
4413            CollationId::UTF8MB4_ES_0900_AS_CS => Self::UTF8MB4_ES_0900_AS_CS_COLLATION,
4414            CollationId::UTF8MB4_SV_0900_AS_CS => Self::UTF8MB4_SV_0900_AS_CS_COLLATION,
4415            CollationId::UTF8MB4_TR_0900_AS_CS => Self::UTF8MB4_TR_0900_AS_CS_COLLATION,
4416            CollationId::UTF8MB4_CS_0900_AS_CS => Self::UTF8MB4_CS_0900_AS_CS_COLLATION,
4417            CollationId::UTF8MB4_DA_0900_AS_CS => Self::UTF8MB4_DA_0900_AS_CS_COLLATION,
4418            CollationId::UTF8MB4_LT_0900_AS_CS => Self::UTF8MB4_LT_0900_AS_CS_COLLATION,
4419            CollationId::UTF8MB4_SK_0900_AS_CS => Self::UTF8MB4_SK_0900_AS_CS_COLLATION,
4420            CollationId::UTF8MB4_ES_TRAD_0900_AS_CS => Self::UTF8MB4_ES_TRAD_0900_AS_CS_COLLATION,
4421            CollationId::UTF8MB4_LA_0900_AS_CS => Self::UTF8MB4_LA_0900_AS_CS_COLLATION,
4422            CollationId::UTF8MB4_EO_0900_AS_CS => Self::UTF8MB4_EO_0900_AS_CS_COLLATION,
4423            CollationId::UTF8MB4_HU_0900_AS_CS => Self::UTF8MB4_HU_0900_AS_CS_COLLATION,
4424            CollationId::UTF8MB4_HR_0900_AS_CS => Self::UTF8MB4_HR_0900_AS_CS_COLLATION,
4425            CollationId::UTF8MB4_VI_0900_AS_CS => Self::UTF8MB4_VI_0900_AS_CS_COLLATION,
4426            CollationId::UTF8MB4_JA_0900_AS_CS => Self::UTF8MB4_JA_0900_AS_CS_COLLATION,
4427            CollationId::UTF8MB4_JA_0900_AS_CS_KS => Self::UTF8MB4_JA_0900_AS_CS_KS_COLLATION,
4428            CollationId::UTF8MB4_0900_AS_CI => Self::UTF8MB4_0900_AS_CI_COLLATION,
4429            CollationId::UTF8MB4_RU_0900_AI_CI => Self::UTF8MB4_RU_0900_AI_CI_COLLATION,
4430            CollationId::UTF8MB4_RU_0900_AS_CS => Self::UTF8MB4_RU_0900_AS_CS_COLLATION,
4431            CollationId::UTF8MB4_ZH_0900_AS_CS => Self::UTF8MB4_ZH_0900_AS_CS_COLLATION,
4432            CollationId::UTF8MB4_0900_BIN => Self::UTF8MB4_0900_BIN_COLLATION,
4433            CollationId::UTF8MB4_NB_0900_AI_CI => Self::UTF8MB4_NB_0900_AI_CI_COLLATION,
4434            CollationId::UTF8MB4_NB_0900_AS_CS => Self::UTF8MB4_NB_0900_AS_CS_COLLATION,
4435            CollationId::UTF8MB4_NN_0900_AI_CI => Self::UTF8MB4_NN_0900_AI_CI_COLLATION,
4436            CollationId::UTF8MB4_NN_0900_AS_CS => Self::UTF8MB4_NN_0900_AS_CS_COLLATION,
4437            CollationId::UTF8MB4_SR_LATN_0900_AI_CI => Self::UTF8MB4_SR_LATN_0900_AI_CI_COLLATION,
4438            CollationId::UTF8MB4_SR_LATN_0900_AS_CS => Self::UTF8MB4_SR_LATN_0900_AS_CS_COLLATION,
4439            CollationId::UTF8MB4_BS_0900_AI_CI => Self::UTF8MB4_BS_0900_AI_CI_COLLATION,
4440            CollationId::UTF8MB4_BS_0900_AS_CS => Self::UTF8MB4_BS_0900_AS_CS_COLLATION,
4441            CollationId::UTF8MB4_BG_0900_AI_CI => Self::UTF8MB4_BG_0900_AI_CI_COLLATION,
4442            CollationId::UTF8MB4_BG_0900_AS_CS => Self::UTF8MB4_BG_0900_AS_CS_COLLATION,
4443            CollationId::UTF8MB4_GL_0900_AI_CI => Self::UTF8MB4_GL_0900_AI_CI_COLLATION,
4444            CollationId::UTF8MB4_GL_0900_AS_CS => Self::UTF8MB4_GL_0900_AS_CS_COLLATION,
4445            CollationId::UTF8MB4_MN_CYRL_0900_AI_CI => Self::UTF8MB4_MN_CYRL_0900_AI_CI_COLLATION,
4446            CollationId::UTF8MB4_MN_CYRL_0900_AS_CS => Self::UTF8MB4_MN_CYRL_0900_AS_CS_COLLATION,
4447        }
4448    }
4449}
4450
4451impl From<CollationId> for Collation<'static> {
4452    /// Convert a collation ID to a collation.
4453    fn from(value: CollationId) -> Self {
4454        Collation::resolve(value)
4455    }
4456}