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 Warnings:
4 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
5 Warning 3778 'utf8mb3_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
6 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
7 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
8 def d13 utf8mb3 utf8mb3_general_ci NULL NO
9 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
10 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
11 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
12 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
13 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
14 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
15 DROP DATABASE d13;
16 CREATE DATABASE d13 CHARACTER SET latin2 COLLATE latin2_general_ci;
17 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
18 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
19 def d13 latin2 latin2_general_ci NULL NO
20 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
21 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
22 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
23 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
24 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
25 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
26 DROP DATABASE d13;
27 CREATE DATABASE d13 CHARACTER SET cp1250 COLLATE cp1250_croatian_ci;
28 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
29 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
30 def d13 cp1250 cp1250_croatian_ci NULL NO
31 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
32 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
33 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
34 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
35 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
36 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
37 DROP DATABASE d13;
38 CREATE SCHEMA d13 CHARACTER SET utf8 COLLATE utf8_general_ci;
39 Warnings:
40 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
41 Warning 3778 'utf8mb3_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
42 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
43 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
44 def d13 utf8mb3 utf8mb3_general_ci NULL NO
45 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
46 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
47 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
48 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
49 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
50 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
51 DROP SCHEMA d13;
52 CREATE SCHEMA d13 CHARACTER SET latin2 COLLATE latin2_general_ci;
53 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
54 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
55 def d13 latin2 latin2_general_ci NULL NO
56 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
57 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
58 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
59 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
60 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
61 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
62 DROP SCHEMA d13;
63 CREATE SCHEMA d13 CHARACTER SET cp1250 COLLATE cp1250_croatian_ci;
64 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
65 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
66 def d13 cp1250 cp1250_croatian_ci NULL NO
67 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
68 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
69 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
70 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
71 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
72 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
73 DROP SCHEMA d13;