Debian Codegraph @

mysql-test/suite/engines/funcs/r/db_create_character_set_collate.result

raw
1 DROP DATABASE IF EXISTS d13;
2 CREATE DATABASE d13 CHARACTER SET utf8 COLLATE utf8_general_ci;
3 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
4 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
5 def d13 utf8mb3 utf8mb3_general_ci NULL
6 def information_schema utf8mb3 utf8mb3_general_ci NULL
7 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
8 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
9 def performance_schema utf8mb3 utf8mb3_general_ci NULL
10 def sys utf8mb3 utf8mb3_general_ci NULL
11 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
12 DROP DATABASE d13;
13 CREATE DATABASE d13 CHARACTER SET latin2 COLLATE latin2_general_ci;
14 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
15 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
16 def d13 latin2 latin2_general_ci NULL
17 def information_schema utf8mb3 utf8mb3_general_ci NULL
18 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
19 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
20 def performance_schema utf8mb3 utf8mb3_general_ci NULL
21 def sys utf8mb3 utf8mb3_general_ci NULL
22 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
23 DROP DATABASE d13;
24 CREATE DATABASE d13 CHARACTER SET cp1250 COLLATE cp1250_croatian_ci;
25 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
26 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
27 def d13 cp1250 cp1250_croatian_ci NULL
28 def information_schema utf8mb3 utf8mb3_general_ci NULL
29 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
30 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
31 def performance_schema utf8mb3 utf8mb3_general_ci NULL
32 def sys utf8mb3 utf8mb3_general_ci NULL
33 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
34 DROP DATABASE d13;
35 CREATE SCHEMA d13 CHARACTER SET utf8 COLLATE utf8_general_ci;
36 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
37 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
38 def d13 utf8mb3 utf8mb3_general_ci NULL
39 def information_schema utf8mb3 utf8mb3_general_ci NULL
40 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
41 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
42 def performance_schema utf8mb3 utf8mb3_general_ci NULL
43 def sys utf8mb3 utf8mb3_general_ci NULL
44 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
45 DROP SCHEMA d13;
46 CREATE SCHEMA d13 CHARACTER SET latin2 COLLATE latin2_general_ci;
47 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
48 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
49 def d13 latin2 latin2_general_ci NULL
50 def information_schema utf8mb3 utf8mb3_general_ci NULL
51 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
52 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
53 def performance_schema utf8mb3 utf8mb3_general_ci NULL
54 def sys utf8mb3 utf8mb3_general_ci NULL
55 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
56 DROP SCHEMA d13;
57 CREATE SCHEMA d13 CHARACTER SET cp1250 COLLATE cp1250_croatian_ci;
58 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
59 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
60 def d13 cp1250 cp1250_croatian_ci NULL
61 def information_schema utf8mb3 utf8mb3_general_ci NULL
62 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
63 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
64 def performance_schema utf8mb3 utf8mb3_general_ci NULL
65 def sys utf8mb3 utf8mb3_general_ci NULL
66 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
67 DROP SCHEMA d13;