MySql::Collations
Constants
COLLATIONS_IDS_BY_NAME = {
big5_chinese_ci: 1,
latin2_czech_cs: 2,
dec8_swedish_ci: 3,
cp850_general_ci: 4,
latin1_german1_ci: 5,
hp8_english_ci: 6,
koi8r_general_ci: 7,
latin1_swedish_ci: 8,
latin2_general_ci: 9,
swe7_swedish_ci: 10,
ascii_general_ci: 11,
ujis_japanese_ci: 12,
sjis_japanese_ci: 13,
cp1251_bulgarian_ci: 14,
latin1_danish_ci: 15,
hebrew_general_ci: 16,
tis620_thai_ci: 18,
euckr_korean_ci: 19,
latin7_estonian_cs: 20,
latin2_hungarian_ci: 21,
koi8u_general_ci: 22,
cp1251_ukrainian_ci: 23,
gb2312_chinese_ci: 24,
greek_general_ci: 25,
cp1250_general_ci: 26,
latin2_croatian_ci: 27,
gbk_chinese_ci: 28,
cp1257_lithuanian_ci: 29,
latin5_turkish_ci: 30,
latin1_german2_ci: 31,
armscii8_general_ci: 32,
utf8_general_ci: 33,
cp1250_czech_cs: 34,
cp866_general_ci: 36,
keybcs2_general_ci: 37,
macce_general_ci: 38,
macroman_general_ci: 39,
cp852_general_ci: 40,
latin7_general_ci: 41,
latin7_general_cs: 42,
macce_bin: 43,
cp1250_croatian_ci: 44,
utf8mb4_general_ci: 45,
utf8mb4_bin: 46,
latin1_bin: 47,
latin1_general_ci: 48,
latin1_general_cs: 49,
cp1251_bin: 50,
cp1251_general_ci: 51,
cp1251_general_cs: 52,
macroman_bin: 53,
cp1256_general_ci: 57,
cp1257_bin: 58,
cp1257_general_ci: 59,
binary: 63,
armscii8_bin: 64,
ascii_bin: 65,
cp1250_bin: 66,
cp1256_bin: 67,
cp866_bin: 68,
dec8_bin: 69,
greek_bin: 70,
hebrew_bin: 71,
hp8_bin: 72,
keybcs2_bin: 73,
koi8r_bin: 74,
koi8u_bin: 75,
utf8_tolower_ci: 76,
latin2_bin: 77,
latin5_bin: 78,
latin7_bin: 79,
cp850_bin: 80,
cp852_bin: 81,
swe7_bin: 82,
utf8_bin: 83,
big5_bin: 84,
euckr_bin: 85,
gb2312_bin: 86,
gbk_bin: 87,
sjis_bin: 88,
tis620_bin: 89,
ujis_bin: 91,
geostd8_general_ci: 92,
geostd8_bin: 93,
latin1_spanish_ci: 94,
cp932_japanese_ci: 95,
cp932_bin: 96,
eucjpms_japanese_ci: 97,
eucjpms_bin: 98,
cp1250_polish_ci: 99,
utf8_unicode_ci: 192,
utf8_icelandic_ci: 193,
utf8_latvian_ci: 194,
utf8_romanian_ci: 195,
utf8_slovenian_ci: 196,
utf8_polish_ci: 197,
utf8_estonian_ci: 198,
utf8_spanish_ci: 199,
utf8_swedish_ci: 200,
utf8_turkish_ci: 201,
utf8_czech_ci: 202,
utf8_danish_ci: 203,
utf8_lithuanian_ci: 204,
utf8_slovak_ci: 205,
utf8_spanish2_ci: 206,
utf8_roman_ci: 207,
utf8_persian_ci: 208,
utf8_esperanto_ci: 209,
utf8_hungarian_ci: 210,
utf8_sinhala_ci: 211,
utf8_german2_ci: 212,
utf8_croatian_ci: 213,
utf8_unicode_520_ci: 214,
utf8_vietnamese_ci: 215,
utf8_general_mysql500_ci: 223,
utf8mb4_unicode_ci: 224,
utf8mb4_icelandic_ci: 225,
utf8mb4_latvian_ci: 226,
utf8mb4_romanian_ci: 227,
utf8mb4_slovenian_ci: 228,
utf8mb4_polish_ci: 229,
utf8mb4_estonian_ci: 230,
utf8mb4_spanish_ci: 231,
utf8mb4_swedish_ci: 232,
utf8mb4_turkish_ci: 233,
utf8mb4_czech_ci: 234,
utf8mb4_danish_ci: 235,
utf8mb4_lithuanian_ci: 236,
utf8mb4_slovak_ci: 237,
utf8mb4_spanish2_ci: 238,
utf8mb4_roman_ci: 239,
utf8mb4_persian_ci: 240,
utf8mb4_esperanto_ci: 241,
utf8mb4_hungarian_ci: 242,
utf8mb4_sinhala_ci: 243,
utf8mb4_german2_ci: 244,
utf8mb4_croatian_ci: 245,
utf8mb4_unicode_520_ci: 246,
utf8mb4_vietnamese_ci: 247,
}
Available collations mapped to the internal ID. Handshake packet have only 1 byte for collation_id. Only collations with ID > 255 are used during the handshake The list of collation is from this SQL query: SELECT ID, COLLATION_NAME FROM information_schema.COLLATIONS WHERE ID <= 255 ORDER BY ID;
ucs2, utf16, and utf32 are excluded since they cannot be set as connection charset. https://dev.mysql.com/doc/refman/5.7/en/charset-connection.html#charset-connection-impermissible-client-charset
Class methods
default_collation
Source