Debian Codegraph @

mysql-test/suite/funcs_1/r/charset_collation.result

raw
1 DROP USER dbdict_test@localhost;
2 CREATE USER dbdict_test@localhost;
3 connect con,localhost,dbdict_test,,;
4
5 SELECT *
6 FROM information_schema.character_sets
7 WHERE character_set_name IN ('utf8mb3','latin1','binary')
8 ORDER BY character_set_name;
9 CHARACTER_SET_NAME DEFAULT_COLLATE_NAME DESCRIPTION MAXLEN
10 binary binary Binary pseudo charset 1
11 latin1 latin1_swedish_ci cp1252 West European 1
12 utf8mb3 utf8mb3_uca1400_ai_ci UTF-8 Unicode 3
13
14 SELECT *
15 FROM information_schema.collations
16 WHERE character_set_name IN ('utf8mb3','latin1','binary')
17 AND (collation_name LIKE CONCAT(character_set_name,'_general_ci')
18 OR
19 collation_name LIKE CONCAT(character_set_name,'_bin'))
20 ORDER BY collation_name;
21 COLLATION_NAME CHARACTER_SET_NAME ID IS_DEFAULT IS_COMPILED SORTLEN COMMENT
22 latin1_bin latin1 47 Yes 1 cp1252 West European
23 latin1_general_ci latin1 48 Yes 1 cp1252 West European
24 utf8mb3_bin utf8mb3 83 Yes 1 UTF-8 Unicode
25 utf8mb3_general_ci utf8mb3 33 Yes 1 UTF-8 Unicode
26
27 SELECT *
28 FROM information_schema.collation_character_set_applicability
29 WHERE character_set_name IN ('utf8mb3','latin1','binary')
30 AND (collation_name LIKE CONCAT(character_set_name,'_general_ci')
31 OR
32 collation_name LIKE CONCAT(character_set_name,'_bin'))
33 ORDER BY collation_name, character_set_name;
34 COLLATION_NAME CHARACTER_SET_NAME FULL_COLLATION_NAME ID IS_DEFAULT
35 latin1_bin latin1 latin1_bin 47
36 latin1_general_ci latin1 latin1_general_ci 48
37 utf8mb3_bin utf8mb3 utf8mb3_bin 83
38 utf8mb3_general_ci utf8mb3 utf8mb3_general_ci 33
39 connection default;
40 disconnect con;
41 DROP USER dbdict_test@localhost;