Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default
Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database: Queried time:

Character sets and collations

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