…÷˜®˜[T‹Íª#Ènú$Ñ;¯<á:˜êa–4Òs¶‡­XŸ¦í[·òÀ£”ïÐÔ‹ »6F1f=V“V‡=E¥žèäÆ7§û©Õ*Ù¿#Õ×d¦ÚjñZÆ§‡>ß1?,šîŠ¬äÚ<Äæ®mý,õ¥ÅÂöißìþ^…dF‡äïLöÿ2ð–Ù3*.áúNÓ&AÃê}æžqZM\š¿ŽÎâÛ5ÄQ¨PÄ|”†Qc,„âNÉ«ø½²é<Å–Elž<í½ñÒ2º‘máAt«”(Þâô.ó‚ÿü­ïzšh¾óÛEö±iÒÒdCÂIº!È-‹´ºƒ`.¯>¬
ŸÔl2‹ÛYáÖ½l®Èá3ÜG<Áf™Í*ýÂðÖ‡¸1šýd/×iÛ®h¶-]²ÑÊ`b÷‹!*Ð6O—¯|ªÎj¯ð
îª€2Ö·;}\[J*Êª‚½8¹ÎDŽ´ÜÏ{ó7ë;†œõ¡>ÈÈjWi¥ë3ÐßÉ}ã½å¿0%QõÛ¦:g‚É©xk^qæ8B5d(Ý‡kŒý2‚¤ØÐ®À¹ÍvK`›´«WMO$Ú!’0!¶Œ·¨|ÐU@H™º‚¾f$¨¼ÌúóÐ(ü™¨|¡<¹ƒÍ,žù&(8"nm 0Í×ªæÿ•nnA£2%C°0h;ÏÙ|EžÜuVÃó¦ßùl R`×=-Ìhô>Ú$¢¯/ökaÓ JÌŒïSüªÌdMÎ@ˆÜº›Ó¬µ™­¢ëÃÕöçtl@íMLàm½n[jÈº*c÷÷ÆÝ˜)Ã„¢Ž™ÎtYû!vòöItðÖ£+è´~F0ß(>¨ðÚú^J¤•\Y’lŽŠ6?HWMY÷,²Ú’VŽZø\œÄ=ÓwÓÖ	’i¿·Uõ‚ 'i…c¥z4	ŒÚÆ›J—ÖÏ*ôK¥01ÀIšÄ$ñ“ö`t¹îh5ó¼4€³Ac%ÎÙþénÊ¬;DqšøT’l›L±¤Ï[ù®Œ:V$†‘ÿª¸Îif³x©"/ý…È”]-Ò–Í—X‡—ÖÏ*ôK¥01ÀIšÄ$ñŠ'ðµ™™ØRÏ/<·,}Ú€ßrâ¡z¶ý1@Ã—{Îî|6*wzpÑMådí3†ãúÏÔåæÜû!É¤Ût,¸Ï÷®EŸ[¦§´›k=€ìËOQ‘¼¹n€f=,(ìdÂPÐ/Àyý7]ðçÈ:\C\$;$‰ÜóålTÆ£¬Zì—g¸EIÃx®ƒ˜3+t˜Aª‘r8D´Ç‹v'¯2’Š€Õ–ûø~$*€rŒ.·)Wa@O]% ŽP¯¬¼lü¬ê–}UÆ¹n¯ôº¼Ë;íîgñAUoe¸¬PVw°£Õ$xÜ¡6¤OOL‰rpé;¸`á•j4›ÃOÐ2?\%•˜=|Ì¤Ý£îê½ð±¤ëêëU°J¹·ó&y·FnR#ú.U»7A«¢ŸâÂ´´’œÄ¯Î£‘y»Éd ˆÖ‰k4»jÐMùP6 ¡dÎjÍ ¡]…’ãU—dY[²~;	Þƒœ%¶ ²á)ÓsSOödJšÙO•·NGÙÄ$¼Æìüd`öo8"·xxsñ«‰°HºB‰¬*BVéœ…¦Y(4±a@Õœê³q‘ºøÙZç—Lyþ¤…?
)ùŽq²ºæÛ`›«þÀÈòˆ¶RToÍµæ´U;½ã÷§l¹{& ÔóàLŒP]ŸB:KíjÈJ¡­6ÖEÁª½?˜Ð>WS¢O¯…¤§åòP6D‹ëûñø·ÅíÍKeššfYR¯›áÌgk‰Ã‰Ëj.'™‚|M(y´k2ï-ûÖY¥Òè€ýÇhP‹§êvLõ&æVû¢œÊU ‚/— ðVýb*Ð÷Â¯Yë=oˆqL9;nÖåÑcE‘)åˆñßöŒ~@>Š8lHŒ¢Qpnxå•W3 _K)o¾	R¶H*z«|ADúñ[(Øõ<¶ÅjˆœÌÎ›ê—=xéÄ !+Þ[»ÈqvGº÷=†)„e<)3#òÞeŸ|wÂä„HæðšO.ënA­Û·sp§û…}C’[ÔZXçdIvKÁlØ&)&xMqßäVœ:-àÄJÁµ˜=sÎd,Û‹%ØFÂÝ`üƒåN¿:Qaû¶Vép¦|tÖûtŒkK‡*Ðe‡ñÀqOSím”µâ\ç_É
lÕºå¬–Á>hO“5…U^í„Lý ¦g5PÈOæí3“ý¿jÎÖ8¼/Ékx=ÓÝziŒ¼8¶«Hodbh‹|}¹ž$¯PGhwtê^pÑb}Msè­ÒžÙÉ÷1ýöªåµ&Å±ÂR’L++ ×l7Ð•q]KÙM´äí™‡ËçÉmïÀí”ÆÚ¹¥âŠI'qG÷ž¤nãÃo<ó;¤hµANŸ…ÀÒ#N~f:µGj™	vvX=2O¶\<ŽÄÞi4+ô1:,ÞŽˆ á¿‡`½0£Y¤
·¼·’ozX¡ iTß`Ì—lÇkïgâmÉPJYŸR¼~{òDECºþÓÎE°lu+õ«vê~(Ù|áÖ)$ Ëméµ“ol_~x×—çø|ÝêÓ¥y[z‘•ÑÎw.ð6nžöNÉÀ.’4ö‡ÝR¡ªjþA°öÎøcG+R÷ÙxÚ¤Ý@èï…ä)ÝD«ý"Ü…kªzi,Û‹%ØFÂÝ`üƒåN¿:Qßôl¾zðTE’£2p°=Á‹ÔË‡Lº§°nêÒÂ™»€aÎ	± 2#Ðûzi”»£€’=Ç­úkYûBHäÐ=§ùËÙ–¸fÌyº;ñ.ÌòæY
AýøvæÙÒ¼‚^Ùûð•ñ]»ÒwåUÌœ{¥g*Øý+Ã‡œ£ ÎÙl(¬*iíwb“¾;
ò×zÿƒöÿa”›ËiÐ,9ÿzágÝ7¯ðéÆŽ5´9ïë"t†Y€1Dà¥öM°ÛW8ŒLáµ/nÅe,'a1NêïBÝ'F£soõõ3‘™±ÐÔG´‡œln‡j$¼$f¨\Wt“E»BG«ÏòÙÃÊ`é%&Å±àZÊ¾üDr´P¸ÐE‹ÞvßÊ L5©0ZÞ¶edôCÌ¿«ýÑàÔÏ‚¯ÐÒïò¢¹¢UÐÅ?•_õÔ¡ÌL0Pò)‹MB€üp^«´¿6Oìâ[–%»¤æÝ‡ä±¾¨¯E»BG«ÏòÙÃÊ`é%&Å~6‚¢Ñ(O`_E]™ïí¶É4IÀ’Ÿ+	•¿@£šš¨vùX;›Ÿ%19¥Ý1‡Ú©+ü²£TfÍæ‰åÝDÑÛÆýxè=>âeðäÝo¡FMðÍ÷^·/dàÊNÆÚM$§„²ïlhOžy»vUÜeïÅŸªÕÿmÖŒÜ.R®Æ/SscÛ¨MÃî‰ö£…uÜnX YÁE»BG«ÏòÙÃÊ`é%&ÅdDóÍ kclo|v²yåAŽÞ7…¹ô5‡äœÃ}­8Ù³+SMüfR‰i$¦&íµ:²ƒ–#¤ú ˜â’‰7äÑñ›…%Ù’ÇªQ¹nT‰7˜©<
tÁýH lÆ4@…§È–m–ß’Œ2 ŸjwÅøIÔ¯—Dœl}uì/xrpµþ,˜ûË=¬R|ìíµ:²ƒ–#¤ú ˜â’‰7‡ZiÑ!r[]°TÖ¦BHä¿v:am7þÆ›Hñ°²˜¤˜pÁÀ˜wí'(u'MœUnë¿8L4½7aWð1ŸnáuQÀåfdhÛˆƒ,íµ:²ƒ–#¤ú ˜â’‰7V%>¸VÍ_þÂ–FÇRïÙñ}ES)®rÖ5Œ,2»T˜R‹ô~áâLH­d:Ë")VÓe‰m’ˆ¶V iÅ½@-X+C“…»½FÚ›Öê¯Bë[ÃßãƒÈÐNâÌ³¨¨Ç…;NDˆ"\E¸¢¶¸X³HÝeï¶²Þ–¢²Ž0ÜÅµÕí,2»T˜R‹ô~áâLòø6N‰‹L†Î¦Û±ê’H+(—ïieEølùAo´0Dºtn½z›3¯aÛÞ=Úr‰çvÙ˜¡ÛÚýªGî4ÜùÈ•ÞÈÊµ>L5…QÄdŸ(¯7Ñ#Ó$*€rŒ.·)Wa@O]%õã¾ÔóÔyw7 JÍ±dÝcË…ãI§ú›a½÷B¸	äj9Ð[)lÏÍó
Ž½ä'Boªdàâd²Š‚^|ÃËaÙÙêM®¯@_^G™VKŸ¼‰Ÿ=ð\ky˜¤˜pÁÀ˜wí'(u'M©:Âo‹\”¦éÜÔØGF¹s$Ï{œ>ñN&Ì\íµ:²ƒ–#¤ú ˜â’‰7®-Ä²Í)Ä¶É¤ÛHC
—yáÕ1U`sÄÐi¡$*€rŒ.·)Wa@O]%¼÷ æ‰Ö–#iƒTèN{2‚J‚-{ª»Ò-ÊNÆÚM$§„²ïlhOžãDô“q ¥¸\w¯è ÿ÷úÑw3UŸÀï€ÓÈ$*€rŒ.·)Wa@O]%ºñŽ~7Öo5ÐÕd a4Þ5­Qÿ&¼ÍžbÑpŠ]²ÒÊNÆÚM$§„²ïlhOžPÌßô„á½m°1BÔr•_¸“>1k%=½Ny… «‚vf(m® ÔbŸŸ.¸ÿ,ò¤a>’|\c¨wã l
5=Iªç–"4q›ÿ`Ñ=¢¾B­NTžÒÖÊ‘íþ‘P—e
ÑFˆà8óª¬/¾³Ï«ùï§@­™%åiAvì-Ä€:p¼yžœú#ƒÛsŒmÐËÌÊfç¦îo°ß“¯È¶&öD7óéìâ¯aÛÞ=Úr‰çvÙ˜¡ÛÚý™é"izîçµî¿¨‘˜`Y³±ˆýúË‰ê8¾,¶j@…§È–m–ß’Œ2 ŸjõÔzèiïù_Ü-YEµÔgb*"iSVVÃËa3¯
HÝ
Í8y}”á+öA?Ð.H²uR»‚Î‚(WçF˜'ë’éBp$þú»:g'Åÿ
×
@vÓrì·j3¯aÛÞ=Úr‰çvÙ˜¡ÛÚýÜôÖd&þ(çÁ–Ub‚ª¥¿Vÿ¢ÓììÕ~œXÿøeŽP€Ö{s´|¤¯˜Ï›&¨§ßO—+|Ù4»ß›ÓpžPíŸ ?˜x-ÑøîæNTžÒÖÊ‘íþ‘P—erQi‰bq¸ÝmGö'z¼_Jh§ç–Ò|lŸ–’|@…§È–m–ß’Œ2 Ÿj§’¯ÝÑä˜¶‰{ÙTÒO˜ùì/§!•JÙð[tilingual)'),
            array('ucs2', 'Unicode (multilingual)'),
            array('utf8', 'Unicode (multilingual)'),
            array('ascii', 'West European (multilingual)'),
            array('cp850', 'West European (multilingual)'),
            array('dec8', 'West European (multilingual)'),
            array('hp8', 'West European (multilingual)'),
            array('latin1', 'West European (multilingual)'),
            array('cp1250', 'Central European (multilingual)'),
            array('cp852', 'Central European (multilingual)'),
            array('latin2', 'Central European (multilingual)'),
            array('macce', 'Central European (multilingual)'),
            array('cp866', 'Russian'),
            array('koi8r', 'Russian'),
            array('gb2312', 'Simplified Chinese'),
            array('gbk', 'Simplified Chinese'),
            array('sjis', 'Japanese'),
            array('ujis', 'Japanese'),
            array('cp932', 'Japanese'),
            array('eucjpms', 'Japanese'),
            array('cp1257', 'Baltic (multilingual)'),
            array('latin7', 'Baltic (multilingual)'),
            array('armscii8', 'Armenian'),
            array('armscii', 'Armenian'),
            array('big5', 'Traditional Chinese'),
            array('cp1251', 'Cyrillic (multilingual)'),
            array('cp1256', 'Arabic'),
            array('euckr', 'Korean'),
            array('hebrew', 'Hebrew'),
            array('geostd8', 'Georgian'),
            array('greek', 'Greek'),
            array('keybcs2', 'Czech-Slovak'),
            array('koi8u', 'Ukrainian'),
            array('latin5', 'Turkish'),
            array('swe7', 'Swedish'),
            array('tis620', 'Thai'),
            array('foobar', 'unknown'),
            array('foo_test_bar', 'unknown'),
            array('foo_bin_bar', 'unknown, Binary')
        );
    }

    /**
     * Test for PMA_generateCharsetDropdownBox
     *
     * @return void
     * @test
     */
    public function testGenerateCharsetDropdownBox()
    {
        $GLOBALS['mysql_charsets'] = array('latin1', 'latin2', 'latin3');
        $GLOBALS['mysql_charsets_available'] = array(
            'latin1' => true,
            'latin2' => false,
            'latin3' => true
        );
        $GLOBALS['mysql_charsets_descriptions'] = array(
            'latin1' => 'abc',
            'latin2' => 'def'
        );
        $GLOBALS['mysql_collations'] = array(
            'latin1' => array(
                'latin1_german1_ci',
                'latin1_swedish1_ci'
            ),
            'latin2' => array('latin1_general_ci'),
            'latin3' => array()
        );
        $GLOBALS['mysql_collations_available'] = array(
             'latin1_german1_ci' => true,
             'latin1_swedish1_ci' => false,
             'latin2_general_ci' => true
        );
        $result = PMA_generateCharsetDropdownBox();

        $this->assertContains('name="collation"', $result);
        $this->assertNotContains('id="', $result);
        $this->assertNotContains('class="autosubmit"', $result);
        $this->assertContains('<option value="">Collation', $result);
        $this->assertContains('<option value=""></option>', $result);
        $this->assertContains('<optgroup label="latin1', $result);
        $this->assertNotContains('<optgroup label="latin2', $result);
        $this->assertContains('title="latin3', $result);
        $this->assertContains('title="abc', $result);
        $this->assertNotContains('value="latin1_swedish1_ci"', $result);
        $this->assertContains('value="latin1_german1_ci"', $result);
        $this->assertNotContains('value="latin2_general1_ci"', $result);
        $this->assertContains('title="German', $result);

        $result = PMA_generateCharsetDropdownBox(
            2, null, "test_id", "latin1", false, true
        );
        $this->assertContains('name="character_set"', $result);
        $this->assertNotContains('Charset</option>', $result);
        $this->assertContains('class="autosubmit"', $result);
        $this->assertContains('id="test_id"', $result);
        $this->assertContains('selected="selected">latin1', $result);
    }

    /**
     * Test for PMA_getServerCollation
     *
     * @return void
     * @test
     */
    public function testGetServerCollation()
    {
        $GLOBALS['server'] = 1;
        $GLOBALS['cfg']['DBG']['sql'] = false;
        $this->assertEquals('utf8_general_ci', PMA_getServerCollation());
    }
}