libraries/mysql_charsets.inc.php

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