Current server:
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
  • armscii8_general_nopad_ci
    Armenian, no-pad, case-insensitive
  • armscii8_nopad_bin
    Armenian, no-pad, binary
ascii
US ASCII
  • ascii_bin
    West European, binary
  • ascii_general_ci
    West European, case-insensitive
    default
  • ascii_general_nopad_ci
    West European, no-pad, case-insensitive
  • ascii_nopad_bin
    West European, no-pad, binary
big5
Big5 Traditional Chinese
  • big5_bin
    Traditional Chinese, binary
  • big5_chinese_ci
    Traditional Chinese, case-insensitive
    default
  • big5_chinese_nopad_ci
    Traditional Chinese, no-pad, case-insensitive
  • big5_nopad_bin
    Traditional Chinese, no-pad, binary
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_general_nopad_ci
    Central European, no-pad, case-insensitive
  • cp1250_nopad_bin
    Central European, no-pad, binary
  • 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_general_nopad_ci
    Cyrillic, no-pad, case-insensitive
  • cp1251_nopad_bin
    Cyrillic, no-pad, binary
  • cp1251_ukrainian_ci
    Ukrainian, case-insensitive
cp1256
Windows Arabic
  • cp1256_bin
    Arabic, binary
  • cp1256_general_ci
    Arabic, case-insensitive
    default
  • cp1256_general_nopad_ci
    Arabic, no-pad, case-insensitive
  • cp1256_nopad_bin
    Arabic, no-pad, binary
cp1257
Windows Baltic
  • cp1257_bin
    Baltic, binary
  • cp1257_general_ci
    Baltic, case-insensitive
    default
  • cp1257_general_nopad_ci
    Baltic, no-pad, case-insensitive
  • cp1257_lithuanian_ci
    Lithuanian, case-insensitive
  • cp1257_nopad_bin
    Baltic, no-pad, binary
cp850
DOS West European
  • cp850_bin
    West European, binary
  • cp850_general_ci
    West European, case-insensitive
    default
  • cp850_general_nopad_ci
    West European, no-pad, case-insensitive
  • cp850_nopad_bin
    West European, no-pad, binary
cp852
DOS Central European
  • cp852_bin
    Central European, binary
  • cp852_general_ci
    Central European, case-insensitive
    default
  • cp852_general_nopad_ci
    Central European, no-pad, case-insensitive
  • cp852_nopad_bin
    Central European, no-pad, binary
cp866
DOS Russian
  • cp866_bin
    Russian, binary
  • cp866_general_ci
    Russian, case-insensitive
    default
  • cp866_general_nopad_ci
    Russian, no-pad, case-insensitive
  • cp866_nopad_bin
    Russian, no-pad, binary
cp932
SJIS for Windows Japanese
  • cp932_bin
    Japanese, binary
  • cp932_japanese_ci
    Japanese, case-insensitive
    default
  • cp932_japanese_nopad_ci
    Japanese, no-pad, case-insensitive
  • cp932_nopad_bin
    Japanese, no-pad, binary
dec8
DEC West European
  • dec8_bin
    West European, binary
  • dec8_nopad_bin
    West European, no-pad, binary
  • dec8_swedish_ci
    Swedish, case-insensitive
    default
  • dec8_swedish_nopad_ci
    Swedish, no-pad, case-insensitive
eucjpms
UJIS for Windows Japanese
  • eucjpms_bin
    Japanese, binary
  • eucjpms_japanese_ci
    Japanese, case-insensitive
    default
  • eucjpms_japanese_nopad_ci
    Japanese, no-pad, case-insensitive
  • eucjpms_nopad_bin
    Japanese, no-pad, binary
euckr
EUC-KR Korean
  • euckr_bin
    Korean, binary
  • euckr_korean_ci
    Korean, case-insensitive
    default
  • euckr_korean_nopad_ci
    Korean, no-pad, case-insensitive
  • euckr_nopad_bin
    Korean, no-pad, binary
gb2312
GB2312 Simplified Chinese
  • gb2312_bin
    Simplified Chinese, binary
  • gb2312_chinese_ci
    Simplified Chinese, case-insensitive
    default
  • gb2312_chinese_nopad_ci
    Simplified Chinese, no-pad, case-insensitive
  • gb2312_nopad_bin
    Simplified Chinese, no-pad, binary
