2 /* vim: set expandtab sw=4 ts=4 sts=4: */
7 if (! defined('PHPMYADMIN')) {
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;
20 ?
'SELECT * FROM data_dictionary.CHARACTER_SETS'
21 : 'SELECT * FROM information_schema.CHARACTER_SETS';
22 $res = PMA_DBI_query($sql);
24 $mysql_charsets = array();
25 while ($row = PMA_DBI_fetch_assoc($res)) {
26 $mysql_charsets[] = $row['CHARACTER_SET_NAME'];
28 //$mysql_charsets_maxlen[$row['Charset']] = $row['Maxlen'];
29 $mysql_charsets_descriptions[$row['CHARACTER_SET_NAME']]
30 = $row['DESCRIPTION'];
32 PMA_DBI_free_result($res);
34 sort($mysql_charsets, SORT_STRING
);
36 $mysql_collations = array_flip($mysql_charsets);
37 $mysql_default_collations = $mysql_collations_flat
38 = $mysql_charsets_available = $mysql_collations_available = array();
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']);
49 $mysql_collations[$row['CHARACTER_SET_NAME']][] = $row['COLLATION_NAME'];
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'];
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']]);
63 PMA_DBI_free_result($res);
67 && isset($mysql_collations['utf8_general_ci'])
68 && isset($mysql_collations['utf8'])
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'];
76 $mysql_collations['utf8_general_ci'],
77 $mysql_default_collations['utf8_general_ci'],
78 $mysql_charsets_available['utf8_general_ci']
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]);
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);
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);
106 define('PMA_CSDROPDOWN_COLLATION', 0);
107 define('PMA_CSDROPDOWN_CHARSET', 1);
109 function PMA_generateCharsetDropdownBox($type = PMA_CSDROPDOWN_COLLATION
,
110 $name = null, $id = null, $default = null, $label = true, $indent = 0,
111 $submitOnChange = false, $displayUnavailable = false
113 global $mysql_charsets, $mysql_charsets_descriptions,
114 $mysql_charsets_available, $mysql_collations, $mysql_collations_available;
117 if ($type == PMA_CSDROPDOWN_COLLATION
) {
120 $name = 'character_set';
124 $return_str = '<select lang="en" dir="ltr" name="'
125 . htmlspecialchars($name) . '"'
126 . (empty($id) ?
'' : ' id="' . htmlspecialchars($id) . '"')
127 . ($submitOnChange ?
' class="autosubmit"' : '') . '>' . "\n";
129 $return_str .= '<option value="">'
130 . ($type == PMA_CSDROPDOWN_COLLATION ?
__('Collation') : __('Charset'))
131 . '</option>' . "\n";
133 $return_str .= '<option value=""></option>' . "\n";
134 foreach ($mysql_charsets as $current_charset) {
135 if (!$mysql_charsets_available[$current_charset]) {
139 = empty($mysql_charsets_descriptions[$current_charset])
141 : $mysql_charsets_descriptions[$current_charset];
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]) {
150 $return_str .= '<option value="' . $current_collation
151 . '" title="' . PMA_getCollationDescr($current_collation) . '"'
152 . ($default == $current_collation ?
' selected="selected"' : '')
154 . $current_collation . '</option>' . "\n";
156 $return_str .= '</optgroup>' . "\n";
158 $return_str .= '<option value="' . $current_charset
159 . '" title="' . $current_cs_descr . '"'
160 . ($default == $current_charset ?
' selected="selected"' : '') . '>'
161 . $current_charset . '</option>' . "\n";
164 $return_str .= '</select>' . "\n";
169 function PMA_generateCharsetQueryPart($collation)
172 list($charset) = explode('_', $collation);
173 return ' CHARACTER SET ' . $charset
174 . ($charset == $collation ?
'' : ' COLLATE ' . $collation);
176 return ' COLLATE ' . $collation;
181 * returns collation of given db
183 * @param string $db name of db
185 * @return string collation of $db
187 function PMA_getDbCollation($db)
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';
195 if (! $GLOBALS['cfg']['Server']['DisableIS']) {
196 // this is slow with thousands of databases
198 ?
'SELECT DEFAULT_COLLATION_NAME FROM data_dictionary.SCHEMAS'
199 . ' WHERE SCHEMA_NAME = \'' . PMA_Util
::sqlAddSlashes($db)
201 : 'SELECT DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA'
202 . ' WHERE SCHEMA_NAME = \'' . PMA_Util
::sqlAddSlashes($db)
204 return PMA_DBI_fetch_value($sql);
206 PMA_DBI_select_db($db);
207 $return = PMA_DBI_fetch_value(
208 'SHOW VARIABLES LIKE \'collation_database\'', 0, 1
210 if ($db !== $GLOBALS['db']) {
211 PMA_DBI_select_db($GLOBALS['db']);
218 * returns default server collation from show variables
220 * @return string $server_collation
222 function PMA_getServerCollation()
224 return PMA_DBI_fetch_value(
225 'SHOW VARIABLES LIKE \'collation_server\'', 0, 1
230 * returns description for given collation
232 * @param string $collation MySQL collation string
234 * @return string collation description
236 function PMA_getCollationDescr($collation)
238 if ($collation == 'binary') {
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';
251 $descr = __('Bulgarian');
254 if ($parts[0] == 'gb2312' ||
$parts[0] == 'gbk') {
255 $descr = __('Simplified Chinese');
256 } elseif ($parts[0] == 'big5') {
257 $descr = __('Traditional Chinese');
261 $descr = __('case-insensitive');
264 $descr = __('case-sensitive');
267 $descr = __('Croatian');
270 $descr = __('Czech');
273 $descr = __('Danish');
276 $descr = __('English');
279 $descr = __('Esperanto');
282 $descr = __('Estonian');
285 $descr = __('German') . ' (' . __('dictionary') . ')';
288 $descr = __('German') . ' (' . __('phone book') . ')';
291 $descr = __('Hungarian');
294 $descr = __('Icelandic');
297 $descr = __('Japanese');
300 $descr = __('Latvian');
303 $descr = __('Lithuanian');
306 $descr = __('Korean');
309 $descr = __('Persian');
312 $descr = __('Polish');
315 $descr = __('West European');
318 $descr = __('Romanian');
321 $descr = __('Slovak');
324 $descr = __('Slovenian');
327 $descr = __('Spanish');
330 $descr = __('Traditional Spanish');
333 $descr = __('Swedish');
339 $descr = __('Turkish');
342 $descr = __('Ukrainian');
345 $descr = __('Unicode') . ' (' . __('multilingual') . ')';
354 $descr = __('Unicode') . ' (' . __('multilingual') . ')';
356 // West European charsets
363 $descr = __('West European') . ' (' . __('multilingual') . ')';
365 // Central European charsets
370 $descr = __('Central European') . ' (' . __('multilingual') . ')';
375 $descr = __('Russian');
377 // Simplified Chinese charsets
380 $descr = __('Simplified Chinese');
387 $descr = __('Japanese');
392 $descr = __('Baltic') . ' (' . __('multilingual') . ')';
397 $descr = __('Armenian');
400 $descr = __('Traditional Chinese');
403 $descr = __('Cyrillic') . ' (' . __('multilingual') . ')';
406 $descr = __('Arabic');
409 $descr = __('Korean');
412 $descr = __('Hebrew');
415 $descr = __('Georgian');
418 $descr = __('Greek');
421 $descr = __('Czech-Slovak');
424 $descr = __('Ukrainian');
427 $descr = __('Turkish');
430 $descr = __('Swedish');
436 $descr = __('unknown');
439 if (!empty($is_bin)) {
440 $descr .= ', ' . __('Binary');
443 default: $descr = __('unknown');
445 if (!empty($parts[2])) {
446 if ($parts[2] == 'ci') {
447 $descr .= ', ' . __('case-insensitive');
448 } elseif ($parts[2] == 'cs') {
449 $descr .= ', ' . __('case-sensitive');