release/src/router/mysql/mysql-test/suite/funcs_1/r/charset_collation.result

   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 utf8    utf8_general_ci UTF-8 Unicode   3
  13
  14 SELECT *
  15 FROM information_schema.collations
  16 WHERE character_set_name IN ('utf8','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
  22 latin1_bin      latin1  47              Yes     1
  23 latin1_general_ci       latin1  48              Yes     1
  24 utf8_bin        utf8    83              Yes     1
  25 utf8_general_ci utf8    33      Yes     Yes     1
  26
  27 SELECT *
  28 FROM information_schema.collation_character_set_applicability
  29 WHERE character_set_name IN ('utf8','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
  35 latin1_bin      latin1
  36 latin1_general_ci       latin1
  37 utf8_bin        utf8
  38 utf8_general_ci utf8
  39 # Switch to connection default + disconnect con
  40 DROP USER dbdict_test@localhost;