← Back to branch summary

~ubuntu-branches/ubuntu/lucid/mysql-dfsg-5.1/lucid-security

« back to all changes in this revision

Viewing changes to mysql-test/suite/engines/funcs/r/db_alter_collate_ascii.result

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 22:33:55 UTC
  • mto: (1.2.1) (37.1.1 lucid-security)
  • mto: This revision was merged to the branch mainline in revision 36.
  • Revision ID: package-import@ubuntu.com-20120222223355-ku1tb4r70osci6v2
Tags: upstream-5.1.61
Import upstream version 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/engines/funcs/r/db_alter_collate_ascii.result
 
1
DROP DATABASE IF EXISTS d9;
 
2
SHOW COLLATION;
 
3
Collation       Charset Id      Default Compiled        Sortlen
 
4
big5_chinese_ci big5    1       Yes     #       #
 
5
big5_bin        big5    84              #       #
 
6
dec8_swedish_ci dec8    3       Yes     #       #
 
7
dec8_bin        dec8    69              #       #
 
8
cp850_general_ci        cp850   4       Yes     #       #
 
9
cp850_bin       cp850   80              #       #
 
10
hp8_english_ci  hp8     6       Yes     #       #
 
11
hp8_bin hp8     72              #       #
 
12
koi8r_general_ci        koi8r   7       Yes     #       #
 
13
koi8r_bin       koi8r   74              #       #
 
14
latin1_german1_ci       latin1  5               #       #
 
15
latin1_swedish_ci       latin1  8       Yes     #       #
 
16
latin1_danish_ci        latin1  15              #       #
 
17
latin1_german2_ci       latin1  31              #       #
 
18
latin1_bin      latin1  47              #       #
 
19
latin1_general_ci       latin1  48              #       #
 
20
latin1_general_cs       latin1  49              #       #
 
21
latin1_spanish_ci       latin1  94              #       #
 
22
latin2_czech_cs latin2  2               #       #
 
23
latin2_general_ci       latin2  9       Yes     #       #
 
24
latin2_hungarian_ci     latin2  21              #       #
 
25
latin2_croatian_ci      latin2  27              #       #
 
26
latin2_bin      latin2  77              #       #
 
27
swe7_swedish_ci swe7    10      Yes     #       #
 
28
swe7_bin        swe7    82              #       #
 
29
ascii_general_ci        ascii   11      Yes     #       #
 
30
ascii_bin       ascii   65              #       #
 
31
ujis_japanese_ci        ujis    12      Yes     #       #
 
32
ujis_bin        ujis    91              #       #
 
33
sjis_japanese_ci        sjis    13      Yes     #       #
 
34
sjis_bin        sjis    88              #       #
 
35
hebrew_general_ci       hebrew  16      Yes     #       #
 
36
hebrew_bin      hebrew  71              #       #
 
37
tis620_thai_ci  tis620  18      Yes     #       #
 
38
tis620_bin      tis620  89              #       #
 
39
euckr_korean_ci euckr   19      Yes     #       #
 
40
euckr_bin       euckr   85              #       #
 
41
koi8u_general_ci        koi8u   22      Yes     #       #
 
42
koi8u_bin       koi8u   75              #       #
 
43
gb2312_chinese_ci       gb2312  24      Yes     #       #
 
44
gb2312_bin      gb2312  86              #       #
 
45
greek_general_ci        greek   25      Yes     #       #
 
46
greek_bin       greek   70              #       #
 
47
cp1250_general_ci       cp1250  26      Yes     #       #
 
48
cp1250_czech_cs cp1250  34              #       #
 
49
cp1250_croatian_ci      cp1250  44              #       #
 
50
cp1250_bin      cp1250  66              #       #
 
51
cp1250_polish_ci        cp1250  99              #       #
 
52
gbk_chinese_ci  gbk     28      Yes     #       #
 
53
gbk_bin gbk     87              #       #
 
54
latin5_turkish_ci       latin5  30      Yes     #       #
 
55
latin5_bin      latin5  78              #       #
 
56
armscii8_general_ci     armscii8        32      Yes     #       #
 
57
armscii8_bin    armscii8        64              #       #
 
58
utf8_general_ci utf8    33      Yes     #       #
 
59
utf8_bin        utf8    83              #       #
 
60
utf8_unicode_ci utf8    192             #       #
 
61
utf8_icelandic_ci       utf8    193             #       #
 
62
utf8_latvian_ci utf8    194             #       #
 
63
utf8_romanian_ci        utf8    195             #       #
 
64
utf8_slovenian_ci       utf8    196             #       #
 
65
utf8_polish_ci  utf8    197             #       #
 
66
utf8_estonian_ci        utf8    198             #       #
 
67
utf8_spanish_ci utf8    199             #       #
 
