charset_collation_1.result
来自「这个文件是windows mysql源码」· RESULT 代码 · 共 310 行
RESULT
310 行
DROP USER dbdict_test@localhost;CREATE USER dbdict_test@localhost;# Establish connection con (user=dbdict_test)SELECT *FROM information_schema.character_setsORDER BY character_set_name;CHARACTER_SET_NAME DEFAULT_COLLATE_NAME DESCRIPTION MAXLENarmscii8 armscii8_general_ci ARMSCII-8 Armenian 1ascii ascii_general_ci US ASCII 1big5 big5_chinese_ci Big5 Traditional Chinese 2binary binary Binary pseudo charset 1cp1250 cp1250_general_ci Windows Central European 1cp1251 cp1251_general_ci Windows Cyrillic 1cp1256 cp1256_general_ci Windows Arabic 1cp1257 cp1257_general_ci Windows Baltic 1cp850 cp850_general_ci DOS West European 1cp852 cp852_general_ci DOS Central European 1cp866 cp866_general_ci DOS Russian 1cp932 cp932_japanese_ci SJIS for Windows Japanese 2dec8 dec8_swedish_ci DEC West European 1eucjpms eucjpms_japanese_ci UJIS for Windows Japanese 3euckr euckr_korean_ci EUC-KR Korean 2gb2312 gb2312_chinese_ci GB2312 Simplified Chinese 2gbk gbk_chinese_ci GBK Simplified Chinese 2geostd8 geostd8_general_ci GEOSTD8 Georgian 1greek greek_general_ci ISO 8859-7 Greek 1hebrew hebrew_general_ci ISO 8859-8 Hebrew 1hp8 hp8_english_ci HP West European 1keybcs2 keybcs2_general_ci DOS Kamenicky Czech-Slovak 1koi8r koi8r_general_ci KOI8-R Relcom Russian 1koi8u koi8u_general_ci KOI8-U Ukrainian 1latin1 latin1_swedish_ci cp1252 West European 1latin2 latin2_general_ci ISO 8859-2 Central European 1latin5 latin5_turkish_ci ISO 8859-9 Turkish 1latin7 latin7_general_ci ISO 8859-13 Baltic 1macce macce_general_ci Mac Central European 1macroman macroman_general_ci Mac West European 1sjis sjis_japanese_ci Shift-JIS Japanese 2swe7 swe7_swedish_ci 7bit Swedish 1tis620 tis620_thai_ci TIS620 Thai 1ucs2 ucs2_general_ci UCS-2 Unicode 2ujis ujis_japanese_ci EUC-JP Japanese 3utf8 utf8_general_ci UTF-8 Unicode 3SELECT *FROM information_schema.collationsORDER BY collation_name;COLLATION_NAME CHARACTER_SET_NAME ID IS_DEFAULT IS_COMPILED SORTLENarmscii8_bin armscii8 64 0armscii8_general_ci armscii8 32 Yes 0ascii_bin ascii 65 0ascii_general_ci ascii 11 Yes 0big5_bin big5 84 Yes 1big5_chinese_ci big5 1 Yes Yes 1binary binary 63 Yes Yes 1cp1250_bin cp1250 66 Yes 1cp1250_croatian_ci cp1250 44 Yes 1cp1250_czech_cs cp1250 34 Yes 2cp1250_general_ci cp1250 26 Yes Yes 1cp1251_bin cp1251 50 0cp1251_bulgarian_ci cp1251 14 0cp1251_general_ci cp1251 51 Yes 0cp1251_general_cs cp1251 52 0cp1251_ukrainian_ci cp1251 23 0cp1256_bin cp1256 67 0cp1256_general_ci cp1256 57 Yes 0cp1257_bin cp1257 58 0cp1257_general_ci cp1257 59 Yes 0cp1257_lithuanian_ci cp1257 29 0cp850_bin cp850 80 0cp850_general_ci cp850 4 Yes 0cp852_bin cp852 81 0cp852_general_ci cp852 40 Yes 0cp866_bin cp866 68 0cp866_general_ci cp866 36 Yes 0cp932_bin cp932 96 Yes 1cp932_japanese_ci cp932 95 Yes Yes 1dec8_bin dec8 69 0dec8_swedish_ci dec8 3 Yes 0eucjpms_bin eucjpms 98 Yes 1eucjpms_japanese_ci eucjpms 97 Yes Yes 1euckr_bin euckr 85 Yes 1euckr_korean_ci euckr 19 Yes Yes 1gb2312_bin gb2312 86 Yes 1gb2312_chinese_ci gb2312 24 Yes Yes 1gbk_bin gbk 87 Yes 1gbk_chinese_ci gbk 28 Yes Yes 1geostd8_bin geostd8 93 0geostd8_general_ci geostd8 92 Yes 0greek_bin greek 70 0greek_general_ci greek 25 Yes 0hebrew_bin hebrew 71 0hebrew_general_ci hebrew 16 Yes 0hp8_bin hp8 72 0hp8_english_ci hp8 6 Yes 0keybcs2_bin keybcs2 73 0keybcs2_general_ci keybcs2 37 Yes 0koi8r_bin koi8r 74 0koi8r_general_ci koi8r 7 Yes 0koi8u_bin koi8u 75 0koi8u_general_ci koi8u 22 Yes 0latin1_bin latin1 47 Yes 1latin1_danish_ci latin1 15 Yes 1latin1_general_ci latin1 48 Yes 1latin1_general_cs latin1 49 Yes 1latin1_german1_ci latin1 5 Yes 1latin1_german2_ci latin1 31 Yes 2latin1_spanish_ci latin1 94 Yes 1latin1_swedish_ci latin1 8 Yes Yes 1latin2_bin latin2 77 Yes 1latin2_croatian_ci latin2 27 Yes 1latin2_czech_cs latin2 2 Yes 4latin2_general_ci latin2 9 Yes Yes 1latin2_hungarian_ci latin2 21 Yes 1latin5_bin latin5 78 0latin5_turkish_ci latin5 30 Yes 0latin7_bin latin7 79 0latin7_estonian_cs latin7 20 0latin7_general_ci latin7 41 Yes 0latin7_general_cs latin7 42 0macce_bin macce 43 0macce_general_ci macce 38 Yes 0macroman_bin macroman 53 0macroman_general_ci macroman 39 Yes 0sjis_bin sjis 88 Yes 1sjis_japanese_ci sjis 13 Yes Yes 1swe7_bin swe7 82 0swe7_swedish_ci swe7 10 Yes 0tis620_bin tis620 89 Yes 1tis620_thai_ci tis620 18 Yes Yes 4ucs2_bin ucs2 90 Yes 1ucs2_czech_ci ucs2 138 Yes 8ucs2_danish_ci ucs2 139 Yes 8ucs2_esperanto_ci ucs2 145 Yes 8ucs2_estonian_ci ucs2 134 Yes 8ucs2_general_ci ucs2 35 Yes Yes 1ucs2_hungarian_ci ucs2 146 Yes 8ucs2_icelandic_ci ucs2 129 Yes 8ucs2_latvian_ci ucs2 130 Yes 8ucs2_lithuanian_ci ucs2 140 Yes 8ucs2_persian_ci ucs2 144 Yes 8ucs2_polish_ci ucs2 133 Yes 8ucs2_romanian_ci ucs2 131 Yes 8ucs2_roman_ci ucs2 143 Yes 8ucs2_slovak_ci ucs2 141 Yes 8ucs2_slovenian_ci ucs2 132 Yes 8ucs2_spanish2_ci ucs2 142 Yes 8ucs2_spanish_ci ucs2 135 Yes 8ucs2_swedish_ci ucs2 136 Yes 8ucs2_turkish_ci ucs2 137 Yes 8ucs2_unicode_ci ucs2 128 Yes 8ujis_bin ujis 91 Yes 1ujis_japanese_ci ujis 12 Yes Yes 1utf8_bin utf8 83 Yes 1utf8_czech_ci utf8 202 Yes 8utf8_danish_ci utf8 203 Yes 8utf8_esperanto_ci utf8 209 Yes 8utf8_estonian_ci utf8 198 Yes 8utf8_general_ci utf8 33 Yes Yes 1utf8_hungarian_ci utf8 210 Yes 8utf8_icelandic_ci utf8 193 Yes 8utf8_latvian_ci utf8 194 Yes 8utf8_lithuanian_ci utf8 204 Yes 8utf8_persian_ci utf8 208 Yes 8utf8_polish_ci utf8 197 Yes 8utf8_romanian_ci utf8 195 Yes 8utf8_roman_ci utf8 207 Yes 8utf8_slovak_ci utf8 205 Yes 8utf8_slovenian_ci utf8 196 Yes 8utf8_spanish2_ci utf8 206 Yes 8utf8_spanish_ci utf8 199 Yes 8utf8_swedish_ci utf8 200 Yes 8utf8_turkish_ci utf8 201 Yes 8utf8_unicode_ci utf8 192 Yes 8SELECT *FROM information_schema.collation_character_set_applicabilityORDER BY collation_name, character_set_name;COLLATION_NAME CHARACTER_SET_NAMEarmscii8_bin armscii8armscii8_general_ci armscii8ascii_bin asciiascii_general_ci asciibig5_bin big5big5_chinese_ci big5binary binarycp1250_bin cp1250cp1250_croatian_ci cp1250cp1250_czech_cs cp1250cp1250_general_ci cp1250cp1251_bin cp1251cp1251_bulgarian_ci cp1251cp1251_general_ci cp1251cp1251_general_cs cp1251cp1251_ukrainian_ci cp1251cp1256_bin cp1256cp1256_general_ci cp1256cp1257_bin cp1257cp1257_general_ci cp1257cp1257_lithuanian_ci cp1257cp850_bin cp850cp850_general_ci cp850cp852_bin cp852cp852_general_ci cp852cp866_bin cp866cp866_general_ci cp866cp932_bin cp932cp932_japanese_ci cp932dec8_bin dec8dec8_swedish_ci dec8eucjpms_bin eucjpmseucjpms_japanese_ci eucjpmseuckr_bin euckreuckr_korean_ci euckrgb2312_bin gb2312gb2312_chinese_ci gb2312gbk_bin gbkgbk_chinese_ci gbkgeostd8_bin geostd8geostd8_general_ci geostd8greek_bin greekgreek_general_ci greekhebrew_bin hebrewhebrew_general_ci hebrewhp8_bin hp8hp8_english_ci hp8keybcs2_bin keybcs2keybcs2_general_ci keybcs2koi8r_bin koi8rkoi8r_general_ci koi8rkoi8u_bin koi8ukoi8u_general_ci koi8ulatin1_bin latin1latin1_danish_ci latin1latin1_general_ci latin1latin1_general_cs latin1latin1_german1_ci latin1latin1_german2_ci latin1latin1_spanish_ci latin1latin1_swedish_ci latin1latin2_bin latin2latin2_croatian_ci latin2latin2_czech_cs latin2latin2_general_ci latin2latin2_hungarian_ci latin2latin5_bin latin5latin5_turkish_ci latin5latin7_bin latin7latin7_estonian_cs latin7latin7_general_ci latin7latin7_general_cs latin7macce_bin maccemacce_general_ci maccemacroman_bin macromanmacroman_general_ci macromansjis_bin sjissjis_japanese_ci sjisswe7_bin swe7swe7_swedish_ci swe7tis620_bin tis620tis620_thai_ci tis620ucs2_bin ucs2ucs2_czech_ci ucs2ucs2_danish_ci ucs2ucs2_esperanto_ci ucs2ucs2_estonian_ci ucs2ucs2_general_ci ucs2ucs2_hungarian_ci ucs2ucs2_icelandic_ci ucs2ucs2_latvian_ci ucs2ucs2_lithuanian_ci ucs2ucs2_persian_ci ucs2ucs2_polish_ci ucs2ucs2_romanian_ci ucs2ucs2_roman_ci ucs2ucs2_slovak_ci ucs2ucs2_slovenian_ci ucs2ucs2_spanish2_ci ucs2ucs2_spanish_ci ucs2ucs2_swedish_ci ucs2ucs2_turkish_ci ucs2ucs2_unicode_ci ucs2ujis_bin ujisujis_japanese_ci ujisutf8_bin utf8utf8_czech_ci utf8utf8_danish_ci utf8utf8_esperanto_ci utf8utf8_estonian_ci utf8utf8_general_ci utf8utf8_hungarian_ci utf8utf8_icelandic_ci utf8utf8_latvian_ci utf8utf8_lithuanian_ci utf8utf8_persian_ci utf8utf8_polish_ci utf8utf8_romanian_ci utf8utf8_roman_ci utf8utf8_slovak_ci utf8utf8_slovenian_ci utf8utf8_spanish2_ci utf8utf8_spanish_ci utf8utf8_swedish_ci utf8utf8_turkish_ci utf8utf8_unicode_ci utf8# Switch to connection default + disconnect conDROP USER dbdict_test@localhost;⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?