← 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: Monty Taylor
  • Date: 2010-03-11 18:27:20 UTC
  • mfrom: (1333 staging)
  • mto: This revision was merged to the branch mainline in revision 1348.
  • Revision ID: mordred@inaugust.com-20100311182720-hd1h87y6cb1b1mp0
Merged trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/collation_dictionary/tests/r/data_dictionary.result
 
1
use data_dictionary;
 
2
show create table CHARACTER_SETS ;
 
3
Table   Create Table
 
4
CHARACTER_SETS  CREATE TABLE `character_sets` (
 
5
  `CHARACTER_SET_NAME` varchar(64) NOT NULL DEFAULT '',
 
6
  `DEFAULT_COLLATE_NAME` varchar(64) NOT NULL DEFAULT '',
 
7
  `DESCRIPTION` varchar(64) NOT NULL DEFAULT '',
 
8
  `MAXLEN` bigint NOT NULL DEFAULT '0'
 
9
) ENGINE=FunctionEngine
 
10
show create table COLLATIONS ;
 
11
Table   Create Table
 
12
COLLATIONS      CREATE TABLE `collations` (
 
13
  `CHARACTER_SET_NAME` varchar(64) NOT NULL DEFAULT '',
 
14
  `COLLATION_NAME` varchar(64) NOT NULL DEFAULT '',
 
15
  `DESCRIPTION` varchar(64) NOT NULL DEFAULT '',
 
16
  `ID` bigint NOT NULL DEFAULT '0',
 
17
  `IS_DEFAULT` varchar(5) NOT NULL DEFAULT '',
 
18
  `IS_COMPILED` varchar(5) NOT NULL DEFAULT '',
 
19
  `SORTLEN` bigint NOT NULL DEFAULT '0'
 
20
) ENGINE=FunctionEngine
 
21
SELECT * FROM character_sets ORDER BY CHARACTER_SET_NAME;
 
22
CHARACTER_SET_NAME      DEFAULT_COLLATE_NAME    DESCRIPTION     MAXLEN
 
23
binary  binary  UTF-8 Unicode   1
 
24
utf8    utf8_general_ci UTF-8 Unicode   4
 
25
SELECT * FROM collations ORDER BY COLLATION_NAME;
 
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
 
50
SELECT *
 
51
FROM data_dictionary.character_sets
 
52
ORDER BY character_set_name;
 
53
CHARACTER_SET_NAME      DEFAULT_COLLATE_NAME    DESCRIPTION     MAXLEN
 
54
binary  binary  UTF-8 Unicode   1
 
55
utf8    utf8_general_ci UTF-8 Unicode   4
 
56
SELECT *
 
57
FROM data_dictionary.collations
 
58
ORDER BY collation_name;
 
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
 
83
select * from data_dictionary.CHARACTER_SETS
 
84
where CHARACTER_SET_NAME like 'latin1%';
 
85
CHARACTER_SET_NAME      DEFAULT_COLLATE_NAME    DESCRIPTION     MAXLEN
 
86
select * from data_dictionary.COLLATIONS
 
87
where COLLATION_NAME like 'latin1%';
 
88
CHARACTER_SET_NAME      COLLATION_NAME  DESCRIPTION     ID      IS_DEFAULT      IS_COMPILED     SORTLEN