68
utf8_swedish_ci utf8    200             #       #
 
69
utf8_turkish_ci utf8    201             #       #
 
70
utf8_czech_ci   utf8    202             #       #
 
71
utf8_danish_ci  utf8    203             #       #
 
72
utf8_lithuanian_ci      utf8    204             #       #
 
73
utf8_slovak_ci  utf8    205             #       #
 
74
utf8_spanish2_ci        utf8    206             #       #
 
75
utf8_roman_ci   utf8    207             #       #
 
76
utf8_persian_ci utf8    208             #       #
 
77
utf8_esperanto_ci       utf8    209             #       #
 
78
utf8_hungarian_ci       utf8    210             #       #
 
79
ucs2_general_ci ucs2    35      Yes     #       #
 
80
ucs2_bin        ucs2    90              #       #
 
81
ucs2_unicode_ci ucs2    128             #       #
 
82
ucs2_icelandic_ci       ucs2    129             #       #
 
83
ucs2_latvian_ci ucs2    130             #       #
 
84
ucs2_romanian_ci        ucs2    131             #       #
 
85
ucs2_slovenian_ci       ucs2    132             #       #
 
86
ucs2_polish_ci  ucs2    133             #       #
 
87
ucs2_estonian_ci        ucs2    134             #       #
 
88
ucs2_spanish_ci ucs2    135             #       #
 
89
ucs2_swedish_ci ucs2    136             #       #
 
90
ucs2_turkish_ci ucs2    137             #       #
 
91
ucs2_czech_ci   ucs2    138             #       #
 
92
ucs2_danish_ci  ucs2    139             #       #
 
93
ucs2_lithuanian_ci      ucs2    140             #       #
 
94
ucs2_slovak_ci  ucs2    141             #       #
 
95
ucs2_spanish2_ci        ucs2    142             #       #
 
96
ucs2_roman_ci   ucs2    143             #       #
 
97
ucs2_persian_ci ucs2    144             #       #
 
98
ucs2_esperanto_ci       ucs2    145             #       #
 
99
ucs2_hungarian_ci       ucs2    146             #       #
 
100
cp866_general_ci        cp866   36      Yes     #       #
 
101
cp866_bin       cp866   68              #       #
 
102
keybcs2_general_ci      keybcs2 37      Yes     #       #
 
103
keybcs2_bin     keybcs2 73              #       #
 
104
macce_general_ci        macce   38      Yes     #       #
 
105
macce_bin       macce   43              #       #
 
106
macroman_general_ci     macroman        39      Yes     #       #
 
107
macroman_bin    macroman        53              #       #
 
108
cp852_general_ci        cp852   40      Yes     #       #
 
109
cp852_bin       cp852   81              #       #
 
110
latin7_estonian_cs      latin7  20              #       #
 
111
latin7_general_ci       latin7  41      Yes     #       #
 
112
latin7_general_cs       latin7  42              #       #
 
113
latin7_bin      latin7  79              #       #
 
114
cp1251_bulgarian_ci     cp1251  14              #       #
 
115
cp1251_ukrainian_ci     cp1251  23              #       #
 
116
cp1251_bin      cp1251  50              #       #
 
117
cp1251_general_ci       cp1251  51      Yes     #       #
 
118
cp1251_general_cs       cp1251  52              #       #
 
119
cp1256_general_ci       cp1256  57      Yes     #       #
 
120
cp1256_bin      cp1256  67              #       #
 
121
cp1257_lithuanian_ci    cp1257  29              #       #
 
122
cp1257_bin      cp1257  58              #       #
 
123
cp1257_general_ci       cp1257  59      Yes     #       #
 
124
binary  binary  63      Yes     #       #
 
125
geostd8_general_ci      geostd8 92      Yes     #       #
 
126
geostd8_bin     geostd8 93              #       #
 
127
cp932_japanese_ci       cp932   95      Yes     #       #
 
128
cp932_bin       cp932   96              #       #
 
129
eucjpms_japanese_ci     eucjpms 97      Yes     #       #
 
130
eucjpms_bin     eucjpms 98              #       #
 
131
CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
 
132
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
 
133
CATALOG_NAME    SCHEMA_NAME     DEFAULT_CHARACTER_SET_NAME      DEFAULT_COLLATION_NAME  SQL_PATH
 
134
NULL    d9      ascii   ascii_general_ci        NULL
 
135
NULL    information_schema      utf8    utf8_general_ci NULL
 
136
NULL    mtr     latin1  latin1_swedish_ci       NULL
 
137
NULL    mysql   latin1  latin1_swedish_ci       NULL
 
138
NULL    test    latin1  latin1_swedish_ci       NULL
 
139
ALTER DATABASE d9   COLLATE ascii_bin;
 