gbk
GBK Simplified Chinese
  • gbk_bin
    Simplified Chinese, binary
  • gbk_chinese_ci
    Simplified Chinese, case-insensitive
    default
  • gbk_chinese_nopad_ci
    Simplified Chinese, no-pad, case-insensitive
  • gbk_nopad_bin
    Simplified Chinese, no-pad, binary
geostd8
GEOSTD8 Georgian
  • geostd8_bin
    Georgian, binary
  • geostd8_general_ci
    Georgian, case-insensitive
    default
  • geostd8_general_nopad_ci
    Georgian, no-pad, case-insensitive
  • geostd8_nopad_bin
    Georgian, no-pad, binary
greek
ISO 8859-7 Greek
  • greek_bin
    Greek, binary
  • greek_general_ci
    Greek, case-insensitive
    default
  • greek_general_nopad_ci
    Greek, no-pad, case-insensitive
  • greek_nopad_bin
    Greek, no-pad, binary
hebrew
ISO 8859-8 Hebrew
  • hebrew_bin
    Hebrew, binary
  • hebrew_general_ci
    Hebrew, case-insensitive
    default
  • hebrew_general_nopad_ci
    Hebrew, no-pad, case-insensitive
  • hebrew_nopad_bin
    Hebrew, no-pad, binary
hp8
HP West European
  • hp8_bin
    West European, binary
  • hp8_english_ci
    English, case-insensitive
    default
  • hp8_english_nopad_ci
    English, no-pad, case-insensitive
  • hp8_nopad_bin
    West European, no-pad, binary
keybcs2
DOS Kamenicky Czech-Slovak
  • keybcs2_bin
    Czech-Slovak, binary
  • keybcs2_general_ci
    Czech-Slovak, case-insensitive
    default
  • keybcs2_general_nopad_ci
    Czech-Slovak, no-pad, case-insensitive
  • keybcs2_nopad_bin
    Czech-Slovak, no-pad, binary
koi8r
KOI8-R Relcom Russian
  • koi8r_bin
    Russian, binary
  • koi8r_general_ci
    Russian, case-insensitive
    default
  • koi8r_general_nopad_ci
    Russian, no-pad, case-insensitive
  • koi8r_nopad_bin
    Russian, no-pad, binary
koi8u
KOI8-U Ukrainian
  • koi8u_bin
    Ukrainian, binary
  • koi8u_general_ci
    Ukrainian, case-insensitive
    default
  • koi8u_general_nopad_ci
    Ukrainian, no-pad, case-insensitive
  • koi8u_nopad_bin
    Ukrainian, no-pad, binary
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_nopad_bin
    West European, no-pad, binary
  • latin1_spanish_ci
    Spanish (modern), case-insensitive
  • latin1_swedish_ci
    Swedish, case-insensitive
    default
  • latin1_swedish_nopad_ci
    Swedish, no-pad, case-insensitive
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_general_nopad_ci
    Central European, no-pad, case-insensitive
  • latin2_hungarian_ci
    Hungarian, case-insensitive
  • latin2_nopad_bin
    Central European, no-pad, binary
latin5
ISO 8859-9 Turkish
  • latin5_bin
    Turkish, binary
  • latin5_nopad_bin
    Turkish, no-pad, binary
  • latin5_turkish_ci
    Turkish, case-insensitive
    default
  • latin5_turkish_nopad_ci
    Turkish, no-pad, case-insensitive
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
  • latin7_general_nopad_ci
    Baltic, no-pad, case-insensitive
  • latin7_nopad_bin
    Baltic, no-pad, binary
macce
Mac Central European
  • macce_bin
    Central European, binary
  • macce_general_ci
    Central European, case-insensitive
    default
  • macce_general_nopad_ci
    Central European, no-pad, case-insensitive
  • macce_nopad_bin
    Central European, no-pad, binary
macroman
Mac West European
  • macroman_bin
    West European, binary
  • macroman_general_ci
    West European, case-insensitive
    default
  • macroman_general_nopad_ci
    West European, no-pad, case-insensitive
  • macroman_nopad_bin
    West European, no-pad, binary
