← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/collation_dictionary/tests/r/data_dictionary.result

  • Committer: Brian Aker
  • Date: 2010-07-12 06:26:42 UTC
  • Revision ID: brian@gaz-20100712062642-6flofbshd9rfbi0c
MErge in change to do YES/NO like standard requires.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/collation_dictionary/tests/r/data_dictionary.result
24
24
utf8    utf8_general_ci UTF-8 Unicode   4
25
25
SELECT * FROM collations ORDER BY COLLATION_NAME;
26
26
CHARACTER_SET_NAME      COLLATION_NAME  DESCRIPTION     ID      IS_DEFAULT      IS_COMPILED     SORTLEN
27
 
binary  binary  binary  63      TRUE    TRUE    1
28
 
utf8_general_ci utf8_bin        utf8    46      FALSE   TRUE    1
29
 
utf8_general_ci utf8_czech_ci   utf8    234     FALSE   TRUE    8
30
 
utf8_general_ci utf8_danish_ci  utf8    235     FALSE   TRUE    8
31
 
utf8_general_ci utf8_esperanto_ci       utf8    241     FALSE   TRUE    8
32
 
utf8_general_ci utf8_estonian_ci        utf8    230     FALSE   TRUE    8
33
 
utf8_general_ci utf8_general_ci utf8    45      TRUE    TRUE    1
34
 
utf8_general_ci utf8_hungarian_ci       utf8    242     FALSE   TRUE    8
35
 
utf8_general_ci utf8_icelandic_ci       utf8    225     FALSE   TRUE    8
36
 
utf8_general_ci utf8_latvian_ci utf8    226     FALSE   TRUE    8
37
 
utf8_general_ci utf8_lithuanian_ci      utf8    236     FALSE   TRUE    8
38
 
utf8_general_ci utf8_persian_ci utf8    240     FALSE   TRUE    8
39
 
utf8_general_ci utf8_polish_ci  utf8    229     FALSE   TRUE    8
40
 
utf8_general_ci utf8_romanian_ci        utf8    227     FALSE   TRUE    8
41
 
utf8_general_ci utf8_roman_ci   utf8    239     FALSE   TRUE    8
42
 
utf8_general_ci utf8_sinhala_ci utf8    243     FALSE   TRUE    8
43
 
utf8_general_ci utf8_slovak_ci  utf8    237     FALSE   TRUE    8
44
 
utf8_general_ci utf8_slovenian_ci       utf8    228     FALSE   TRUE    8
45
 
utf8_general_ci utf8_spanish2_ci        utf8    238     FALSE   TRUE    8
46
 
utf8_general_ci utf8_spanish_ci utf8    231     FALSE   TRUE    8
47
 
utf8_general_ci utf8_swedish_ci utf8    232     FALSE   TRUE    8
48
 
utf8_general_ci utf8_turkish_ci utf8    233     FALSE   TRUE    8
49
 
utf8_general_ci utf8_unicode_ci utf8    224     FALSE   TRUE    8
 
27
binary  binary  binary  63      YES     YES     1
 
28
utf8_general_ci utf8_bin        utf8    46      NO      YES     1
 
29
utf8_general_ci utf8_czech_ci   utf8    234     NO      YES     8
 
30
utf8_general_ci utf8_danish_ci  utf8    235     NO      YES     8
 
31
utf8_general_ci utf8_esperanto_ci       utf8    241     NO      YES     8
 
32
utf8_general_ci utf8_estonian_ci        utf8    230     NO      YES     8
 
33
utf8_general_ci utf8_general_ci utf8    45      YES     YES     1
 
34
utf8_general_ci utf8_hungarian_ci       utf8    242     NO      YES     8
 
35
utf8_general_ci utf8_icelandic_ci       utf8    225     NO      YES     8
 
36
utf8_general_ci utf8_latvian_ci utf8    226     NO      YES     8
 
37
utf8_general_ci utf8_lithuanian_ci      utf8    236     NO      YES     8
 
38
utf8_general_ci utf8_persian_ci utf8    240     NO      YES     8
 
39
utf8_general_ci utf8_polish_ci  utf8    229     NO      YES     8
 
40
utf8_general_ci utf8_romanian_ci        utf8    227     NO      YES     8
 
41
utf8_general_ci utf8_roman_ci   utf8    239     NO      YES     8
 
42
utf8_general_ci utf8_sinhala_ci utf8    243     NO      YES     8
 
43
utf8_general_ci utf8_slovak_ci  utf8    237     NO      YES     8
 
44
utf8_general_ci utf8_slovenian_ci       utf8    228     NO      YES     8
 
45
utf8_general_ci utf8_spanish2_ci        utf8    238     NO      YES     8
 
46
utf8_general_ci utf8_spanish_ci utf8    231     NO      YES     8
 
47
utf8_general_ci utf8_swedish_ci utf8    232     NO      YES     8
 
48
utf8_general_ci utf8_turkish_ci utf8    233     NO      YES     8
 
