Edit File: db_alter_collate_ascii.result
DROP DATABASE IF EXISTS d9; SHOW COLLATION; Collation Charset Id Default Compiled Sortlen big5_chinese_ci big5 1 Yes # # big5_bin big5 84 # # dec8_swedish_ci dec8 3 Yes # # dec8_bin dec8 69 # # cp850_general_ci cp850 4 Yes # # cp850_bin cp850 80 # # hp8_english_ci hp8 6 Yes # # hp8_bin hp8 72 # # koi8r_general_ci koi8r 7 Yes # # koi8r_bin koi8r 74 # # latin1_german1_ci latin1 5 # # latin1_swedish_ci latin1 8 Yes # # latin1_danish_ci latin1 15 # # latin1_german2_ci latin1 31 # # latin1_bin latin1 47 # # latin1_general_ci latin1 48 # # latin1_general_cs latin1 49 # # latin1_spanish_ci latin1 94 # # latin2_czech_cs latin2 2 # # latin2_general_ci latin2 9 Yes # # latin2_hungarian_ci latin2 21 # # latin2_croatian_ci latin2 27 # # latin2_bin latin2 77 # # swe7_swedish_ci swe7 10 Yes # # swe7_bin swe7 82 # # ascii_general_ci ascii 11 Yes # # ascii_bin ascii 65 # # ujis_japanese_ci ujis 12 Yes # # ujis_bin ujis 91 # # sjis_japanese_ci sjis 13 Yes # # sjis_bin sjis 88 # # hebrew_general_ci hebrew 16 Yes # # hebrew_bin hebrew 71 # # tis620_thai_ci tis620 18 Yes # # tis620_bin tis620 89 # # euckr_korean_ci euckr 19 Yes # # euckr_bin euckr 85 # # koi8u_general_ci koi8u 22 Yes # # koi8u_bin koi8u 75 # # gb2312_chinese_ci gb2312 24 Yes # # gb2312_bin gb2312 86 # # greek_general_ci greek 25 Yes # # greek_bin greek 70 # # cp1250_general_ci cp1250 26 Yes # # cp1250_czech_cs cp1250 34 # # cp1250_croatian_ci cp1250 44 # # cp1250_bin cp1250 66 # # cp1250_polish_ci cp1250 99 # # gbk_chinese_ci gbk 28 Yes # # gbk_bin gbk 87 # # latin5_turkish_ci latin5 30 Yes # # latin5_bin latin5 78 # # armscii8_general_ci armscii8 32 Yes # # armscii8_bin armscii8 64 # # utf8_general_ci utf8 33 Yes # # utf8_bin utf8 83 # # utf8_unicode_ci utf8 192 # # utf8_icelandic_ci utf8 193 # # utf8_latvian_ci utf8 194 # # utf8_romanian_ci utf8 195 # # utf8_slovenian_ci utf8 196 # # utf8_polish_ci utf8 197 # # utf8_estonian_ci utf8 198 # # utf8_spanish_ci utf8 199 # # utf8_swedish_ci utf8 200 # # utf8_turkish_ci utf8 201 # # utf8_czech_ci utf8 202 # # utf8_danish_ci utf8 203 # # utf8_lithuanian_ci utf8 204 # # utf8_slovak_ci utf8 205 # # utf8_spanish2_ci utf8 206 # # utf8_roman_ci utf8 207 # # utf8_persian_ci utf8 208 # # utf8_esperanto_ci utf8 209 # # utf8_hungarian_ci utf8 210 # # utf8_sinhala_ci utf8 211 # # utf8_general_mysql500_ci utf8 223 # # ucs2_general_ci ucs2 35 Yes # # ucs2_bin ucs2 90 # # ucs2_unicode_ci ucs2 128 # # ucs2_icelandic_ci ucs2 129 # # ucs2_latvian_ci ucs2 130 # # ucs2_romanian_ci ucs2 131 # # ucs2_slovenian_ci ucs2 132 # # ucs2_polish_ci ucs2 133 # # ucs2_estonian_ci ucs2 134 # # ucs2_spanish_ci ucs2 135 # # ucs2_swedish_ci ucs2 136 # # ucs2_turkish_ci ucs2 137 # # ucs2_czech_ci ucs2 138 # # ucs2_danish_ci ucs2 139 # # ucs2_lithuanian_ci ucs2 140 # # ucs2_slovak_ci ucs2 141 # # ucs2_spanish2_ci ucs2 142 # # ucs2_roman_ci ucs2 143 # # ucs2_persian_ci ucs2 144 # # ucs2_esperanto_ci ucs2 145 # # ucs2_hungarian_ci ucs2 146 # # ucs2_sinhala_ci ucs2 147 # # ucs2_general_mysql500_ci ucs2 159 # # cp866_general_ci cp866 36 Yes # # cp866_bin cp866 68 # # keybcs2_general_ci keybcs2 37 Yes # # keybcs2_bin keybcs2 73 # # macce_general_ci macce 38 Yes # # macce_bin macce 43 # # macroman_general_ci macroman 39 Yes # # macroman_bin macroman 53 # # cp852_general_ci cp852 40 Yes # # cp852_bin cp852 81 # # latin7_estonian_cs latin7 20 # # latin7_general_ci latin7 41 Yes # # latin7_general_cs latin7 42 # # latin7_bin latin7 79 # # utf8mb4_general_ci utf8mb4 45 Yes # # utf8mb4_bin utf8mb4 46 # # utf8mb4_unicode_ci utf8mb4 224 # # utf8mb4_icelandic_ci utf8mb4 225 # # utf8mb4_latvian_ci utf8mb4 226 # # utf8mb4_romanian_ci utf8mb4 227 # # utf8mb4_slovenian_ci utf8mb4 228 # # utf8mb4_polish_ci utf8mb4 229 # # utf8mb4_estonian_ci utf8mb4 230 # # utf8mb4_spanish_ci utf8mb4 231 # # utf8mb4_swedish_ci utf8mb4 232 # # utf8mb4_turkish_ci utf8mb4 233 # # utf8mb4_czech_ci utf8mb4 234 # # utf8mb4_danish_ci utf8mb4 235 # # utf8mb4_lithuanian_ci utf8mb4 236 # # utf8mb4_slovak_ci utf8mb4 237 # # utf8mb4_spanish2_ci utf8mb4 238 # # utf8mb4_roman_ci utf8mb4 239 # # utf8mb4_persian_ci utf8mb4 240 # # utf8mb4_esperanto_ci utf8mb4 241 # # utf8mb4_hungarian_ci utf8mb4 242 # # utf8mb4_sinhala_ci utf8mb4 243 # # cp1251_bulgarian_ci cp1251 14 # # cp1251_ukrainian_ci cp1251 23 # # cp1251_bin cp1251 50 # # cp1251_general_ci cp1251 51 Yes # # cp1251_general_cs cp1251 52 # # utf16_general_ci utf16 54 Yes # # utf16_bin utf16 55 # # utf16_unicode_ci utf16 101 # # utf16_icelandic_ci utf16 102 # # utf16_latvian_ci utf16 103 # # utf16_romanian_ci utf16 104 # # utf16_slovenian_ci utf16 105 # # utf16_polish_ci utf16 106 # # utf16_estonian_ci utf16 107 # # utf16_spanish_ci utf16 108 # # utf16_swedish_ci utf16 109 # # utf16_turkish_ci utf16 110 # # utf16_czech_ci utf16 111 # # utf16_danish_ci utf16 112 # # utf16_lithuanian_ci utf16 113 # # utf16_slovak_ci utf16 114 # # utf16_spanish2_ci utf16 115 # # utf16_roman_ci utf16 116 # # utf16_persian_ci utf16 117 # # utf16_esperanto_ci utf16 118 # # utf16_hungarian_ci utf16 119 # # utf16_sinhala_ci utf16 120 # # cp1256_general_ci cp1256 57 Yes # # cp1256_bin cp1256 67 # # cp1257_lithuanian_ci cp1257 29 # # cp1257_bin cp1257 58 # # cp1257_general_ci cp1257 59 Yes # # utf32_general_ci utf32 60 Yes # # utf32_bin utf32 61 # # utf32_unicode_ci utf32 160 # # utf32_icelandic_ci utf32 161 # # utf32_latvian_ci utf32 162 # # utf32_romanian_ci utf32 163 # # utf32_slovenian_ci utf32 164 # # utf32_polish_ci utf32 165 # # utf32_estonian_ci utf32 166 # # utf32_spanish_ci utf32 167 # # utf32_swedish_ci utf32 168 # # utf32_turkish_ci utf32 169 # # utf32_czech_ci utf32 170 # # utf32_danish_ci utf32 171 # # utf32_lithuanian_ci utf32 172 # # utf32_slovak_ci utf32 173 # # utf32_spanish2_ci utf32 174 # # utf32_roman_ci utf32 175 # # utf32_persian_ci utf32 176 # # utf32_esperanto_ci utf32 177 # # utf32_hungarian_ci utf32 178 # # utf32_sinhala_ci utf32 179 # # binary binary 63 Yes # # geostd8_general_ci geostd8 92 Yes # # geostd8_bin geostd8 93 # # cp932_japanese_ci cp932 95 Yes # # cp932_bin cp932 96 # # eucjpms_japanese_ci eucjpms 97 Yes # # eucjpms_bin eucjpms 98 # # CREATE DATABASE d9 DEFAULT CHARACTER SET ascii; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH def d9 ascii ascii_general_ci NULL def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d9 COLLATE ascii_bin; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH def d9 ascii ascii_bin NULL def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d9; CREATE DATABASE d9 DEFAULT CHARACTER SET ascii; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH def d9 ascii ascii_general_ci NULL def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d9 DEFAULT COLLATE ascii_bin; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH def d9 ascii ascii_bin NULL def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d9; CREATE DATABASE d9 DEFAULT CHARACTER SET ascii; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH def d9 ascii ascii_general_ci NULL def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d9 COLLATE ascii_general_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH def d9 ascii ascii_general_ci NULL def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d9; CREATE DATABASE d9 DEFAULT CHARACTER SET ascii; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH def d9 ascii ascii_general_ci NULL def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER DATABASE d9 DEFAULT COLLATE ascii_general_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH def d9 ascii ascii_general_ci NULL def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d9; CREATE DATABASE d9 DEFAULT CHARACTER SET ascii; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH def d9 ascii ascii_general_ci NULL def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d9 COLLATE ascii_bin; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH def d9 ascii ascii_bin NULL def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d9; CREATE DATABASE d9 DEFAULT CHARACTER SET ascii; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH def d9 ascii ascii_general_ci NULL def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d9 DEFAULT COLLATE ascii_bin; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH def d9 ascii ascii_bin NULL def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d9; CREATE DATABASE d9 DEFAULT CHARACTER SET ascii; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH def d9 ascii ascii_general_ci NULL def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d9 COLLATE ascii_general_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH def d9 ascii ascii_general_ci NULL def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d9; CREATE DATABASE d9 DEFAULT CHARACTER SET ascii; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH def d9 ascii ascii_general_ci NULL def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL ALTER SCHEMA d9 DEFAULT COLLATE ascii_general_ci; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH def d9 ascii ascii_general_ci NULL def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL DROP DATABASE d9;
Back to File Manager