sjis
Shift-JIS Japanese
  • sjis_bin
    Japanese, binary
  • sjis_japanese_ci
    Japanese, case-insensitive
    default
  • sjis_japanese_nopad_ci
    Japanese, no-pad, case-insensitive
  • sjis_nopad_bin
    Japanese, no-pad, binary
swe7
7bit Swedish
  • swe7_bin
    Swedish, binary
  • swe7_nopad_bin
    Swedish, no-pad, binary
  • swe7_swedish_ci
    Swedish, case-insensitive
    default
  • swe7_swedish_nopad_ci
    Swedish, no-pad, case-insensitive
tis620
TIS620 Thai
  • tis620_bin
    Thai, binary
  • tis620_nopad_bin
    Thai, no-pad, binary
  • tis620_thai_ci
    Thai, case-insensitive
    default
  • tis620_thai_nopad_ci
    Thai, no-pad, case-insensitive
ucs2
UCS-2 Unicode
  • ucs2_bin
    Unicode, binary
  • ucs2_croatian_ci
    Croatian, case-insensitive
  • ucs2_croatian_mysql561_ci
    Croatian (MySQL 5.6.1), 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_general_nopad_ci
    Unicode, no-pad, 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_myanmar_ci
    Burmese, case-insensitive
  • ucs2_nopad_bin
    Unicode, no-pad, binary
  • 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_thai_520_w2
    Thai (UCA 5.2.0), multi-level
  • ucs2_turkish_ci
    Turkish, case-insensitive
  • ucs2_unicode_520_ci
    Unicode (UCA 5.2.0), case-insensitive
  • ucs2_unicode_520_nopad_ci
    Unicode (UCA 5.2.0), no-pad, case-insensitive
  • ucs2_unicode_ci
    Unicode, case-insensitive
  • ucs2_unicode_nopad_ci
    Unicode, no-pad, case-insensitive
  • ucs2_vietnamese_ci
    Vietnamese, case-insensitive
ujis
EUC-JP Japanese
  • ujis_bin
    Japanese, binary
  • ujis_japanese_ci
    Japanese, case-insensitive
    default
  • ujis_japanese_nopad_ci
    Japanese, no-pad, case-insensitive
  • ujis_nopad_bin
    Japanese, no-pad, binary
utf16
UTF-16 Unicode
  • utf16_bin
    Unicode, binary
  • utf16_croatian_ci
    Croatian, case-insensitive
  • utf16_croatian_mysql561_ci
    Croatian (MySQL 5.6.1), 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_general_nopad_ci
    Unicode, no-pad, case-insensitive
  • 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_myanmar_ci
    Burmese, case-insensitive
  • utf16_nopad_bin
    Unicode, no-pad, binary
  • 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_thai_520_w2
    Thai (UCA 5.2.0), multi-level
  • utf16_turkish_ci
    Turkish, case-insensitive
  • utf16_unicode_520_ci
    Unicode (UCA 5.2.0), case-insensitive
  • utf16_unicode_520_nopad_ci
    Unicode (UCA 5.2.0), no-pad, case-insensitive
  • utf16_unicode_ci
    Unicode, case-insensitive
  • utf16_unicode_nopad_ci
    Unicode, no-pad, case-insensitive
  • utf16_vietnamese_ci
    Vietnamese, case-insensitive
utf16le
UTF-16LE Unicode
  • utf16le_bin
    Unicode, binary
  • utf16le_general_ci
    Unicode, case-insensitive
    default
  • utf16le_general_nopad_ci
    Unicode, no-pad, case-insensitive
  • utf16le_nopad_bin
    Unicode, no-pad, binary
utf32
UTF-32 Unicode
  • utf32_bin
    Unicode, binary
  • utf32_croatian_ci
    Croatian, case-insensitive
  • utf32_croatian_mysql561_ci
    Croatian (MySQL 5.6.1), 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_general_nopad_ci
    Unicode, no-pad, case-insensitive
  • 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_myanmar_ci
    Burmese, case-insensitive
  • utf32_nopad_bin
    Unicode, no-pad, binary
  • 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_thai_520_w2
    Thai (UCA 5.2.0), multi-level
  • utf32_turkish_ci
    Turkish, case-insensitive
  • utf32_unicode_520_ci
    Unicode (UCA 5.2.0), case-insensitive
  • utf32_unicode_520_nopad_ci
    Unicode (UCA 5.2.0), no-pad, case-insensitive
  • utf32_unicode_ci
    Unicode, case-insensitive
  • utf32_unicode_nopad_ci
    Unicode, no-pad, case-insensitive
  • utf32_vietnamese_ci
    Vietnamese, case-insensitive