140
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
 
141
CATALOG_NAME    SCHEMA_NAME     DEFAULT_CHARACTER_SET_NAME      DEFAULT_COLLATION_NAME  SQL_PATH
 
142
NULL    d9      ascii   ascii_bin       NULL
 
143
NULL    information_schema      utf8    utf8_general_ci NULL
 
144
NULL    mtr     latin1  latin1_swedish_ci       NULL
 
145
NULL    mysql   latin1  latin1_swedish_ci       NULL
 
146
NULL    test    latin1  latin1_swedish_ci       NULL
 
147
DROP DATABASE d9;
 
148
CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
 
149
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
 
150
CATALOG_NAME    SCHEMA_NAME     DEFAULT_CHARACTER_SET_NAME      DEFAULT_COLLATION_NAME  SQL_PATH
 
151
NULL    d9      ascii   ascii_general_ci        NULL
 
152
NULL    information_schema      utf8    utf8_general_ci NULL
 
153
NULL    mtr     latin1  latin1_swedish_ci       NULL
 
154
NULL    mysql   latin1  latin1_swedish_ci       NULL
 
155
NULL    test    latin1  latin1_swedish_ci       NULL
 
156
ALTER DATABASE d9 DEFAULT COLLATE ascii_bin;
 
157
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
 
158
CATALOG_NAME    SCHEMA_NAME     DEFAULT_CHARACTER_SET_NAME      DEFAULT_COLLATION_NAME  SQL_PATH
 
159
NULL    d9      ascii   ascii_bin       NULL
 
160
NULL    information_schema      utf8    utf8_general_ci NULL
 
161
NULL    mtr     latin1  latin1_swedish_ci       NULL
 
162
NULL    mysql   latin1  latin1_swedish_ci       NULL
 
163
NULL    test    latin1  latin1_swedish_ci       NULL
 
164
DROP DATABASE d9;
 
165
CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
 
166
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
 
167
CATALOG_NAME    SCHEMA_NAME     DEFAULT_CHARACTER_SET_NAME      DEFAULT_COLLATION_NAME  SQL_PATH
 
168
NULL    d9      ascii   ascii_general_ci        NULL
 
169
NULL    information_schema      utf8    utf8_general_ci NULL
 
170
NULL    mtr     latin1  latin1_swedish_ci       NULL
 
171
NULL    mysql   latin1  latin1_swedish_ci       NULL
 
172
NULL    test    latin1  latin1_swedish_ci       NULL
 
173
ALTER DATABASE d9   COLLATE ascii_general_ci;
 
174
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
 
175
CATALOG_NAME    SCHEMA_NAME     DEFAULT_CHARACTER_SET_NAME      DEFAULT_COLLATION_NAME  SQL_PATH
 
176
NULL    d9      ascii   ascii_general_ci        NULL
 
177
NULL    information_schema      utf8    utf8_general_ci NULL
 
178
NULL    mtr     latin1  latin1_swedish_ci       NULL
 
179
NULL    mysql   latin1  latin1_swedish_ci       NULL
 
180
NULL    test    latin1  latin1_swedish_ci       NULL
 
181
DROP DATABASE d9;
 
182
CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
 
183
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
 
184
CATALOG_NAME    SCHEMA_NAME     DEFAULT_CHARACTER_SET_NAME      DEFAULT_COLLATION_NAME  SQL_PATH
 
185
NULL    d9      ascii   ascii_general_ci        NULL
 
186
NULL    information_schema      utf8    utf8_general_ci NULL
 
187
NULL    mtr     latin1  latin1_swedish_ci       NULL
 
188
NULL    mysql   latin1  latin1_swedish_ci       NULL
 
189
NULL    test    latin1  latin1_swedish_ci       NULL
 
190
ALTER DATABASE d9 DEFAULT COLLATE ascii_general_ci;
 
191
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
 
192
CATALOG_NAME    SCHEMA_NAME     DEFAULT_CHARACTER_SET_NAME      DEFAULT_COLLATION_NAME  SQL_PATH
 
193
NULL    d9      ascii   ascii_general_ci        NULL
 
194
NULL    information_schema      utf8    utf8_general_ci NULL
 
195
NULL    mtr     latin1  latin1_swedish_ci       NULL
 
196
NULL    mysql   latin1  latin1_swedish_ci       NULL
 
197
NULL    test    latin1  latin1_swedish_ci       NULL
 
198
DROP DATABASE d9;
 
199
CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
 
200
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
 
201
CATALOG_NAME    SCHEMA_NAME     DEFAULT_CHARACTER_SET_NAME      DEFAULT_COLLATION_NAME  SQL_PATH
 
202
NULL    d9      ascii   ascii_general_ci        NULL
 
203
NULL    information_schema      utf8    utf8_general_ci NULL
 
