mysql8-charset.json

{
  "character_sets": [
    {
      "name": "armscii8",
      "description": "ARMSCII-8 Armenian",
      "default_collation": "armscii8_general_ci",
      "collations": [
        "armscii8_general_ci",
        "armscii8_bin"
      ]
    },
    {
      "name": "ascii",
      "description": "US ASCII",
      "default_collation": "ascii_general_ci",
      "collations": [
        "ascii_general_ci",
        "ascii_bin"
      ]
    },
    {
      "name": "big5",
      "description": "Big5 Traditional Chinese",
      "default_collation": "big5_chinese_ci",
      "collations": [
        "big5_chinese_ci",
        "big5_bin"
      ]
    },
    {
      "name": "binary",
      "description": "Binary pseudo charset",
      "default_collation": "binary",
      "collations": [
        "binary"
      ]
    },
    {
      "name": "cp1250",
      "description": "Windows Central European",
      "default_collation": "cp1250_general_ci",
      "collations": [
        "cp1250_general_ci",
        "cp1250_bin",
        "cp1250_croatian_ci",
        "cp1250_czech_cs",
        "cp1250_polish_ci"
      ]
    },
    {
      "name": "cp1251",
      "description": "Windows Cyrillic",
      "default_collation": "cp1251_general_ci",
      "collations": [
        "cp1251_general_ci",
        "cp1251_bin",
        "cp1251_bulgarian_ci",
        "cp1251_general_cs",
        "cp1251_ukrainian_ci"
      ]
    },
    {
      "name": "cp1256",
      "description": "Windows Arabic",
      "default_collation": "cp1256_general_ci",
      "collations": [
        "cp1256_general_ci",
        "cp1256_bin"
      ]
    },
    {
      "name": "cp1257",
      "description": "Windows Baltic",
      "default_collation": "cp1257_general_ci",
      "collations": [
        "cp1257_general_ci",
        "cp1257_bin",
        "cp1257_lithuanian_ci"
      ]
    },
    {
      "name": "cp850",
      "description": "DOS West European",
      "default_collation": "cp850_general_ci",
      "collations": [
        "cp850_general_ci",
        "cp850_bin"
      ]
    },
    {
      "name": "cp852",
      "description": "DOS Central European",
      "default_collation": "cp852_general_ci",
      "collations": [
        "cp852_general_ci",
        "cp852_bin"
      ]
    },
    {
      "name": "cp866",
      "description": "DOS Russian",
      "default_collation": "cp866_general_ci",
      "collations": [
        "cp866_general_ci",
        "cp866_bin"
      ]
    },
    {
      "name": "cp932",
      "description": "SJIS for Windows Japanese",
      "default_collation": "cp932_japanese_ci",
      "collations": [
        "cp932_japanese_ci",
        "cp932_bin"
      ]
    },
    {
      "name": "dec8",
      "description": "DEC West European",
      "default_collation": "dec8_swedish_ci",
      "collations": [
        "dec8_swedish_ci",
        "dec8_bin"
      ]
    },
    {
      "name": "eucjpms",
      "description": "UJIS for Windows Japanese",
      "default_collation": "eucjpms_japanese_ci",
      "collations": [
        "eucjpms_japanese_ci",
        "eucjpms_bin"
      ]
    },
    {
      "name": "euckr",
      "description": "EUC-KR Korean",
      "default_collation": "euckr_korean_ci",
      "collations": [
        "euckr_korean_ci",
        "euckr_bin"
      ]
    },
    {
      "name": "gb18030",
      "description": "China National Standard GB18030",
      "default_collation": "gb18030_chinese_ci",
      "collations": [
        "gb18030_chinese_ci",
        "gb18030_bin",
        "gb18030_unicode_520_ci"
      ]
    },
    {
      "name": "gb2312",
      "description": "GB2312 Simplified Chinese",
      "default_collation": "gb2312_chinese_ci",
      "collations": [
        "gb2312_chinese_ci",
        "gb2312_bin"
      ]
    },
    {
      "name": "gbk",
      "description": "GBK Simplified Chinese",
      "default_collation": "gbk_chinese_ci",
      "collations": [
        "gbk_chinese_ci",
        "gbk_bin"
      ]
    },
    {
      "name": "geostd8",
      "description": "GEOSTD8 Georgian",
      "default_collation": "geostd8_general_ci",
      "collations": [
        "geostd8_general_ci",
        "geostd8_bin"
      ]
    },
    {
      "name": "greek",
      "description": "ISO 8859-7 Greek",
      "default_collation": "greek_general_ci",
      "collations": [
        "greek_general_ci",
        "greek_bin"
      ]
    },
    {
      "name": "hebrew",
      "description": "ISO 8859-8 Hebrew",
      "default_collation": "hebrew_general_ci",
      "collations": [
        "hebrew_general_ci",
        "hebrew_bin"
      ]
    },
    {
      "name": "hp8",
      "description": "HP West European",
      "default_collation": "hp8_english_ci",
      "collations": [
        "hp8_english_ci",
        "hp8_bin"
      ]
    },
    {
      "name": "keybcs2",
      "description": "DOS Kamenicky Czech-Slovak",
      "default_collation": "keybcs2_general_ci",
      "collations": [
        "keybcs2_general_ci",
        "keybcs2_bin"
      ]
    },
    {
      "name": "koi8r",
      "description": "KOI8-R Relcom Russian",
      "default_collation": "koi8r_general_ci",
      "collations": [
        "koi8r_general_ci",
        "koi8r_bin"
      ]
    },
    {
      "name": "koi8u",
      "description": "KOI8-U Ukrainian",
      "default_collation": "koi8u_general_ci",
      "collations": [
        "koi8u_general_ci",
        "koi8u_bin"
      ]
    },
    {
      "name": "latin1",
      "description": "cp1252 West European",
      "default_collation": "latin1_swedish_ci",
      "collations": [
        "latin1_swedish_ci",
        "latin1_bin",
        "latin1_danish_ci",
        "latin1_general_ci",
        "latin1_general_cs",
        "latin1_german1_ci",
        "latin1_german2_ci",
        "latin1_spanish_ci"
      ]
    },
    {
      "name": "latin2",
      "description": "ISO 8859-2 Central European",
      "default_collation": "latin2_general_ci",
      "collations": [
        "latin2_general_ci",
        "latin2_bin",
        "latin2_croatian_ci",
        "latin2_czech_cs",
        "latin2_hungarian_ci"
      ]
    },
    {
      "name": "latin5",
      "description": "ISO 8859-9 Turkish",
      "default_collation": "latin5_turkish_ci",
      "collations": [
        "latin5_turkish_ci",
        "latin5_bin"
      ]
    },
    {
      "name": "latin7",
      "description": "ISO 8859-13 Baltic",
      "default_collation": "latin7_general_ci",
      "collations": [
        "latin7_general_ci",
        "latin7_bin",
        "latin7_estonian_cs",
        "latin7_general_cs"
      ]
    },
    {
      "name": "macce",
      "description": "Mac Central European",
      "default_collation": "macce_general_ci",
      "collations": [
        "macce_general_ci",
        "macce_bin"
      ]
    },
    {
      "name": "macroman",
      "description": "Mac West European",
      "default_collation": "macroman_general_ci",
      "collations": [
        "macroman_general_ci",
        "macroman_bin"
      ]
    },
    {
      "name": "sjis",
      "description": "Shift-JIS Japanese",
      "default_collation": "sjis_japanese_ci",
      "collations": [
        "sjis_japanese_ci",
        "sjis_bin"
      ]
    },
    {
      "name": "swe7",
      "description": "7bit Swedish",
      "default_collation": "swe7_swedish_ci",
      "collations": [
        "swe7_swedish_ci",
        "swe7_bin"
      ]
    },
    {
      "name": "tis620",
      "description": "TIS620 Thai",
      "default_collation": "tis620_thai_ci",
      "collations": [
        "tis620_thai_ci",
        "tis620_bin"
      ]
    },
    {
      "name": "ucs2",
      "description": "UCS-2 Unicode",
      "default_collation": "ucs2_general_ci",
      "collations": [
        "ucs2_general_ci",
        "ucs2_bin",
        "ucs2_croatian_ci",
        "ucs2_czech_ci",
        "ucs2_danish_ci",
        "ucs2_esperanto_ci",
        "ucs2_estonian_ci",
        "ucs2_general_mysql500_ci",
        "ucs2_german2_ci",
        "ucs2_hungarian_ci",
        "ucs2_icelandic_ci",
        "ucs2_latvian_ci",
        "ucs2_lithuanian_ci",
        "ucs2_persian_ci",
        "ucs2_polish_ci",
        "ucs2_romanian_ci",
        "ucs2_roman_ci",
        "ucs2_sinhala_ci",
        "ucs2_slovak_ci",
        "ucs2_slovenian_ci",
        "ucs2_spanish2_ci",
        "ucs2_spanish_ci",
        "ucs2_swedish_ci",
        "ucs2_turkish_ci",
        "ucs2_unicode_520_ci",
        "ucs2_unicode_ci",
        "ucs2_vietnamese_ci"
      ]
    },
    {
      "name": "ujis",
      "description": "EUC-JP Japanese",
      "default_collation": "ujis_japanese_ci",
      "collations": [
        "ujis_japanese_ci",
        "ujis_bin"
      ]
    },
    {
      "name": "utf16",
      "description": "UTF-16 Unicode",
      "default_collation": "utf16_general_ci",
      "collations": [
        "utf16_general_ci",
        "utf16_bin",
        "utf16_croatian_ci",
        "utf16_czech_ci",
        "utf16_danish_ci",
        "utf16_esperanto_ci",
        "utf16_estonian_ci",
        "utf16_german2_ci",
        "utf16_hungarian_ci",
        "utf16_icelandic_ci",
        "utf16_latvian_ci",
        "utf16_lithuanian_ci",
        "utf16_persian_ci",
        "utf16_polish_ci",
        "utf16_romanian_ci",
        "utf16_roman_ci",
        "utf16_sinhala_ci",
        "utf16_slovak_ci",
        "utf16_slovenian_ci",
        "utf16_spanish2_ci",
        "utf16_spanish_ci",
        "utf16_swedish_ci",
        "utf16_turkish_ci",
        "utf16_unicode_520_ci",
        "utf16_unicode_ci",
        "utf16_vietnamese_ci"
      ]
    },
    {
      "name": "utf16le",
      "description": "UTF-16LE Unicode",
      "default_collation": "utf16le_general_ci",
      "collations": [
        "utf16le_general_ci",
        "utf16le_bin"
      ]
    },
    {
      "name": "utf32",
      "description": "UTF-32 Unicode",
      "default_collation": "utf32_general_ci",
      "collations": [
        "utf32_general_ci",
        "utf32_bin",
        "utf32_croatian_ci",
        "utf32_czech_ci",
        "utf32_danish_ci",
        "utf32_esperanto_ci",
        "utf32_estonian_ci",
        "utf32_german2_ci",
        "utf32_hungarian_ci",
        "utf32_icelandic_ci",
        "utf32_latvian_ci",
        "utf32_lithuanian_ci",
        "utf32_persian_ci",
        "utf32_polish_ci",
        "utf32_romanian_ci",
        "utf32_roman_ci",
        "utf32_sinhala_ci",
        "utf32_slovak_ci",
        "utf32_slovenian_ci",
        "utf32_spanish2_ci",
        "utf32_spanish_ci",
        "utf32_swedish_ci",
        "utf32_turkish_ci",
        "utf32_unicode_520_ci",
        "utf32_unicode_ci",
        "utf32_vietnamese_ci"
      ]
    },
    {
      "name": "utf8mb3",
      "description": "UTF-8 Unicode",
      "default_collation": "utf8_general_ci",
      "collations": [
        "utf8_general_ci",
        "utf8_bin",
        "utf8_croatian_ci",
        "utf8_czech_ci",
        "utf8_danish_ci",
        "utf8_esperanto_ci",
        "utf8_estonian_ci",
        "utf8_general_mysql500_ci",
        "utf8_german2_ci",
        "utf8_hungarian_ci",
        "utf8_icelandic_ci",
        "utf8_latvian_ci",
        "utf8_lithuanian_ci",
        "utf8_persian_ci",
        "utf8_polish_ci",
        "utf8_romanian_ci",
        "utf8_roman_ci",
        "utf8_sinhala_ci",
        "utf8_slovak_ci",
        "utf8_slovenian_ci",
        "utf8_spanish2_ci",
        "utf8_spanish_ci",
        "utf8_swedish_ci",
        "utf8_tolower_ci",
        "utf8_turkish_ci",
        "utf8_unicode_520_ci",
        "utf8_unicode_ci",
        "utf8_vietnamese_ci"
      ]
    },
    {
      "name": "utf8mb4",
      "description": "UTF-8 Unicode",
      "default_collation": "utf8mb4_0900_ai_ci",
      "collations": [
        "utf8mb4_0900_ai_ci",
        "utf8mb4_0900_as_ci",
        "utf8mb4_0900_as_cs",
        "utf8mb4_0900_bin",
        "utf8mb4_bin",
        "utf8mb4_croatian_ci",
        "utf8mb4_cs_0900_ai_ci",
        "utf8mb4_cs_0900_as_cs",
        "utf8mb4_czech_ci",
        "utf8mb4_danish_ci",
        "utf8mb4_da_0900_ai_ci",
        "utf8mb4_da_0900_as_cs",
        "utf8mb4_de_pb_0900_ai_ci",
        "utf8mb4_de_pb_0900_as_cs",
        "utf8mb4_eo_0900_ai_ci",
        "utf8mb4_eo_0900_as_cs",
        "utf8mb4_esperanto_ci",
        "utf8mb4_estonian_ci",
        "utf8mb4_es_0900_ai_ci",
        "utf8mb4_es_0900_as_cs",
        "utf8mb4_es_trad_0900_ai_ci",
        "utf8mb4_es_trad_0900_as_cs",
        "utf8mb4_et_0900_ai_ci",
        "utf8mb4_et_0900_as_cs",
        "utf8mb4_general_ci",
        "utf8mb4_german2_ci",
        "utf8mb4_hr_0900_ai_ci",
        "utf8mb4_hr_0900_as_cs",
        "utf8mb4_hungarian_ci",
        "utf8mb4_hu_0900_ai_ci",
        "utf8mb4_hu_0900_as_cs",
        "utf8mb4_icelandic_ci",
        "utf8mb4_is_0900_ai_ci",
        "utf8mb4_is_0900_as_cs",
        "utf8mb4_ja_0900_as_cs",
        "utf8mb4_ja_0900_as_cs_ks",
        "utf8mb4_latvian_ci",
        "utf8mb4_la_0900_ai_ci",
        "utf8mb4_la_0900_as_cs",
        "utf8mb4_lithuanian_ci",
        "utf8mb4_lt_0900_ai_ci",
        "utf8mb4_lt_0900_as_cs",
        "utf8mb4_lv_0900_ai_ci",
        "utf8mb4_lv_0900_as_cs",
        "utf8mb4_persian_ci",
        "utf8mb4_pl_0900_ai_ci",
        "utf8mb4_pl_0900_as_cs",
        "utf8mb4_polish_ci",
        "utf8mb4_romanian_ci",
        "utf8mb4_roman_ci",
        "utf8mb4_ro_0900_ai_ci",
        "utf8mb4_ro_0900_as_cs",
        "utf8mb4_ru_0900_ai_ci",
        "utf8mb4_ru_0900_as_cs",
        "utf8mb4_sinhala_ci",
        "utf8mb4_sk_0900_ai_ci",
        "utf8mb4_sk_0900_as_cs",
        "utf8mb4_slovak_ci",
        "utf8mb4_slovenian_ci",
        "utf8mb4_sl_0900_ai_ci",
        "utf8mb4_sl_0900_as_cs",
        "utf8mb4_spanish2_ci",
        "utf8mb4_spanish_ci",
        "utf8mb4_sv_0900_ai_ci",
        "utf8mb4_sv_0900_as_cs",
        "utf8mb4_swedish_ci",
        "utf8mb4_tr_0900_ai_ci",
        "utf8mb4_tr_0900_as_cs",
        "utf8mb4_turkish_ci",
        "utf8mb4_unicode_520_ci",
        "utf8mb4_unicode_ci",
        "utf8mb4_vietnamese_ci",
        "utf8mb4_vi_0900_ai_ci",
        "utf8mb4_vi_0900_as_cs",
        "utf8mb4_zh_0900_as_cs"
      ]
    }
  ]
}