utf8
UTF-8 Unicode
  • utf8_bin
    Unicode, binary
  • utf8_croatian_ci
    Croatian, case-insensitive
  • utf8_croatian_mysql561_ci
    Croatian (MySQL 5.6.1), 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_general_nopad_ci
    Unicode, no-pad, 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_myanmar_ci
    Burmese, case-insensitive
  • utf8_nopad_bin
    Unicode, no-pad, binary
  • 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_thai_520_w2
    Thai (UCA 5.2.0), multi-level
  • utf8_turkish_ci
    Turkish, case-insensitive
  • utf8_unicode_520_ci
    Unicode (UCA 5.2.0), case-insensitive
  • utf8_unicode_520_nopad_ci
    Unicode (UCA 5.2.0), no-pad, case-insensitive
  • utf8_unicode_ci
    Unicode, case-insensitive
  • utf8_unicode_nopad_ci
    Unicode, no-pad, case-insensitive
  • utf8_vietnamese_ci
    Vietnamese, case-insensitive
utf8mb4
UTF-8 Unicode
  • utf8mb4_bin
    Unicode (UCA 4.0.0), binary
  • utf8mb4_croatian_ci
    Croatian (UCA 4.0.0), case-insensitive
  • utf8mb4_croatian_mysql561_ci
    Croatian (MySQL 5.6.1), case-insensitive
  • utf8mb4_czech_ci
    Czech (UCA 4.0.0), case-insensitive
  • utf8mb4_danish_ci
    Danish (UCA 4.0.0), case-insensitive
  • utf8mb4_esperanto_ci
    Esperanto (UCA 4.0.0), case-insensitive
  • utf8mb4_estonian_ci
    Estonian (UCA 4.0.0), case-insensitive
  • utf8mb4_general_ci
    Unicode (UCA 4.0.0), case-insensitive
    default
  • utf8mb4_general_nopad_ci
    Unicode (UCA 4.0.0), no-pad, case-insensitive
  • utf8mb4_german2_ci
    German (phone book order) (UCA 4.0.0), case-insensitive
  • utf8mb4_hungarian_ci
    Hungarian (UCA 4.0.0), case-insensitive
  • utf8mb4_icelandic_ci
    Icelandic (UCA 4.0.0), case-insensitive
  • utf8mb4_latvian_ci
    Latvian (UCA 4.0.0), case-insensitive
  • utf8mb4_lithuanian_ci
    Lithuanian (UCA 4.0.0), case-insensitive
  • utf8mb4_myanmar_ci
    Burmese (UCA 4.0.0), case-insensitive
  • utf8mb4_nopad_bin
    Unicode (UCA 4.0.0), no-pad, binary
  • utf8mb4_persian_ci
    Persian (UCA 4.0.0), case-insensitive
  • utf8mb4_polish_ci
    Polish (UCA 4.0.0), case-insensitive
  • utf8mb4_roman_ci
    West European (UCA 4.0.0), case-insensitive
  • utf8mb4_romanian_ci
    Romanian (UCA 4.0.0), case-insensitive
  • utf8mb4_sinhala_ci
    Sinhalese (UCA 4.0.0), case-insensitive
  • 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_swedish_ci
    Swedish (UCA 4.0.0), case-insensitive
  • utf8mb4_thai_520_w2
    Thai (UCA 5.2.0), multi-level
  • utf8mb4_turkish_ci
    Turkish (UCA 4.0.0), case-insensitive
  • utf8mb4_unicode_520_ci
    Unicode (UCA 5.2.0), case-insensitive
  • utf8mb4_unicode_520_nopad_ci
    Unicode (UCA 5.2.0), no-pad, case-insensitive
  • utf8mb4_unicode_ci
    Unicode (UCA 4.0.0), case-insensitive
  • utf8mb4_unicode_nopad_ci
    Unicode (UCA 4.0.0), no-pad, case-insensitive
  • utf8mb4_vietnamese_ci
    Vietnamese (UCA 4.0.0), case-insensitive