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 # Establish connection con (user=dbdict_test)
4
5 SELECT *
6 FROM information_schema.character_sets
7 WHERE character_set_name IN ('utf8','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
13 SELECT *
14 FROM information_schema.collations
15 WHERE character_set_name IN ('utf8','latin1','binary')
16 AND (collation_name LIKE CONCAT(character_set_name,'_general_ci')
17 OR
18 collation_name LIKE CONCAT(character_set_name,'_bin'))
19 ORDER BY collation_name;
20 COLLATION_NAME CHARACTER_SET_NAME ID IS_DEFAULT IS_COMPILED SORTLEN PAD_ATTRIBUTE
21 latin1_bin latin1 47 Yes 1 PAD SPACE
22 latin1_general_ci latin1 48 Yes 1 PAD SPACE
23
24 SELECT *
25 FROM information_schema.collation_character_set_applicability
26 WHERE character_set_name IN ('utf8','latin1','binary')
27 AND (collation_name LIKE CONCAT(character_set_name,'_general_ci')
28 OR
29 collation_name LIKE CONCAT(character_set_name,'_bin'))
30 ORDER BY collation_name, character_set_name;
31 COLLATION_NAME CHARACTER_SET_NAME
32 latin1_bin latin1
33 latin1_general_ci latin1
34 # Switch to connection default
35 DROP USER dbdict_test@localhost;