Convert Excel column name correctly
[phpmyadmin/arisferyanto.git] / libraries / iconv_wrapper.lib.php
blob2a69f2a459e636a45b6579d0fc8bf697d9af4421
1 <?php
2 /* vim: set expandtab sw=4 ts=4 sts=4: */
3 /**
5 * @version $Id$
6 * @package phpMyAdmin
7 */
8 if (! defined('PHPMYADMIN')) {
9 exit;
12 /**
15 # GNU iconv code set to IBM AIX libiconv code set table
16 # Keys of this table should be in lowercase, and searches should be performed using lowercase!
17 $gnu_iconv_to_aix_iconv_codepage_map = array (
18 // "iso-8859-[1-9]" --> "ISO8859-[1-9]" according to http://publibn.boulder.ibm.com/doc_link/en_US/a_doc_lib/libs/basetrf2/setlocale.htm
19 'iso-8859-1' => 'ISO8859-1',
20 'iso-8859-2' => 'ISO8859-2',
21 'iso-8859-3' => 'ISO8859-3',
22 'iso-8859-4' => 'ISO8859-4',
23 'iso-8859-5' => 'ISO8859-5',
24 'iso-8859-6' => 'ISO8859-6',
25 'iso-8859-7' => 'ISO8859-7',
26 'iso-8859-8' => 'ISO8859-8',
27 'iso-8859-9' => 'ISO8859-9',
29 // "big5" --> "IBM-eucTW" according to http://kadesh.cepba.upc.es/mancpp/classref/ref/ITranscoder_DSC.htm
30 'big5' => 'IBM-eucTW',
32 // Other mappings corresponding to the phpMyAdmin dropdown box when using the AllowAnywhereRecoding feature
33 'euc-jp' => 'IBM-eucJP',
34 'koi8-r' => 'IBM-eucKR',
35 'ks_c_5601-1987' => 'KSC5601.1987-0',
36 'tis-620' => 'TIS-620',
37 'utf-8' => 'UTF-8'
40 /**
41 * Wrapper around IBM AIX iconv(), whose character set naming differs
42 * from the GNU version of iconv().
44 * @param string input character set
45 * @param string output character set
46 * @param string the string to convert
48 * @return mixed converted string or FALSE on failure
50 * @access public
52 * @author bwiberg Björn Wiberg <Bjorn.Wiberg@its.uu.se>
54 function PMA_aix_iconv_wrapper($in_charset, $out_charset, $str) {
56 global $gnu_iconv_to_aix_iconv_codepage_map;
58 // Check for transliteration argument at the end of output character set name
59 $translit_search = strpos(strtolower($out_charset), '//translit');
60 $using_translit = (!($translit_search === FALSE));
62 // Extract "plain" output character set name (without any transliteration argument)
63 $out_charset_plain = ($using_translit ? substr($out_charset, 0, $translit_search) : $out_charset);
65 // Transform name of input character set (if found)
66 if (array_key_exists(strtolower($in_charset), $gnu_iconv_to_aix_iconv_codepage_map)) {
67 $in_charset = $gnu_iconv_to_aix_iconv_codepage_map[strtolower($in_charset)];
70 // Transform name of "plain" output character set (if found)
71 if (array_key_exists(strtolower($out_charset_plain), $gnu_iconv_to_aix_iconv_codepage_map)) {
72 $out_charset_plain = $gnu_iconv_to_aix_iconv_codepage_map[strtolower($out_charset_plain)];
75 // Add transliteration argument again (exactly as specified by user) if used
76 // Build the output character set name that we will use
77 $out_charset = ($using_translit ? $out_charset_plain . substr($out_charset, $translit_search) : $out_charset_plain);
79 // NOTE: Transliteration not supported; we will use the "plain" output character set name
80 $out_charset = $out_charset_plain;
82 // Call iconv() with the possibly modified parameters
83 $result = iconv($in_charset, $out_charset, $str);
84 return $result;
85 } // end of the "PMA_aix_iconv_wrapper()" function