phpmyadmin/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
  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 = PMA_DBI_query($sql);
  23
  24     $mysql_charsets = array();
  25     while ($row = PMA_DBI_fetch_assoc($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     PMA_DBI_free_result($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 = PMA_DBI_query($sql);
  44     while ($row = PMA_DBI_fetch_assoc($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     PMA_DBI_free_result($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 function PMA_generateCharsetDropdownBox($type = PMA_CSDROPDOWN_COLLATION,
 110     $name = null, $id = null, $default = null, $label = true, $indent = 0,
 111     $submitOnChange = false, $displayUnavailable = false
 112 ) {
 113     global $mysql_charsets, $mysql_charsets_descriptions,
 114         $mysql_charsets_available, $mysql_collations, $mysql_collations_available;
 115
 116     if (empty($name)) {
 117         if ($type == PMA_CSDROPDOWN_COLLATION) {
 118             $name = 'collation';
 119         } else {
 120             $name = 'character_set';
 121         }
 122     }
 123
 124     $return_str  = '<select lang="en" dir="ltr" name="'
 125         . htmlspecialchars($name) . '"'
 126         . (empty($id) ? '' : ' id="' . htmlspecialchars($id) . '"')
 127         . ($submitOnChange ? ' class="autosubmit"' : '') . '>' . "\n";
 128     if ($label) {
 129         $return_str .= '<option value="">'
 130             . ($type == PMA_CSDROPDOWN_COLLATION ? __('Collation') : __('Charset'))
 131             . '</option>' . "\n";
 132     }
 133     $return_str .= '<option value=""></option>' . "\n";
 134     foreach ($mysql_charsets as $current_charset) {
 135         if (!$mysql_charsets_available[$current_charset]) {
 136             continue;
 137         }
 138         $current_cs_descr
 139             = empty($mysql_charsets_descriptions[$current_charset])
 140             ? $current_charset
 141             : $mysql_charsets_descriptions[$current_charset];
 142
 143         if ($type == PMA_CSDROPDOWN_COLLATION) {
 144             $return_str .= '<optgroup label="' . $current_charset
 145                 . '" title="' . $current_cs_descr . '">' . "\n";
 146             foreach ($mysql_collations[$current_charset] as $current_collation) {
 147                 if (!$mysql_collations_available[$current_collation]) {
 148                     continue;
 149                 }
 150                 $return_str .= '<option value="' . $current_collation
 151                     . '" title="' . PMA_getCollationDescr($current_collation) . '"'
 152                     . ($default == $current_collation ? ' selected="selected"' : '')
 153                     . '>'
 154                     . $current_collation . '</option>' . "\n";
 155             }
 156             $return_str .= '</optgroup>' . "\n";
 157         } else {
 158             $return_str .= '<option value="' . $current_charset
 159                 . '" title="' . $current_cs_descr . '"'
 160                 . ($default == $current_charset ? ' selected="selected"' : '') . '>'
 161                 . $current_charset . '</option>' . "\n";
 162         }
 163     }
 164     $return_str .= '</select>' . "\n";
 165
 166     return $return_str;
 167 }
 168
 169 function PMA_generateCharsetQueryPart($collation)
 170 {
 171     if (!PMA_DRIZZLE) {
 172         list($charset) = explode('_', $collation);
 173         return ' CHARACTER SET ' . $charset
 174             . ($charset == $collation ? '' : ' COLLATE ' . $collation);
 175     } else {
 176         return ' COLLATE ' . $collation;
 177     }
 178 }
 179
 180 /**
 181  * returns collation of given db
 182  *
 183  * @param string $db name of db
 184  *
 185  * @return string  collation of $db
 186  */
 187 function PMA_getDbCollation($db)
 188 {
 189     if (PMA_is_system_schema($db)) {
 190         // We don't have to check the collation of the virtual
 191         // information_schema database: We know it!
 192         return 'utf8_general_ci';
 193     }
 194
 195     if (! $GLOBALS['cfg']['Server']['DisableIS']) {
 196         // this is slow with thousands of databases
 197         $sql = PMA_DRIZZLE
 198             ? 'SELECT DEFAULT_COLLATION_NAME FROM data_dictionary.SCHEMAS'
 199             . ' WHERE SCHEMA_NAME = \'' . PMA_Util::sqlAddSlashes($db)
 200             . '\' LIMIT 1'
 201             : 'SELECT DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA'
 202             . ' WHERE SCHEMA_NAME = \'' . PMA_Util::sqlAddSlashes($db)
 203             . '\' LIMIT 1';
 204         return PMA_DBI_fetch_value($sql);
 205     } else {
 206         PMA_DBI_select_db($db);
 207         $return = PMA_DBI_fetch_value(
 208             'SHOW VARIABLES LIKE \'collation_database\'', 0, 1
 209         );
 210         if ($db !== $GLOBALS['db']) {
 211             PMA_DBI_select_db($GLOBALS['db']);
 212         }
 213         return $return;
 214     }
 215 }
 216
 217 /**
 218  * returns default server collation from show variables
 219  *
 220  * @return string  $server_collation
 221  */
 222 function PMA_getServerCollation()
 223 {
 224     return PMA_DBI_fetch_value(
 225         'SHOW VARIABLES LIKE \'collation_server\'', 0, 1
 226     );
 227 }
 228
 229 /**
 230  * returns description for given collation
 231  *
 232  * @param string $collation MySQL collation string
 233  *
 234  * @return string  collation description
 235  */
 236 function PMA_getCollationDescr($collation)
 237 {
 238     if ($collation == 'binary') {
 239         return __('Binary');
 240     }
 241     $parts = explode('_', $collation);
 242     if (count($parts) == 1) {
 243         $parts[1] = 'general';
 244     } elseif ($parts[1] == 'ci' || $parts[1] == 'cs') {
 245         $parts[2] = $parts[1];
 246         $parts[1] = 'general';
 247     }
 248     $descr = '';
 249     switch ($parts[1]) {
 250     case 'bulgarian':
 251         $descr = __('Bulgarian');
 252         break;
 253     case 'chinese':
 254         if ($parts[0] == 'gb2312' || $parts[0] == 'gbk') {
 255             $descr = __('Simplified Chinese');
 256         } elseif ($parts[0] == 'big5') {
 257             $descr = __('Traditional Chinese');
 258         }
 259         break;
 260     case 'ci':
 261         $descr = __('case-insensitive');
 262         break;
 263     case 'cs':
 264         $descr = __('case-sensitive');
 265         break;
 266     case 'croatian':
 267         $descr = __('Croatian');
 268         break;
 269     case 'czech':
 270         $descr = __('Czech');
 271         break;
 272     case 'danish':
 273         $descr = __('Danish');
 274         break;
 275     case 'english':
 276         $descr = __('English');
 277         break;
 278     case 'esperanto':
 279         $descr = __('Esperanto');
 280         break;
 281     case 'estonian':
 282         $descr = __('Estonian');
 283         break;
 284     case 'german1':
 285         $descr = __('German') . ' (' . __('dictionary') . ')';
 286         break;
 287     case 'german2':
 288         $descr = __('German') . ' (' . __('phone book') . ')';
 289         break;
 290     case 'hungarian':
 291         $descr = __('Hungarian');
 292         break;
 293     case 'icelandic':
 294         $descr = __('Icelandic');
 295         break;
 296     case 'japanese':
 297         $descr = __('Japanese');
 298         break;
 299     case 'latvian':
 300         $descr = __('Latvian');
 301         break;
 302     case 'lithuanian':
 303         $descr = __('Lithuanian');
 304         break;
 305     case 'korean':
 306         $descr = __('Korean');
 307         break;
 308     case 'persian':
 309         $descr = __('Persian');
 310         break;
 311     case 'polish':
 312         $descr = __('Polish');
 313         break;
 314     case 'roman':
 315         $descr = __('West European');
 316         break;
 317     case 'romanian':
 318         $descr = __('Romanian');
 319         break;
 320     case 'slovak':
 321         $descr = __('Slovak');
 322         break;
 323     case 'slovenian':
 324         $descr = __('Slovenian');
 325         break;
 326     case 'spanish':
 327         $descr = __('Spanish');
 328         break;
 329     case 'spanish2':
 330         $descr = __('Traditional Spanish');
 331         break;
 332     case 'swedish':
 333         $descr = __('Swedish');
 334         break;
 335     case 'thai':
 336         $descr = __('Thai');
 337         break;
 338     case 'turkish':
 339         $descr = __('Turkish');
 340         break;
 341     case 'ukrainian':
 342         $descr = __('Ukrainian');
 343         break;
 344     case 'unicode':
 345         $descr = __('Unicode') . ' (' . __('multilingual') . ')';
 346         break;
 347     case 'bin':
 348         $is_bin = true;
 349     case 'general':
 350         switch ($parts[0]) {
 351         // Unicode charsets
 352         case 'ucs2':
 353         case 'utf8':
 354             $descr = __('Unicode') . ' (' . __('multilingual') . ')';
 355             break;
 356         // West European charsets
 357         case 'ascii':
 358         case 'cp850':
 359         case 'dec8':
 360         case 'hp8':
 361         case 'latin1':
 362         case 'macroman':
 363             $descr = __('West European') . ' (' . __('multilingual') . ')';
 364             break;
 365         // Central European charsets
 366         case 'cp1250':
 367         case 'cp852':
 368         case 'latin2':
 369         case 'macce':
 370             $descr = __('Central European') . ' (' . __('multilingual') . ')';
 371             break;
 372         // Russian charsets
 373         case 'cp866':
 374         case 'koi8r':
 375             $descr = __('Russian');
 376             break;
 377         // Simplified Chinese charsets
 378         case 'gb2312':
 379         case 'gbk':
 380             $descr = __('Simplified Chinese');
 381             break;
 382         // Japanese charsets
 383         case 'sjis':
 384         case 'ujis':
 385         case 'cp932':
 386         case 'eucjpms':
 387             $descr = __('Japanese');
 388             break;
 389         // Baltic charsets
 390         case 'cp1257':
 391         case 'latin7':
 392             $descr = __('Baltic') . ' (' . __('multilingual') . ')';
 393             break;
 394         // Other
 395         case 'armscii8':
 396         case 'armscii':
 397             $descr = __('Armenian');
 398             break;
 399         case 'big5':
 400             $descr = __('Traditional Chinese');
 401             break;
 402         case 'cp1251':
 403             $descr = __('Cyrillic') . ' (' . __('multilingual') . ')';
 404             break;
 405         case 'cp1256':
 406             $descr = __('Arabic');
 407             break;
 408         case 'euckr':
 409             $descr = __('Korean');
 410             break;
 411         case 'hebrew':
 412             $descr = __('Hebrew');
 413             break;
 414         case 'geostd8':
 415             $descr = __('Georgian');
 416             break;
 417         case 'greek':
 418             $descr = __('Greek');
 419             break;
 420         case 'keybcs2':
 421             $descr = __('Czech-Slovak');
 422             break;
 423         case 'koi8u':
 424             $descr = __('Ukrainian');
 425             break;
 426         case 'latin5':
 427             $descr = __('Turkish');
 428             break;
 429         case 'swe7':
 430             $descr = __('Swedish');
 431             break;
 432         case 'tis620':
 433             $descr = __('Thai');
 434             break;
 435         default:
 436             $descr = __('unknown');
 437             break;
 438         }
 439         if (!empty($is_bin)) {
 440             $descr .= ', ' . __('Binary');
 441         }
 442         break;
 443     default: $descr = __('unknown');
 444     }
 445     if (!empty($parts[2])) {
 446         if ($parts[2] == 'ci') {
 447             $descr .= ', ' . __('case-insensitive');
 448         } elseif ($parts[2] == 'cs') {
 449             $descr .= ', ' . __('case-sensitive');
 450         }
 451     }
 452
 453     return $descr;
 454 }
 455 ?>