204
NULL    mtr     latin1  latin1_swedish_ci       NULL
 
205
NULL    mysql   latin1  latin1_swedish_ci       NULL
 
206
NULL    test    latin1  latin1_swedish_ci       NULL
 
207
ALTER SCHEMA d9   COLLATE ascii_bin;
 
208
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
 
209
CATALOG_NAME    SCHEMA_NAME     DEFAULT_CHARACTER_SET_NAME      DEFAULT_COLLATION_NAME  SQL_PATH
 
210
NULL    d9      ascii   ascii_bin       NULL
 
211
NULL    information_schema      utf8    utf8_general_ci NULL
 
212
NULL    mtr     latin1  latin1_swedish_ci       NULL
 
213
NULL    mysql   latin1  latin1_swedish_ci       NULL
 
214
NULL    test    latin1  latin1_swedish_ci       NULL
 
215
DROP DATABASE d9;
 
216
CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
 
217
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
 
218
CATALOG_NAME    SCHEMA_NAME     DEFAULT_CHARACTER_SET_NAME      DEFAULT_COLLATION_NAME  SQL_PATH
 
219
NULL    d9      ascii   ascii_general_ci        NULL
 
220
NULL    information_schema      utf8    utf8_general_ci NULL
 
221
NULL    mtr     latin1  latin1_swedish_ci       NULL
 
222
NULL    mysql   latin1  latin1_swedish_ci       NULL
 
223
NULL    test    latin1  latin1_swedish_ci       NULL
 
224
ALTER SCHEMA d9 DEFAULT COLLATE ascii_bin;
 
225
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
 
226
CATALOG_NAME    SCHEMA_NAME     DEFAULT_CHARACTER_SET_NAME      DEFAULT_COLLATION_NAME  SQL_PATH
 
227
NULL    d9      ascii   ascii_bin       NULL
 
228
NULL    information_schema      utf8    utf8_general_ci NULL
 
229
NULL    mtr     latin1  latin1_swedish_ci       NULL
 
230
NULL    mysql   latin1  latin1_swedish_ci       NULL
 
231
NULL    test    latin1  latin1_swedish_ci       NULL
 
232
DROP DATABASE d9;
 
233
CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
 
234
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
 
235
CATALOG_NAME    SCHEMA_NAME     DEFAULT_CHARACTER_SET_NAME      DEFAULT_COLLATION_NAME  SQL_PATH
 
236
NULL    d9      ascii   ascii_general_ci        NULL
 
237
NULL    information_schema      utf8    utf8_general_ci NULL
 
238
NULL    mtr     latin1  latin1_swedish_ci       NULL
 
239
NULL    mysql   latin1  latin1_swedish_ci       NULL
 
240
NULL    test    latin1  latin1_swedish_ci       NULL
 
241
ALTER SCHEMA d9   COLLATE ascii_general_ci;
 
242
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
 
243
CATALOG_NAME    SCHEMA_NAME     DEFAULT_CHARACTER_SET_NAME      DEFAULT_COLLATION_NAME  SQL_PATH
 
244
NULL    d9      ascii   ascii_general_ci        NULL
 
245
NULL    information_schema      utf8    utf8_general_ci NULL
 
246
NULL    mtr     latin1  latin1_swedish_ci       NULL
 
247
NULL    mysql   latin1  latin1_swedish_ci       NULL
 
248
NULL    test    latin1  latin1_swedish_ci       NULL
 
249
DROP DATABASE d9;
 
250
CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
 
251
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
 
252
CATALOG_NAME    SCHEMA_NAME     DEFAULT_CHARACTER_SET_NAME      DEFAULT_COLLATION_NAME  SQL_PATH
 
253
NULL    d9      ascii   ascii_general_ci        NULL
 
254
NULL    information_schema      utf8    utf8_general_ci NULL
 
255
NULL    mtr     latin1  latin1_swedish_ci       NULL
 
256
NULL    mysql   latin1  latin1_swedish_ci       NULL
 
257
NULL    test    latin1  latin1_swedish_ci       NULL
 
258
ALTER SCHEMA d9 DEFAULT COLLATE ascii_general_ci;
 
259
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
 
260
CATALOG_NAME    SCHEMA_NAME     DEFAULT_CHARACTER_SET_NAME      DEFAULT_COLLATION_NAME  SQL_PATH
 
261
NULL    d9      ascii   ascii_general_ci        NULL
 
262
NULL    information_schema      utf8    utf8_general_ci NULL
 
263
NULL    mtr     latin1  latin1_swedish_ci       NULL
 
264
NULL    mysql   latin1  latin1_swedish_ci       NULL
 
265
NULL    test    latin1  latin1_swedish_ci       NULL
 
266
DROP DATABASE d9;