49
utf8_general_ci utf8_unicode_ci utf8    224     NO      YES     8
50
50
SELECT *
51
51
FROM data_dictionary.character_sets
52
52
ORDER BY character_set_name;
57
57
FROM data_dictionary.collations
58
58
ORDER BY collation_name;
59
59
CHARACTER_SET_NAME      COLLATION_NAME  DESCRIPTION     ID      IS_DEFAULT      IS_COMPILED     SORTLEN
60
 
binary  binary  binary  63      TRUE    TRUE    1
61
 
utf8_general_ci utf8_bin        utf8    46      FALSE   TRUE    1
62
 
utf8_general_ci utf8_czech_ci   utf8    234     FALSE   TRUE    8
63
 
utf8_general_ci utf8_danish_ci  utf8    235     FALSE   TRUE    8
64
 
utf8_general_ci utf8_esperanto_ci       utf8    241     FALSE   TRUE    8
65
 
utf8_general_ci utf8_estonian_ci        utf8    230     FALSE   TRUE    8
66
 
utf8_general_ci utf8_general_ci utf8    45      TRUE    TRUE    1
67
 
utf8_general_ci utf8_hungarian_ci       utf8    242     FALSE   TRUE    8
68
 
utf8_general_ci utf8_icelandic_ci       utf8    225     FALSE   TRUE    8
69
 
utf8_general_ci utf8_latvian_ci utf8    226     FALSE   TRUE    8
70
 
utf8_general_ci utf8_lithuanian_ci      utf8    236     FALSE   TRUE    8
71
 
utf8_general_ci utf8_persian_ci utf8    240     FALSE   TRUE    8
72
 
utf8_general_ci utf8_polish_ci  utf8    229     FALSE   TRUE    8
73
 
utf8_general_ci utf8_romanian_ci        utf8    227     FALSE   TRUE    8
74
 
utf8_general_ci utf8_roman_ci   utf8    239     FALSE   TRUE    8
75
 
utf8_general_ci utf8_sinhala_ci utf8    243     FALSE   TRUE    8
76
 
utf8_general_ci utf8_slovak_ci  utf8    237     FALSE   TRUE    8
77
 
utf8_general_ci utf8_slovenian_ci       utf8    228     FALSE   TRUE    8
78
 
utf8_general_ci utf8_spanish2_ci        utf8    238     FALSE   TRUE    8
79
 
utf8_general_ci utf8_spanish_ci utf8    231     FALSE   TRUE    8
80
 
utf8_general_ci utf8_swedish_ci utf8    232     FALSE   TRUE    8
81
 
utf8_general_ci utf8_turkish_ci utf8    233     FALSE   TRUE    8
82
 
utf8_general_ci utf8_unicode_ci utf8    224     FALSE   TRUE    8
 
60
binary  binary  binary  63      YES     YES     1
 
61
utf8_general_ci utf8_bin        utf8    46      NO      YES     1
 
62
utf8_general_ci utf8_czech_ci   utf8    234     NO      YES     8
 
63
utf8_general_ci utf8_danish_ci  utf8    235     NO      YES     8
 
64
utf8_general_ci utf8_esperanto_ci       utf8    241     NO      YES     8
 
65
utf8_general_ci utf8_estonian_ci        utf8    230     NO      YES     8
 
66
utf8_general_ci utf8_general_ci utf8    45      YES     YES     1
 
67
utf8_general_ci utf8_hungarian_ci       utf8    242     NO      YES     8
 
68
utf8_general_ci utf8_icelandic_ci       utf8    225     NO      YES     8
 
69
utf8_general_ci utf8_latvian_ci utf8    226     NO      YES     8
 
70
utf8_general_ci utf8_lithuanian_ci      utf8    236     NO      YES     8
 
71
utf8_general_ci utf8_persian_ci utf8    240     NO      YES     8
 
72
utf8_general_ci utf8_polish_ci  utf8    229     NO      YES     8
 
73
utf8_general_ci utf8_romanian_ci        utf8    227     NO      YES     8
 
74
utf8_general_ci utf8_roman_ci   utf8    239     NO      YES     8
 
75
utf8_general_ci utf8_sinhala_ci utf8    243     NO      YES     8
 
76
utf8_general_ci utf8_slovak_ci  utf8    237     NO      YES     8
 
77
utf8_general_ci utf8_slovenian_ci       utf8    228     NO      YES     8
 
78
utf8_general_ci utf8_spanish2_ci        utf8    238     NO      YES     8
 
79
utf8_general_ci utf8_spanish_ci utf8    231     NO      YES     8
 
80
utf8_general_ci utf8_swedish_ci utf8    232     NO      YES     8
 
81
utf8_general_ci utf8_turkish_ci utf8    233     NO      YES     8
 
82
utf8_general_ci utf8_unicode_ci utf8    224     NO      YES     8
83
83
select * from data_dictionary.CHARACTER_SETS
84
84
where CHARACTER_SET_NAME like 'latin1%';
85
85
CHARACTER_SET_NAME      DEFAULT_COLLATE_NAME    DESCRIPTION     MAXLEN