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')) {
  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         $char_set_name = PMA_DRIZZLE
  47             ? $row['DESCRIPTION']
  48             : $row['CHARACTER_SET_NAME'];
  49         if (! is_array($mysql_collations[$char_set_name])) {
  50             $mysql_collations[$char_set_name] = array($row['COLLATION_NAME']);
  51         } else {
  52             $mysql_collations[$char_set_name][] = $row['COLLATION_NAME'];
  53         }
  54         $mysql_collations_flat[] = $row['COLLATION_NAME'];
  55         if ($row['IS_DEFAULT'] == 'Yes' || $row['IS_DEFAULT'] == '1') {
  56             $mysql_default_collations[$char_set_name]
  57                 = $row['COLLATION_NAME'];
  58         }
  59         //$mysql_collations_available[$row['Collation']]
  60         //    = ! isset($row['Compiled']) || $row['Compiled'] == 'Yes';
  61         $mysql_collations_available[$row['COLLATION_NAME']] = true;
  62         $mysql_charsets_available[$char_set_name]
  63             = !empty($mysql_charsets_available[$char_set_name])
  64             || !empty($mysql_collations_available[$row['COLLATION_NAME']]);
  65     }
  66     $GLOBALS['dbi']->freeResult($res);
  67     unset($res, $row);
  68
  69     sort($mysql_collations_flat, SORT_STRING);
  70     foreach ($mysql_collations as $key => $value) {
  71         sort($mysql_collations[$key], SORT_STRING);
  72         reset($mysql_collations[$key]);
  73     }
  74     unset($key, $value);
  75
  76     PMA_Util::cacheSet(
  77         'mysql_charsets', $GLOBALS['mysql_charsets']
  78     );
  79     PMA_Util::cacheSet(
  80         'mysql_charsets_descriptions', $GLOBALS['mysql_charsets_descriptions']
  81     );
  82     PMA_Util::cacheSet(
  83         'mysql_charsets_available', $GLOBALS['mysql_charsets_available']
  84     );
  85     PMA_Util::cacheSet(
  86         'mysql_collations', $GLOBALS['mysql_collations']
  87     );
  88     PMA_Util::cacheSet(
  89         'mysql_default_collations', $GLOBALS['mysql_default_collations']
  90     );
  91     PMA_Util::cacheSet(
  92         'mysql_collations_flat', $GLOBALS['mysql_collations_flat']
  93     );
  94     PMA_Util::cacheSet(
  95         'mysql_collations_available', $GLOBALS['mysql_collations_available']
  96     );
  97 } else {
  98     $GLOBALS['mysql_charsets'] = PMA_Util::cacheGet(
  99         'mysql_charsets'
 100     );
 101     $GLOBALS['mysql_charsets_descriptions'] = PMA_Util::cacheGet(
 102         'mysql_charsets_descriptions'
 103     );
 104     $GLOBALS['mysql_charsets_available'] = PMA_Util::cacheGet(
 105         'mysql_charsets_available'
 106     );
 107     $GLOBALS['mysql_collations'] = PMA_Util::cacheGet(
 108         'mysql_collations'
 109     );
 110     $GLOBALS['mysql_default_collations'] = PMA_Util::cacheGet(
 111         'mysql_default_collations'
 112     );
 113     $GLOBALS['mysql_collations_flat'] = PMA_Util::cacheGet(
 114         'mysql_collations_flat'
 115     );
 116     $GLOBALS['mysql_collations_available'] = PMA_Util::cacheGet(
 117         'mysql_collations_available'
 118     );
 119 }
 120
 121 define('PMA_CSDROPDOWN_COLLATION', 0);
 122 define('PMA_CSDROPDOWN_CHARSET',   1);
 123
 124 /**
 125  * shared functions for mysql charsets
 126  */
 127 require_once './libraries/mysql_charsets.lib.php';
 128