phpmyadmin/libraries/mysql_charsets.inc.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * MySQL charsets listings
   5  *
   6  * @package PhpMyAdmin
   7  */
   8 if (! defined('PHPMYADMIN')) {
   9     exit;
  10 }
  11
  12 /**
  13  *
  14  */
  15
  16 if (! PMA_Util::cacheExists('mysql_charsets', null)) {
  17     global $mysql_charsets, $mysql_charsets_descriptions,
  18         $mysql_charsets_available, $mysql_collations, $mysql_collations_available,
  19         $mysql_default_collations, $mysql_collations_flat;
  20     $sql = PMA_DRIZZLE
  21         ? 'SELECT * FROM data_dictionary.CHARACTER_SETS'
  22         : 'SELECT * FROM information_schema.CHARACTER_SETS';
  23     $res = $GLOBALS['dbi']->query($sql);
  24
  25     $mysql_charsets = array();
  26     while ($row = $GLOBALS['dbi']->fetchAssoc($res)) {
  27         $mysql_charsets[] = $row['CHARACTER_SET_NAME'];
  28         // never used
  29         //$mysql_charsets_maxlen[$row['Charset']] = $row['Maxlen'];
  30         $mysql_charsets_descriptions[$row['CHARACTER_SET_NAME']]
  31             = $row['DESCRIPTION'];
  32     }
  33     $GLOBALS['dbi']->freeResult($res);
  34
  35     sort($mysql_charsets, SORT_STRING);
  36
  37     $mysql_collations = array_flip($mysql_charsets);
  38     $mysql_default_collations = $mysql_collations_flat
  39         = $mysql_charsets_available = $mysql_collations_available = array();
  40
  41     $sql = PMA_DRIZZLE
  42         ? 'SELECT * FROM data_dictionary.COLLATIONS'
  43         : 'SELECT * FROM information_schema.COLLATIONS';
  44     $res = $GLOBALS['dbi']->query($sql);
  45     while ($row = $GLOBALS['dbi']->fetchAssoc($res)) {
  46         if (! is_array($mysql_collations[$row['CHARACTER_SET_NAME']])) {
  47             $mysql_collations[$row['CHARACTER_SET_NAME']]
  48                 = array($row['COLLATION_NAME']);
  49         } else {
  50             $mysql_collations[$row['CHARACTER_SET_NAME']][] = $row['COLLATION_NAME'];
  51         }
  52         $mysql_collations_flat[] = $row['COLLATION_NAME'];
  53         if ($row['IS_DEFAULT'] == 'Yes' || $row['IS_DEFAULT'] == '1') {
  54             $mysql_default_collations[$row['CHARACTER_SET_NAME']]
  55                 = $row['COLLATION_NAME'];
  56         }
  57         //$mysql_collations_available[$row['Collation']]
  58         //    = ! isset($row['Compiled']) || $row['Compiled'] == 'Yes';
  59         $mysql_collations_available[$row['COLLATION_NAME']] = true;
  60         $mysql_charsets_available[$row['CHARACTER_SET_NAME']]
  61             = !empty($mysql_charsets_available[$row['CHARACTER_SET_NAME']])
  62             || !empty($mysql_collations_available[$row['COLLATION_NAME']]);
  63     }
  64     $GLOBALS['dbi']->freeResult($res);
  65     unset($res, $row);
  66
  67     if (PMA_DRIZZLE
  68         && isset($mysql_collations['utf8_general_ci'])
  69         && isset($mysql_collations['utf8'])
  70     ) {
  71         $mysql_collations['utf8'] = $mysql_collations['utf8_general_ci'];
  72         $mysql_default_collations['utf8']
  73             = $mysql_default_collations['utf8_general_ci'];
  74         $mysql_charsets_available['utf8']
  75             = $mysql_charsets_available['utf8_general_ci'];
  76         unset(
  77             $mysql_collations['utf8_general_ci'],
  78             $mysql_default_collations['utf8_general_ci'],
  79             $mysql_charsets_available['utf8_general_ci']
  80         );
  81     }
  82
  83     sort($mysql_collations_flat, SORT_STRING);
  84     foreach ($mysql_collations as $key => $value) {
  85         sort($mysql_collations[$key], SORT_STRING);
  86         reset($mysql_collations[$key]);
  87     }
  88     unset($key, $value);
  89
  90     PMA_Util::cacheSet(
  91         'mysql_charsets', $GLOBALS['mysql_charsets'], null
  92     );
  93     PMA_Util::cacheSet(
  94         'mysql_charsets_descriptions', $GLOBALS['mysql_charsets_descriptions'], null
  95     );
  96     PMA_Util::cacheSet(
  97         'mysql_charsets_available', $GLOBALS['mysql_charsets_available'], null
  98     );
  99     PMA_Util::cacheSet(
 100         'mysql_collations', $GLOBALS['mysql_collations'], null
 101     );
 102     PMA_Util::cacheSet(
 103         'mysql_default_collations', $GLOBALS['mysql_default_collations'], null
 104     );
 105     PMA_Util::cacheSet(
 106         'mysql_collations_flat', $GLOBALS['mysql_collations_flat'], null
 107     );
 108     PMA_Util::cacheSet(
 109         'mysql_collations_available', $GLOBALS['mysql_collations_available'], null
 110     );
 111 } else {
 112     $GLOBALS['mysql_charsets'] = PMA_Util::cacheGet(
 113         'mysql_charsets', null
 114     );
 115     $GLOBALS['mysql_charsets_descriptions'] = PMA_Util::cacheGet(
 116         'mysql_charsets_descriptions', null
 117     );
 118     $GLOBALS['mysql_charsets_available'] = PMA_Util::cacheGet(
 119         'mysql_charsets_available', null
 120     );
 121     $GLOBALS['mysql_collations'] = PMA_Util::cacheGet(
 122         'mysql_collations', null
 123     );
 124     $GLOBALS['mysql_default_collations'] = PMA_Util::cacheGet(
 125         'mysql_default_collations', null
 126     );
 127     $GLOBALS['mysql_collations_flat'] = PMA_Util::cacheGet(
 128         'mysql_collations_flat', null
 129     );
 130     $GLOBALS['mysql_collations_available'] = PMA_Util::cacheGet(
 131         'mysql_collations_available', null
 132     );
 133 }
 134
 135 define('PMA_CSDROPDOWN_COLLATION', 0);
 136 define('PMA_CSDROPDOWN_CHARSET',   1);
 137
 138 /**
 139  * shared functions for mysql charsets
 140  */
 141 require_once './libraries/mysql_charsets.lib.php';
 142
 143 ?>