2 /* vim: set expandtab sw=4 ts=4 sts=4: */
12 if (! PMA_cacheExists('mysql_charsets_count', true)) {
13 $res = PMA_DBI_query('SHOW CHARACTER SET;');
15 $mysql_charsets = array();
16 while ($row = PMA_DBI_fetch_assoc($res)) {
17 $mysql_charsets[] = $row['Charset'];
19 //$mysql_charsets_maxlen[$row['Charset']] = $row['Maxlen'];
20 $mysql_charsets_descriptions[$row['Charset']] = $row['Description'];
22 PMA_DBI_free_result($res);
24 $mysql_charsets_count = count($mysql_charsets);
25 sort($mysql_charsets, SORT_STRING
);
27 $mysql_collations = array_flip($mysql_charsets);
28 $mysql_default_collations = $mysql_collations_flat = $mysql_charsets_available = $mysql_collations_available = array();
30 $res = PMA_DBI_query('SHOW COLLATION;');
31 while ($row = PMA_DBI_fetch_assoc($res)) {
32 if (!is_array($mysql_collations[$row['Charset']])) {
33 $mysql_collations[$row['Charset']] = array($row['Collation']);
35 $mysql_collations[$row['Charset']][] = $row['Collation'];
37 $mysql_collations_flat[] = $row['Collation'];
38 if ((isset($row['D']) && $row['D'] == 'Y') ||
(isset($row['Default']) && $row['Default'] == 'Yes')) {
39 $mysql_default_collations[$row['Charset']] = $row['Collation'];
41 //$mysql_collations_available[$row['Collation']] = !isset($row['Compiled']) || $row['Compiled'] == 'Yes';
42 $mysql_collations_available[$row['Collation']] = TRUE;
43 $mysql_charsets_available[$row['Charset']] =
44 !empty($mysql_charsets_available[$row['Charset']])
45 ||
!empty($mysql_collations_available[$row['Collation']]);
47 PMA_DBI_free_result($res);
50 $mysql_collations_count = count($mysql_collations_flat);
51 sort($mysql_collations_flat, SORT_STRING
);
52 foreach ($mysql_collations AS $key => $value) {
53 sort($mysql_collations[$key], SORT_STRING
);
54 reset($mysql_collations[$key]);
58 PMA_cacheSet('mysql_charsets', $GLOBALS['mysql_charsets'], true);
59 PMA_cacheSet('mysql_charsets_descriptions', $GLOBALS['mysql_charsets_descriptions'], true);
60 PMA_cacheSet('mysql_charsets_count', $GLOBALS['mysql_charsets_count'], true);
61 PMA_cacheSet('mysql_charsets_available', $GLOBALS['mysql_charsets_available'], true);
62 PMA_cacheSet('mysql_collations', $GLOBALS['mysql_collations'], true);
63 PMA_cacheSet('mysql_default_collations', $GLOBALS['mysql_default_collations'], true);
64 PMA_cacheSet('mysql_collations_flat', $GLOBALS['mysql_collations_flat'], true);
65 PMA_cacheSet('mysql_collations_count', $GLOBALS['mysql_collations_count'], true);
66 PMA_cacheSet('mysql_collations_available', $GLOBALS['mysql_collations_available'], true);
68 $GLOBALS['mysql_charsets'] = PMA_cacheGet('mysql_charsets', true);
69 $GLOBALS['mysql_charsets_descriptions'] = PMA_cacheGet('mysql_charsets_descriptions', true);
70 $GLOBALS['mysql_charsets_count'] = PMA_cacheGet('mysql_charsets_count', true);
71 $GLOBALS['mysql_charsets_available'] = PMA_cacheGet('mysql_charsets_available', true);
72 $GLOBALS['mysql_collations'] = PMA_cacheGet('mysql_collations', true);
73 $GLOBALS['mysql_default_collations'] = PMA_cacheGet('mysql_default_collations', true);
74 $GLOBALS['mysql_collations_flat'] = PMA_cacheGet('mysql_collations_flat', true);
75 $GLOBALS['mysql_collations_count'] = PMA_cacheGet('mysql_collations_count', true);
76 $GLOBALS['mysql_collations_available'] = PMA_cacheGet('mysql_collations_available', true);
79 define('PMA_CSDROPDOWN_COLLATION', 0);
80 define('PMA_CSDROPDOWN_CHARSET', 1);
82 function PMA_generateCharsetDropdownBox($type = PMA_CSDROPDOWN_COLLATION
,
83 $name = null, $id = null, $default = null, $label = TRUE, $indent = 0,
84 $submitOnChange = FALSE, $displayUnavailable = FALSE)
86 global $mysql_charsets, $mysql_charsets_descriptions,
87 $mysql_charsets_available, $mysql_collations, $mysql_collations_available;
90 if ($type == PMA_CSDROPDOWN_COLLATION
) {
93 $name = 'character_set';
97 $return_str = '<select xml:lang="en" dir="ltr" name="'
98 . htmlspecialchars($name) . '"'
99 . (empty($id) ?
'' : ' id="' . htmlspecialchars($id) . '"')
100 . ($submitOnChange ?
' onchange="this.form.submit();"' : '') . '>' . "\n";
102 $return_str .= '<option value="">'
103 . ($type == PMA_CSDROPDOWN_COLLATION ?
$GLOBALS['strCollation'] : $GLOBALS['strCharset'])
104 . '</option>' . "\n";
106 $return_str .= '<option value=""></option>' . "\n";
107 foreach ($mysql_charsets as $current_charset) {
108 if (!$mysql_charsets_available[$current_charset]) {
112 empty($mysql_charsets_descriptions[$current_charset])
114 : $mysql_charsets_descriptions[$current_charset];
116 if ($type == PMA_CSDROPDOWN_COLLATION
) {
117 $return_str .= '<optgroup label="' . $current_charset
118 . '" title="' . $current_cs_descr . '">' . "\n";
119 foreach ($mysql_collations[$current_charset] as $current_collation) {
120 if (!$mysql_collations_available[$current_collation]) {
123 $return_str .= '<option value="' . $current_collation
124 . '" title="' . PMA_getCollationDescr($current_collation) . '"'
125 . ($default == $current_collation ?
' selected="selected"' : '') . '>'
126 . $current_collation . '</option>' . "\n";
128 $return_str .= '</optgroup>' . "\n";
130 $return_str .= '<option value="' . $current_charset
131 . '" title="' . $current_cs_descr . '"'
132 . ($default == $current_charset ?
' selected="selected"' : '') . '>'
133 . $current_charset . '</option>' . "\n";
136 $return_str .= '</select>' . "\n";
141 function PMA_generateCharsetQueryPart($collation) {
142 list($charset) = explode('_', $collation);
143 return ' CHARACTER SET ' . $charset . ($charset == $collation ?
'' : ' COLLATE ' . $collation);
147 * returns collation of given db
149 * @uses PMA_DBI_fetch_value()
150 * @uses PMA_DBI_select_db()
151 * @uses PMA_sqlAddSlashes()
152 * @uses $GLOBALS['db']
153 * @param string $db name of db
154 * @return string collation of $db
156 function PMA_getDbCollation($db) {
157 if ($db == 'information_schema') {
158 // We don't have to check the collation of the virtual
159 // information_schema database: We know it!
160 return 'utf8_general_ci';
163 return PMA_DBI_fetch_value('SELECT DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME = \'' . PMA_sqlAddSlashes($db) . '\' LIMIT 1;');
167 * returns default server collation from show variables
169 * @uses PMA_DBI_fetch_value()
170 * @return string $server_collation
172 function PMA_getServerCollation() {
173 return PMA_DBI_fetch_value(
174 'SHOW VARIABLES LIKE \'collation_server\'', 0, 1);
178 * returns description for given collation
183 * @uses $GLOBALS['str[Languages|Sorting]']
185 * @param string $collation MySQL collation string
186 * @return string collation description
188 function PMA_getCollationDescr($collation) {
189 static $collation_cache;
191 if (!is_array($collation_cache)) {
192 $collation_cache = array();
193 } elseif (isset($collation_cache[$collation])) {
194 return $collation_cache[$collation];
197 if ($collation == 'binary') {
198 return $GLOBALS['strBinary'];
200 $parts = explode('_', $collation);
201 if (count($parts) == 1) {
202 $parts[1] = 'general';
203 } elseif ($parts[1] == 'ci' ||
$parts[1] == 'cs') {
204 $parts[2] = $parts[1];
205 $parts[1] = 'general';
210 $descr = $GLOBALS['strBulgarian'];
213 if ($parts[0] == 'gb2312' ||
$parts[0] == 'gbk') {
214 $descr = $GLOBALS['strSimplifiedChinese'];
215 } elseif ($parts[0] == 'big5') {
216 $descr = $GLOBALS['strTraditionalChinese'];
220 $descr = $GLOBALS['strCaseInsensitive'];
223 $descr = $GLOBALS['strCaseSensitive'];
226 $descr = $GLOBALS['strCroatian'];
229 $descr = $GLOBALS['strCzech'];
232 $descr = $GLOBALS['strDanish'];
235 $descr = $GLOBALS['strEnglish'];
238 $descr = $GLOBALS['strEsperanto'];
241 $descr = $GLOBALS['strEstonian'];
244 $descr = $GLOBALS['strGerman'] . ' (' . $GLOBALS['strDictionary'] . ')';
247 $descr = $GLOBALS['strGerman'] . ' (' . $GLOBALS['strPhoneBook'] . ')';
250 $descr = $GLOBALS['strHungarian'];
253 $descr = $GLOBALS['strIcelandic'];
256 $descr = $GLOBALS['strJapanese'];
259 $descr = $GLOBALS['strLatvian'];
262 $descr = $GLOBALS['strLithuanian'];
265 $descr = $GLOBALS['strKorean'];
268 $descr = $GLOBALS['strPersian'];
271 $descr = $GLOBALS['strPolish'];
274 $descr = $GLOBALS['strWestEuropean'];
277 $descr = $GLOBALS['strRomanian'];
280 $descr = $GLOBALS['strSlovak'];
283 $descr = $GLOBALS['strSlovenian'];
286 $descr = $GLOBALS['strSpanish'];
289 $descr = $GLOBALS['strTraditionalSpanish'];
292 $descr = $GLOBALS['strSwedish'];
295 $descr = $GLOBALS['strThai'];
298 $descr = $GLOBALS['strTurkish'];
301 $descr = $GLOBALS['strUkrainian'];
304 $descr = $GLOBALS['strUnicode'] . ' (' . $GLOBALS['strMultilingual'] . ')';
313 $descr = $GLOBALS['strUnicode'] . ' (' . $GLOBALS['strMultilingual'] . ')';
315 // West European charsets
322 $descr = $GLOBALS['strWestEuropean'] . ' (' . $GLOBALS['strMultilingual'] . ')';
324 // Central European charsets
329 $descr = $GLOBALS['strCentralEuropean'] . ' (' . $GLOBALS['strMultilingual'] . ')';
334 $descr = $GLOBALS['strRussian'];
336 // Simplified Chinese charsets
339 $descr = $GLOBALS['strSimplifiedChinese'];
346 $descr = $GLOBALS['strJapanese'];
351 $descr = $GLOBALS['strBaltic'] . ' (' . $GLOBALS['strMultilingual'] . ')';
356 $descr = $GLOBALS['strArmenian'];
359 $descr = $GLOBALS['strTraditionalChinese'];
362 $descr = $GLOBALS['strCyrillic'] . ' (' . $GLOBALS['strMultilingual'] . ')';
365 $descr = $GLOBALS['strArabic'];
368 $descr = $GLOBALS['strKorean'];
371 $descr = $GLOBALS['strHebrew'];
374 $descr = $GLOBALS['strGeorgian'];
377 $descr = $GLOBALS['strGreek'];
380 $descr = $GLOBALS['strCzechSlovak'];
383 $descr = $GLOBALS['strUkrainian'];
386 $descr = $GLOBALS['strTurkish'];
389 $descr = $GLOBALS['strSwedish'];
392 $descr = $GLOBALS['strThai'];
395 $descr = $GLOBALS['strUnknown'];
398 if (!empty($is_bin)) {
399 $descr .= ', ' . $GLOBALS['strBinary'];
402 default: $descr = $GLOBALS['strUnknown'];
404 if (!empty($parts[2])) {
405 if ($parts[2] == 'ci') {
406 $descr .= ', ' . $GLOBALS['strCaseInsensitive'];
407 } elseif ($parts[2] == 'cs') {
408 $descr .= ', ' . $GLOBALS['strCaseSensitive'];
412 $collation_cache[$collation] = $descr;