libraries/mysql_charsets.lib.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 if (! PMA_cacheExists('mysql_charsets_count', true)) {
  15     $sql = PMA_DRIZZLE
  16         ? 'SELECT * FROM data_dictionary.CHARACTER_SETS'
  17         : 'SELECT * FROM information_schema.CHARACTER_SETS';
  18     $res = PMA_DBI_query($sql);
  19
  20     $mysql_charsets = array();
  21     while ($row = PMA_DBI_fetch_assoc($res)) {
  22         $mysql_charsets[] = $row['CHARACTER_SET_NAME'];
  23         // never used
  24         //$mysql_charsets_maxlen[$row['Charset']] = $row['Maxlen'];
  25         $mysql_charsets_descriptions[$row['CHARACTER_SET_NAME']] = $row['DESCRIPTION'];
  26     }
  27     PMA_DBI_free_result($res);
  28
  29     $mysql_charsets_count = count($mysql_charsets);
  30     sort($mysql_charsets, SORT_STRING);
  31
  32     $mysql_collations = array_flip($mysql_charsets);
  33     $mysql_default_collations = $mysql_collations_flat = $mysql_charsets_available = $mysql_collations_available = array();
  34
  35     $sql = PMA_DRIZZLE
  36         ? 'SELECT * FROM data_dictionary.COLLATIONS'
  37         : 'SELECT * FROM information_schema.COLLATIONS';
  38     $res = PMA_DBI_query($sql);
  39     while ($row = PMA_DBI_fetch_assoc($res)) {
  40         if (!is_array($mysql_collations[$row['CHARACTER_SET_NAME']])) {
  41             $mysql_collations[$row['CHARACTER_SET_NAME']] = array($row['COLLATION_NAME']);
  42         } else {
  43             $mysql_collations[$row['CHARACTER_SET_NAME']][] = $row['COLLATION_NAME'];
  44         }
  45         $mysql_collations_flat[] = $row['COLLATION_NAME'];
  46         if ($row['IS_DEFAULT'] == 'Yes') {
  47             $mysql_default_collations[$row['CHARACTER_SET_NAME']] = $row['COLLATION_NAME'];
  48         }
  49         //$mysql_collations_available[$row['Collation']] = !isset($row['Compiled']) || $row['Compiled'] == 'Yes';
  50         $mysql_collations_available[$row['COLLATION_NAME']] = true;
  51         $mysql_charsets_available[$row['CHARACTER_SET_NAME']] =
  52             !empty($mysql_charsets_available[$row['CHARACTER_SET_NAME']])
  53             || !empty($mysql_collations_available[$row['COLLATION_NAME']]);
  54     }
  55     PMA_DBI_free_result($res);
  56     unset($res, $row);
  57
  58     if (PMA_DRIZZLE && isset($mysql_collations['utf8_general_ci']) && isset($mysql_collations['utf8'])) {
  59         $mysql_collations['utf8'] = $mysql_collations['utf8_general_ci'];
  60         unset($mysql_collations['utf8_general_ci']);
  61     }
  62
  63     $mysql_collations_count = count($mysql_collations_flat);
  64     sort($mysql_collations_flat, SORT_STRING);
  65     foreach ($mysql_collations AS $key => $value) {
  66         sort($mysql_collations[$key], SORT_STRING);
  67         reset($mysql_collations[$key]);
  68     }
  69     unset($key, $value);
  70
  71     PMA_cacheSet('mysql_charsets', $GLOBALS['mysql_charsets'], true);
  72     PMA_cacheSet('mysql_charsets_descriptions', $GLOBALS['mysql_charsets_descriptions'], true);
  73     PMA_cacheSet('mysql_charsets_count', $GLOBALS['mysql_charsets_count'], true);
  74     PMA_cacheSet('mysql_charsets_available', $GLOBALS['mysql_charsets_available'], true);
  75     PMA_cacheSet('mysql_collations', $GLOBALS['mysql_collations'], true);
  76     PMA_cacheSet('mysql_default_collations', $GLOBALS['mysql_default_collations'], true);
  77     PMA_cacheSet('mysql_collations_flat', $GLOBALS['mysql_collations_flat'], true);
  78     PMA_cacheSet('mysql_collations_count', $GLOBALS['mysql_collations_count'], true);
  79     PMA_cacheSet('mysql_collations_available', $GLOBALS['mysql_collations_available'], true);
  80 } else {
  81     $GLOBALS['mysql_charsets']                  = PMA_cacheGet('mysql_charsets', true);
  82     $GLOBALS['mysql_charsets_descriptions']     = PMA_cacheGet('mysql_charsets_descriptions', true);
  83     $GLOBALS['mysql_charsets_count']            = PMA_cacheGet('mysql_charsets_count', true);
  84     $GLOBALS['mysql_charsets_available']        = PMA_cacheGet('mysql_charsets_available', true);
  85     $GLOBALS['mysql_collations']                = PMA_cacheGet('mysql_collations', true);
  86     $GLOBALS['mysql_default_collations']        = PMA_cacheGet('mysql_default_collations', true);
  87     $GLOBALS['mysql_collations_flat']           = PMA_cacheGet('mysql_collations_flat', true);
  88     $GLOBALS['mysql_collations_count']          = PMA_cacheGet('mysql_collations_count', true);
  89     $GLOBALS['mysql_collations_available']      = PMA_cacheGet('mysql_collations_available', true);
  90 }
  91
  92 define('PMA_CSDROPDOWN_COLLATION', 0);
  93 define('PMA_CSDROPDOWN_CHARSET',   1);
  94
  95 function PMA_generateCharsetDropdownBox($type = PMA_CSDROPDOWN_COLLATION,
  96     $name = null, $id = null, $default = null, $label = TRUE, $indent = 0,
  97     $submitOnChange = FALSE, $displayUnavailable = FALSE)
  98 {
  99     global $mysql_charsets, $mysql_charsets_descriptions,
 100         $mysql_charsets_available, $mysql_collations, $mysql_collations_available;
 101
 102     if (empty($name)) {
 103         if ($type == PMA_CSDROPDOWN_COLLATION) {
 104             $name = 'collation';
 105         } else {
 106             $name = 'character_set';
 107         }
 108     }
 109
 110     $return_str  = '<select xml:lang="en" dir="ltr" name="'
 111         . htmlspecialchars($name) . '"'
 112         . (empty($id) ? '' : ' id="' . htmlspecialchars($id) . '"')
 113         . ($submitOnChange ? ' onchange="this.form.submit();"' : '') . '>' . "\n";
 114     if ($label) {
 115         $return_str .= '<option value="">'
 116             . ($type == PMA_CSDROPDOWN_COLLATION ? __('Collation') : __('Charset'))
 117             . '</option>' . "\n";
 118     }
 119     $return_str .= '<option value=""></option>' . "\n";
 120     foreach ($mysql_charsets as $current_charset) {
 121         if (!$mysql_charsets_available[$current_charset]) {
 122             continue;
 123         }
 124         $current_cs_descr =
 125             empty($mysql_charsets_descriptions[$current_charset])
 126             ? $current_charset
 127             : $mysql_charsets_descriptions[$current_charset];
 128
 129         if ($type == PMA_CSDROPDOWN_COLLATION) {
 130             $return_str .= '<optgroup label="' . $current_charset
 131                 . '" title="' . $current_cs_descr . '">' . "\n";
 132             foreach ($mysql_collations[$current_charset] as $current_collation) {
 133                 if (!$mysql_collations_available[$current_collation]) {
 134                     continue;
 135                 }
 136                 $return_str .= '<option value="' . $current_collation
 137                     . '" title="' . PMA_getCollationDescr($current_collation) . '"'
 138                     . ($default == $current_collation ? ' selected="selected"' : '') . '>'
 139                     . $current_collation . '</option>' . "\n";
 140             }
 141             $return_str .= '</optgroup>' . "\n";
 142         } else {
 143             $return_str .= '<option value="' . $current_charset
 144                 . '" title="' . $current_cs_descr . '"'
 145                 . ($default == $current_charset ? ' selected="selected"' : '') . '>'
 146                 . $current_charset . '</option>' . "\n";
 147         }
 148     }
 149     $return_str .= '</select>' . "\n";
 150
 151     return $return_str;
 152 }
 153
 154 function PMA_generateCharsetQueryPart($collation) {
 155     list($charset) = explode('_', $collation);
 156     return ' CHARACTER SET ' . $charset . ($charset == $collation ? '' : ' COLLATE ' . $collation);
 157 }
 158
 159 /**
 160  * returns collation of given db
 161  *
 162  * @uses    PMA_DBI_fetch_value()
 163  * @uses    PMA_DBI_select_db()
 164  * @uses    PMA_sqlAddSlashes()
 165  * @uses    $GLOBALS['db']
 166  * @param   string  $db     name of db
 167  * @return  string  collation of $db
 168  */
 169 function PMA_getDbCollation($db) {
 170     if ($db == 'information_schema') {
 171         // We don't have to check the collation of the virtual
 172         // information_schema database: We know it!
 173         return 'utf8_general_ci';
 174     }
 175
 176     if (! $GLOBALS['cfg']['Server']['DisableIS']) {
 177         // this is slow with thousands of databases
 178         return PMA_DBI_fetch_value('SELECT DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME = \'' . PMA_sqlAddSlashes($db) . '\' LIMIT 1;');
 179     } else {
 180         PMA_DBI_select_db($db);
 181         $return = PMA_DBI_fetch_value('SHOW VARIABLES LIKE \'collation_database\'', 0, 1);
 182         if ($db !== $GLOBALS['db']) {
 183             PMA_DBI_select_db($GLOBALS['db']);
 184         }
 185         return $return;
 186     }
 187 }
 188
 189 /**
 190  * returns default server collation from show variables
 191  *
 192  * @uses    PMA_DBI_fetch_value()
 193  * @return  string  $server_collation
 194  */
 195 function PMA_getServerCollation() {
 196     return PMA_DBI_fetch_value(
 197         'SHOW VARIABLES LIKE \'collation_server\'', 0, 1);
 198 }
 199
 200 /**
 201  * returns description for given collation
 202  *
 203  * @uses    is_array()
 204  * @uses    explode()
 205  * @uses    count()
 206  *
 207  * @param   string  $collation  MySQL collation string
 208  * @return  string  collation description
 209  */
 210 function PMA_getCollationDescr($collation) {
 211     if ($collation == 'binary') {
 212         return __('Binary');
 213     }
 214     $parts = explode('_', $collation);
 215     if (count($parts) == 1) {
 216         $parts[1] = 'general';
 217     } elseif ($parts[1] == 'ci' || $parts[1] == 'cs') {
 218         $parts[2] = $parts[1];
 219         $parts[1] = 'general';
 220     }
 221     $descr = '';
 222     switch ($parts[1]) {
 223         case 'bulgarian':
 224             $descr = __('Bulgarian');
 225             break;
 226         case 'chinese':
 227             if ($parts[0] == 'gb2312' || $parts[0] == 'gbk') {
 228                 $descr = __('Simplified Chinese');
 229             } elseif ($parts[0] == 'big5') {
 230                 $descr = __('Traditional Chinese');
 231             }
 232             break;
 233         case 'ci':
 234             $descr = __('case-insensitive');
 235             break;
 236         case 'cs':
 237             $descr = __('case-sensitive');
 238             break;
 239         case 'croatian':
 240             $descr = __('Croatian');
 241             break;
 242         case 'czech':
 243             $descr = __('Czech');
 244             break;
 245         case 'danish':
 246             $descr = __('Danish');
 247             break;
 248         case 'english':
 249             $descr = __('English');
 250             break;
 251         case 'esperanto':
 252             $descr = __('Esperanto');
 253             break;
 254         case 'estonian':
 255             $descr = __('Estonian');
 256             break;
 257         case 'german1':
 258             $descr = __('German') . ' (' . __('dictionary') . ')';
 259             break;
 260         case 'german2':
 261             $descr = __('German') . ' (' . __('phone book') . ')';
 262             break;
 263         case 'hungarian':
 264             $descr = __('Hungarian');
 265             break;
 266         case 'icelandic':
 267             $descr = __('Icelandic');
 268             break;
 269         case 'japanese':
 270             $descr = __('Japanese');
 271             break;
 272         case 'latvian':
 273             $descr = __('Latvian');
 274             break;
 275         case 'lithuanian':
 276             $descr = __('Lithuanian');
 277             break;
 278         case 'korean':
 279             $descr = __('Korean');
 280             break;
 281         case 'persian':
 282             $descr = __('Persian');
 283             break;
 284         case 'polish':
 285             $descr = __('Polish');
 286             break;
 287         case 'roman':
 288             $descr = __('West European');
 289             break;
 290         case 'romanian':
 291             $descr = __('Romanian');
 292             break;
 293         case 'slovak':
 294             $descr = __('Slovak');
 295             break;
 296         case 'slovenian':
 297             $descr = __('Slovenian');
 298             break;
 299         case 'spanish':
 300             $descr = __('Spanish');
 301             break;
 302         case 'spanish2':
 303             $descr = __('Traditional Spanish');
 304             break;
 305         case 'swedish':
 306             $descr = __('Swedish');
 307             break;
 308         case 'thai':
 309             $descr = __('Thai');
 310             break;
 311         case 'turkish':
 312             $descr = __('Turkish');
 313             break;
 314         case 'ukrainian':
 315             $descr = __('Ukrainian');
 316             break;
 317         case 'unicode':
 318             $descr = __('Unicode') . ' (' . __('multilingual') . ')';
 319             break;
 320         case 'bin':
 321             $is_bin = TRUE;
 322         case 'general':
 323             switch ($parts[0]) {
 324                 // Unicode charsets
 325                 case 'ucs2':
 326                 case 'utf8':
 327                     $descr = __('Unicode') . ' (' . __('multilingual') . ')';
 328                     break;
 329                 // West European charsets
 330                 case 'ascii':
 331                 case 'cp850':
 332                 case 'dec8':
 333                 case 'hp8':
 334                 case 'latin1':
 335                 case 'macroman':
 336                     $descr = __('West European') . ' (' . __('multilingual') . ')';
 337                     break;
 338                 // Central European charsets
 339                 case 'cp1250':
 340                 case 'cp852':
 341                 case 'latin2':
 342                 case 'macce':
 343                     $descr = __('Central European') . ' (' . __('multilingual') . ')';
 344                     break;
 345                 // Russian charsets
 346                 case 'cp866':
 347                 case 'koi8r':
 348                     $descr = __('Russian');
 349                     break;
 350                 // Simplified Chinese charsets
 351                 case 'gb2312':
 352                 case 'gbk':
 353                     $descr = __('Simplified Chinese');
 354                     break;
 355                 // Japanese charsets
 356                 case 'sjis':
 357                 case 'ujis':
 358                 case 'cp932':
 359                 case 'eucjpms':
 360                     $descr = __('Japanese');
 361                     break;
 362                 // Baltic charsets
 363                 case 'cp1257':
 364                 case 'latin7':
 365                     $descr = __('Baltic') . ' (' . __('multilingual') . ')';
 366                     break;
 367                 // Other
 368                 case 'armscii8':
 369                 case 'armscii':
 370                     $descr = __('Armenian');
 371                     break;
 372                 case 'big5':
 373                     $descr = __('Traditional Chinese');
 374                     break;
 375                 case 'cp1251':
 376                     $descr = __('Cyrillic') . ' (' . __('multilingual') . ')';
 377                     break;
 378                 case 'cp1256':
 379                     $descr = __('Arabic');
 380                     break;
 381                 case 'euckr':
 382                     $descr = __('Korean');
 383                     break;
 384                 case 'hebrew':
 385                     $descr = __('Hebrew');
 386                     break;
 387                 case 'geostd8':
 388                     $descr = __('Georgian');
 389                     break;
 390                 case 'greek':
 391                     $descr = __('Greek');
 392                     break;
 393                 case 'keybcs2':
 394                     $descr = __('Czech-Slovak');
 395                     break;
 396                 case 'koi8u':
 397                     $descr = __('Ukrainian');
 398                     break;
 399                 case 'latin5':
 400                     $descr = __('Turkish');
 401                     break;
 402                 case 'swe7':
 403                     $descr = __('Swedish');
 404                     break;
 405                 case 'tis620':
 406                     $descr = __('Thai');
 407                     break;
 408                 default:
 409                     $descr = __('unknown');
 410                     break;
 411             }
 412             if (!empty($is_bin)) {
 413                 $descr .= ', ' . __('Binary');
 414             }
 415             break;
 416         default: $descr = __('unknown');
 417     }
 418     if (!empty($parts[2])) {
 419         if ($parts[2] == 'ci') {
 420             $descr .= ', ' . __('case-insensitive');
 421         } elseif ($parts[2] == 'cs') {
 422             $descr .= ', ' . __('case-sensitive');
 423         }
 424     }
 425
 426     return $descr;
 427 }
 428 ?>