{extends file="$layouts_admin"}

{block name="content"}
    <div class="row">


        <div class="col-md-6">
            <div class="panel">
                <div class="panel-hdr">
                    <h2>{$_L['Localisation']}</h2>

                </div>
                <div class="panel-container">
                    <div class="panel-content">
                        <form role="form" name="localisation" method="post" action="{$_url}settings/lc-post/">


                            <div class="mb-3">
                                <label for="tzone">{$_L['Timezone']}</label>
                                <select name="tzone" class="form-control" id="tzone">
                                    {foreach $tlist as $value => $label}
                                        <option value="{$value}"
                                                {if $config['timezone'] eq $value}selected="selected" {/if}>{$label}</option>
                                    {/foreach}


                                </select>
                            </div>

                            <div class="mb-3">
                                <label for="country">{$_L['Default Country']}</label>
                                <select name="country" class="form-control" id="country">
                                    <option value="">{$_L['Select Country']}</option>
                                    {$countries}
                                </select>
                            </div>

                            <div class="mb-3">
                                <label for="df">{$_L['Date Format']}</label>
                                <select class="form-select" name="df" id="df">
                                    <option value="d/m/Y" {if $config['df'] eq 'd/m/Y'} selected="selected" {/if}>{date('d/m/Y')}</option>
                                    <option value="d.m.Y" {if $config['df'] eq 'd.m.Y'} selected="selected" {/if}>{date('d.m.Y')}</option>
                                    <option value="d-m-Y" {if $config['df'] eq 'd-m-Y'} selected="selected" {/if}>{date('d-m-Y')}</option>
                                    <option value="m/d/Y" {if $config['df'] eq 'm/d/Y'} selected="selected" {/if}>{date('m/d/Y')}</option>
                                    <option value="Y/m/d" {if $config['df'] eq 'Y/m/d'} selected="selected" {/if}>{date('Y/m/d')}</option>
                                    <option value="Y-m-d" {if $config['df'] eq 'Y-m-d'} selected="selected" {/if}>{date('Y-m-d')}</option>

                                </select>
                            </div>


                            <div class="mb-3">
                                <label for="lan">{$_L['Default_Language']}</label>
                                <select class="form-select" name="lan" id="lan">


                                    {foreach $languages as $language}
                                        <option value="{$language['iso_code']}" {if $config['language'] eq $language['iso_code']} selected="selected" {/if}>{$language['name']}</option>
                                    {/foreach}


                                </select>
                            </div>

                            <div class="mb-3">
                                <label for="cformat">{$_L['Currency Format']}</label>
                                <select class="form-select" name="cformat" id="cformat">
                                    <option value="1" {if ($config['dec_point'] eq '.') AND ($config['thousands_sep'] eq '')} selected="selected" {/if}>
                                        1234.56
                                    </option>
                                    <option value="2" {if ($config['dec_point'] eq '.') AND ($config['thousands_sep'] eq ',')} selected="selected" {/if}>
                                        1,234.56
                                    </option>
                                    <option value="3" {if ($config['dec_point'] eq ',') AND ($config['thousands_sep'] eq '')} selected="selected" {/if}>
                                        1234,56
                                    </option>
                                    <option value="4" {if ($config['dec_point'] eq ',') AND ($config['thousands_sep'] eq '.')} selected="selected" {/if}>
                                        1.234,56
                                    </option>
                                </select>
                            </div>


                            <div class="mb-3">
                                <label for="home_currency">{$_L['Home Currency']}</label>

                                <select name="home_currency" class="form-control" id="home_currency">

                                    {foreach $currencies as $key => $currency}

                                        <option data-symbol="{$currency['symbol']}" value="{$currency['code']}" {if ($config['home_currency'] eq $key)} selected="selected" {/if}>{$key} - {$currency['name']} [ {$currency['symbol']} ]</option>

                                    {/foreach}


                                </select>


                            </div>

                            <div class="mb-3">
                                <label for="currency_code">{$_L['Currency Symbol']}</label>
                                <input type="text" class="form-control" id="currency_code" name="currency_code"
                                       value="{$config['currency_code']}">
                                <span class="help-block">{$_L['Keep it blank if currency code']}</span>
                            </div>

                            <div class="mb-3">
                                <label for="currency_symbol_position">{$_L['Currency Symbol Position']}</label>
                                <select class="form-select" name="currency_symbol_position" id="currency_symbol_position">

                                    <option value="p" {if ($config['currency_symbol_position'] eq 'p')} selected="selected" {/if}>{$_L['Left']}</option>
                                    <option value="s" {if ($config['currency_symbol_position'] eq 's')} selected="selected" {/if}>{$_L['Right']}</option>




                                </select>
                            </div>

                            <div class="mb-3">
                                <label for="currency_decimal_digits">{$_L['Pads the decimal with zeros']}</label>
                                <select class="form-select" name="currency_decimal_digits" id="currency_decimal_digits">

                                    <option value="false" {if ($config['currency_decimal_digits'] eq 'false')} selected="selected" {/if}>{$_L['No']}</option>
                                    <option value="true" {if ($config['currency_decimal_digits'] eq 'true')} selected="selected" {/if}>{$_L['Yes']}</option>

                                </select>
                            </div>

                            <div class="mb-3">
                                <label for="thousand_separator_placement">{$_L['Thousand Separator Placement']}</label>
                                <select class="form-select" name="thousand_separator_placement" id="thousand_separator_placement">

                                    <option value="2" {if ($config['thousand_separator_placement'] eq '2')} selected="selected" {/if}>2 (e.g. - 22,22,22,333)</option>
                                    <option value="3" {if ($config['thousand_separator_placement'] eq '3')} selected="selected" {/if}>3 (e.g. - 333,333,333)</option>
                                    <option value="4" {if ($config['thousand_separator_placement'] eq '4')} selected="selected" {/if}>4 (e.g. - 4,4444,4444)</option>




                                </select>
                            </div>

                            <hr>

                            <div class="my-3">
                                <strong>{$_L['Decimal Places']}</strong>
                            </div>

                            <div class="mb-3">
                                <label for="decimal_places_products_and_services">{$_L['Products n Services']}</label>
                                <select class="form-select" id="decimal_places_products_and_services" name="decimal_places_products_and_services">
                                    <option value="default">{$_L['Default']}</option>
                                    <option value="0" {if isset($config['decimal_places_products_and_services']) && $config['decimal_places_products_and_services'] == 0} selected{/if}>0</option>
                                    <option value="1" {if isset($config['decimal_places_products_and_services']) && $config['decimal_places_products_and_services'] == 1} selected{/if}>1</option>
                                    <option value="2" {if isset($config['decimal_places_products_and_services']) && $config['decimal_places_products_and_services'] == 2} selected{/if}>2</option>
                                    <option value="3" {if isset($config['decimal_places_products_and_services']) && $config['decimal_places_products_and_services'] == 3} selected{/if}>3</option>
                                    <option value="4" {if isset($config['decimal_places_products_and_services']) && $config['decimal_places_products_and_services'] == 4} selected{/if}>4</option>
                                    <option value="5" {if isset($config['decimal_places_products_and_services']) && $config['decimal_places_products_and_services'] == 5} selected{/if}>5</option>
                                </select>
                            </div>


                            <button type="submit" class="btn btn-primary">{$_L['Submit']}</button>
                        </form>
                    </div>



                </div>
            </div>


        </div>

        <div class="col-md-6">
            <div class="panel">
                <div class="panel-hdr">
                    <h5>{$_L['Charset n Collation']}</h5>

                </div>
                <div class="panel-container">
                    <div class ="panel-content">
                        <form role="form" name="localisation" method="post" action="{$_url}settings/lc-charset-post">


                            <div class="mb-3">
                                <label for="coll">{$_L['Set Charset n Collation']}</label>
                                <select class="form-select" name="coll" id="coll">
                                    <option value=""></option>
                                    <optgroup label="armscii8" title="ARMSCII-8 Armenian">
                                        <option value="armscii8_bin"
                                                title="Armenian, Binary" {if $col eq 'armscii8_bin'} selected="selected" {/if}>
                                            armscii8_bin
                                        </option>
                                        <option value="armscii8_general_ci"
                                                title="Armenian, case-insensitive" {if $col eq 'armscii8_general_ci'} selected="selected" {/if}>
                                            armscii8_general_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="ascii" title="US ASCII">
                                        <option value="ascii_bin"
                                                title="West European (multilingual), Binary" {if $col eq 'ascii_bin'} selected="selected" {/if}>
                                            ascii_bin
                                        </option>
                                        <option value="ascii_general_ci"
                                                title="West European (multilingual), case-insensitive" {if $col eq 'ascii_general_ci'} selected="selected" {/if}>
                                            ascii_general_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="big5" title="Big5 Traditional Chinese">
                                        <option value="big5_bin"
                                                title="Traditional Chinese, Binary" {if $col eq 'big5_bin'} selected="selected" {/if}>
                                            big5_bin
                                        </option>
                                        <option value="big5_chinese_ci"
                                                title="Traditional Chinese, case-insensitive" {if $col eq 'big5_chinese_ci'} selected="selected" {/if}>
                                            big5_chinese_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="binary" title="Binary pseudo charset">
                                        <option value="binary" title="Binary" {if $col eq 'binary'} selected="selected" {/if}>
                                            binary
                                        </option>
                                    </optgroup>
                                    <optgroup label="cp1250" title="Windows Central European">
                                        <option value="cp1250_bin"
                                                title="Central European (multilingual), Binary" {if $col eq 'cp1250_bin'} selected="selected" {/if}>
                                            cp1250_bin
                                        </option>
                                        <option value="cp1250_croatian_ci"
                                                title="Croatian, case-insensitive" {if $col eq 'cp1250_croatian_ci'} selected="selected" {/if}>
                                            cp1250_croatian_ci
                                        </option>
                                        <option value="cp1250_czech_cs"
                                                title="Czech, case-sensitive" {if $col eq 'cp1250_czech_cs'} selected="selected" {/if}>
                                            cp1250_czech_cs
                                        </option>
                                        <option value="cp1250_general_ci"
                                                title="Central European (multilingual), case-insensitive" {if $col eq 'cp1250_general_ci'} selected="selected" {/if}>
                                            cp1250_general_ci
                                        </option>
                                        <option value="cp1250_polish_ci"
                                                title="Polish, case-insensitive" {if $col eq 'cp1250_polish_ci'} selected="selected" {/if}>
                                            cp1250_polish_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="cp1251" title="Windows Cyrillic">
                                        <option value="cp1251_bin"
                                                title="Cyrillic (multilingual), Binary" {if $col eq ''} selected="selected" {/if}>
                                            cp1251_bin
                                        </option>
                                        <option value="cp1251_bulgarian_ci"
                                                title="Bulgarian, case-insensitive" {if $col eq 'cp1251_bulgarian_ci'} selected="selected" {/if}>
                                            cp1251_bulgarian_ci
                                        </option>
                                        <option value="cp1251_general_ci"
                                                title="Cyrillic (multilingual), case-insensitive" {if $col eq 'cp1251_general_ci'} selected="selected" {/if}>
                                            cp1251_general_ci
                                        </option>
                                        <option value="cp1251_general_cs"
                                                title="Cyrillic (multilingual), case-sensitive {if $col eq 'cp1251_general_cs'} selected="
                                                selected
                                        " {/if}">
                                        cp1251_general_cs
                                        </option>
                                        <option value="cp1251_ukrainian_ci"
                                                title="Ukrainian, case-insensitive" {if $col eq 'cp1251_ukrainian_ci'} selected="selected" {/if}>
                                            cp1251_ukrainian_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="cp1256" title="Windows Arabic">
                                        <option value="cp1256_bin"
                                                title="Arabic, Binary" {if $col eq 'cp1256_bin'} selected="selected" {/if}>
                                            cp1256_bin
                                        </option>
                                        <option value="cp1256_general_ci"
                                                title="Arabic, case-insensitive" {if $col eq 'cp1256_general_ci'} selected="selected" {/if}>
                                            cp1256_general_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="cp1257" title="Windows Baltic">
                                        <option value="cp1257_bin"
                                                title="Baltic (multilingual), Binary" {if $col eq 'cp1257_bin'} selected="selected" {/if}>
                                            cp1257_bin
                                        </option>
                                        <option value="cp1257_general_ci"
                                                title="Baltic (multilingual), case-insensitive" {if $col eq 'cp1257_general_ci'} selected="selected" {/if}>
                                            cp1257_general_ci
                                        </option>
                                        <option value="cp1257_lithuanian_ci"
                                                title="Lithuanian, case-insensitive" {if $col eq 'cp1257_lithuanian_ci'} selected="selected" {/if}>
                                            cp1257_lithuanian_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="cp850" title="DOS West European">
                                        <option value="cp850_bin"
                                                title="West European (multilingual), Binary" {if $col eq 'cp850_bin'} selected="selected" {/if}>
                                            cp850_bin
                                        </option>
                                        <option value="cp850_general_ci"
                                                title="West European (multilingual), case-insensitive" {if $col eq 'cp850_general_ci'} selected="selected" {/if}>
                                            cp850_general_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="cp852" title="DOS Central European">
                                        <option value="cp852_bin"
                                                title="Central European (multilingual), Binary" {if $col eq 'cp852_bin'} selected="selected" {/if}>
                                            cp852_bin
                                        </option>
                                        <option value="cp852_general_ci"
                                                title="Central European (multilingual), case-insensitive" {if $col eq 'cp852_general_ci'} selected="selected" {/if}>
                                            cp852_general_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="cp866" title="DOS Russian">
                                        <option value="cp866_bin"
                                                title="Russian, Binary" {if $col eq 'cp866_bin'} selected="selected" {/if}>
                                            cp866_bin
                                        </option>
                                        <option value="cp866_general_ci"
                                                title="Russian, case-insensitive" {if $col eq 'cp866_general_ci'} selected="selected" {/if}>
                                            cp866_general_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="cp932" title="SJIS for Windows Japanese">
                                        <option value="cp932_bin"
                                                title="Japanese, Binary" {if $col eq 'cp932_bin'} selected="selected" {/if}>
                                            cp932_bin
                                        </option>
                                        <option value="cp932_japanese_ci"
                                                title="Japanese, case-insensitive" {if $col eq 'cp932_japanese_ci'} selected="selected" {/if}>
                                            cp932_japanese_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="dec8" title="DEC West European">
                                        <option value="dec8_bin"
                                                title="West European (multilingual), Binary" {if $col eq 'dec8_bin'} selected="selected" {/if}>
                                            dec8_bin
                                        </option>
                                        <option value="dec8_swedish_ci"
                                                title="Swedish, case-insensitive" {if $col eq 'dec8_swedish_ci'} selected="selected" {/if}>
                                            dec8_swedish_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="eucjpms" title="UJIS for Windows Japanese">
                                        <option value="eucjpms_bin"
                                                title="Japanese, Binary" {if $col eq 'eucjpms_bin'} selected="selected" {/if}>
                                            eucjpms_bin
                                        </option>
                                        <option value="eucjpms_japanese_ci"
                                                title="Japanese, case-insensitive" {if $col eq 'eucjpms_japanese_ci'} selected="selected" {/if}>
                                            eucjpms_japanese_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="euckr" title="EUC-KR Korean">
                                        <option value="euckr_bin"
                                                title="Korean, Binary" {if $col eq 'euckr_bin'} selected="selected" {/if}>
                                            euckr_bin
                                        </option>
                                        <option value="euckr_korean_ci"
                                                title="Korean, case-insensitive" {if $col eq 'euckr_korean_ci'} selected="selected" {/if}>
                                            euckr_korean_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="gb2312" title="GB2312 Simplified Chinese">
                                        <option value="gb2312_bin"
                                                title="Simplified Chinese, Binary" {if $col eq 'gb2312_bin'} selected="selected" {/if}>
                                            gb2312_bin
                                        </option>
                                        <option value="gb2312_chinese_ci"
                                                title="Simplified Chinese, case-insensitive" {if $col eq 'gb2312_chinese_ci'} selected="selected" {/if}>
                                            gb2312_chinese_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="gbk" title="GBK Simplified Chinese">
                                        <option value="gbk_bin"
                                                title="Simplified Chinese, Binary" {if $col eq 'gbk_bin'} selected="selected" {/if}>
                                            gbk_bin
                                        </option>
                                        <option value="gbk_chinese_ci"
                                                title="Simplified Chinese, case-insensitive" {if $col eq 'gbk_chinese_ci'} selected="selected" {/if}>
                                            gbk_chinese_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="geostd8" title="GEOSTD8 Georgian">
                                        <option value="geostd8_bin"
                                                title="Georgian, Binary" {if $col eq 'geostd8_bin'} selected="selected" {/if}>
                                            geostd8_bin
                                        </option>
                                        <option value="geostd8_general_ci"
                                                title="Georgian, case-insensitive" {if $col eq 'geostd8_general_ci'} selected="selected" {/if}>
                                            geostd8_general_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="greek" title="ISO 8859-7 Greek">
                                        <option value="greek_bin"
                                                title="Greek, Binary" {if $col eq 'greek_bin'} selected="selected" {/if}>
                                            greek_bin
                                        </option>
                                        <option value="greek_general_ci"
                                                title="Greek, case-insensitive" {if $col eq 'greek_general_ci'} selected="selected" {/if}>
                                            greek_general_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="hebrew" title="ISO 8859-8 Hebrew">
                                        <option value="hebrew_bin"
                                                title="Hebrew, Binary" {if $col eq 'hebrew_bin'} selected="selected" {/if}>
                                            hebrew_bin
                                        </option>
                                        <option value="hebrew_general_ci"
                                                title="Hebrew, case-insensitive" {if $col eq 'hebrew_general_ci'} selected="selected" {/if}>
                                            hebrew_general_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="hp8" title="HP West European">
                                        <option value="hp8_bin"
                                                title="West European (multilingual), Binary" {if $col eq 'hp8_bin'} selected="selected" {/if}>
                                            hp8_bin
                                        </option>
                                        <option value="hp8_english_ci"
                                                title="English, case-insensitive" {if $col eq 'hp8_english_ci'} selected="selected" {/if}>
                                            hp8_english_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="keybcs2" title="DOS Kamenicky Czech-Slovak">
                                        <option value="keybcs2_bin"
                                                title="Czech-Slovak, Binary" {if $col eq 'keybcs2_bin'} selected="selected" {/if}>
                                            keybcs2_bin
                                        </option>
                                        <option value="keybcs2_general_ci"
                                                title="Czech-Slovak, case-insensitive" {if $col eq 'keybcs2_general_ci'} selected="selected" {/if}>
                                            keybcs2_general_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="koi8r" title="KOI8-R Relcom Russian">
                                        <option value="koi8r_bin"
                                                title="Russian, Binary" {if $col eq 'koi8r_bin'} selected="selected" {/if}>
                                            koi8r_bin
                                        </option>
                                        <option value="koi8r_general_ci"
                                                title="Russian, case-insensitive" {if $col eq 'koi8r_general_ci'} selected="selected" {/if}>
                                            koi8r_general_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="koi8u" title="KOI8-U Ukrainian">
                                        <option value="koi8u_bin"
                                                title="Ukrainian, Binary" {if $col eq 'koi8u_bin'} selected="selected" {/if}>
                                            koi8u_bin
                                        </option>
                                        <option value="koi8u_general_ci"
                                                title="Ukrainian, case-insensitive" {if $col eq 'koi8u_general_ci'} selected="selected" {/if}>
                                            koi8u_general_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="latin1" title="cp1252 West European">
                                        <option value="latin1_bin"
                                                title="West European (multilingual), Binary" {if $col eq 'latin1_bin'} selected="selected" {/if}>
                                            latin1_bin
                                        </option>
                                        <option value="latin1_danish_ci"
                                                title="Danish, case-insensitive" {if $col eq 'latin1_danish_ci'} selected="selected" {/if}>
                                            latin1_danish_ci
                                        </option>
                                        <option value="latin1_general_ci"
                                                title="West European (multilingual), case-insensitive" {if $col eq 'latin1_general_ci'} selected="selected" {/if}>
                                            latin1_general_ci
                                        </option>
                                        <option value="latin1_general_cs"
                                                title="West European (multilingual), case-sensitive" {if $col eq 'latin1_general_cs'} selected="selected" {/if}>
                                            latin1_general_cs
                                        </option>
                                        <option value="latin1_german1_ci"
                                                title="German (dictionary), case-insensitive" {if $col eq 'latin1_german1_ci'} selected="selected" {/if}>
                                            latin1_german1_ci
                                        </option>
                                        <option value="latin1_german2_ci"
                                                title="German (phone book), case-insensitive" {if $col eq 'latin1_german2_ci'} selected="selected" {/if}>
                                            latin1_german2_ci
                                        </option>
                                        <option value="latin1_spanish_ci"
                                                title="Spanish, case-insensitive" {if $col eq 'latin1_spanish_ci'} selected="selected" {/if}>
                                            latin1_spanish_ci
                                        </option>
                                        <option value="latin1_swedish_ci"
                                                title="Swedish, case-insensitive" {if $col eq 'latin1_swedish_ci'} selected="selected" {/if}>
                                            latin1_swedish_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="latin2" title="ISO 8859-2 Central European">
                                        <option value="latin2_bin"
                                                title="Central European (multilingual), Binary" {if $col eq 'latin2_bin'} selected="selected" {/if}>
                                            latin2_bin
                                        </option>
                                        <option value="latin2_croatian_ci"
                                                title="Croatian, case-insensitive" {if $col eq 'latin2_croatian_ci'} selected="selected" {/if}>
                                            latin2_croatian_ci
                                        </option>
                                        <option value="latin2_czech_cs"
                                                title="Czech, case-sensitive" {if $col eq 'latin2_czech_cs'} selected="selected" {/if}>
                                            latin2_czech_cs
                                        </option>
                                        <option value="latin2_general_ci"
                                                title="Central European (multilingual), case-insensitive" {if $col eq 'latin2_general_ci'} selected="selected" {/if}>
                                            latin2_general_ci
                                        </option>
                                        <option value="latin2_hungarian_ci"
                                                title="Hungarian, case-insensitive" {if $col eq 'latin2_hungarian_ci'} selected="selected" {/if}>
                                            latin2_hungarian_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="latin5" title="ISO 8859-9 Turkish">
                                        <option value="latin5_bin"
                                                title="Turkish, Binary" {if $col eq 'latin5_bin'} selected="selected" {/if}>
                                            latin5_bin
                                        </option>
                                        <option value="latin5_turkish_ci"
                                                title="Turkish, case-insensitive" {if $col eq 'latin5_turkish_ci'} selected="selected" {/if}>
                                            latin5_turkish_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="latin7" title="ISO 8859-13 Baltic">
                                        <option value="latin7_bin"
                                                title="Baltic (multilingual), Binary" {if $col eq 'latin7_bin'} selected="selected" {/if}>
                                            latin7_bin
                                        </option>
                                        <option value="latin7_estonian_cs"
                                                title="Estonian, case-sensitive" {if $col eq 'latin7_general_ci'} selected="selected" {/if}>
                                            latin7_estonian_cs
                                        </option>
                                        <option value="latin7_general_ci"
                                                title="Baltic (multilingual), case-insensitive" {if $col eq 'latin7_general_ci'} selected="selected" {/if}>
                                            latin7_general_ci
                                        </option>
                                        <option value="latin7_general_cs"
                                                title="Baltic (multilingual), case-sensitive" {if $col eq 'latin7_general_cs'} selected="selected" {/if}>
                                            latin7_general_cs
                                        </option>


                                    </optgroup>
                                    <optgroup label="macce" title="Mac Central European">
                                        <option value="macce_bin"
                                                title="Central European (multilingual), Binary" {if $col eq 'macce_bin'} selected="selected" {/if}>
                                            macce_bin
                                        </option>
                                        <option value="macce_general_ci"
                                                title="Central European (multilingual), case-insensitive" {if $col eq 'macce_general_ci'} selected="selected" {/if}>
                                            macce_general_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="macroman" title="Mac West European">
                                        <option value="macroman_bin"
                                                title="West European (multilingual), Binary" {if $col eq 'macroman_bin'} selected="selected" {/if}>
                                            macroman_bin
                                        </option>
                                        <option value="macroman_general_ci"
                                                title="West European (multilingual), case-insensitive" {if $col eq 'macroman_general_ci'} selected="selected" {/if}>
                                            macroman_general_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="sjis" title="Shift-JIS Japanese">
                                        <option value="sjis_bin"
                                                title="Japanese, Binary" {if $col eq 'sjis_bin'} selected="selected" {/if}>
                                            sjis_bin
                                        </option>
                                        <option value="sjis_japanese_ci"
                                                title="Japanese, case-insensitive" {if $col eq 'sjis_japanese_ci'} selected="selected" {/if}>
                                            sjis_japanese_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="swe7" title="7bit Swedish">
                                        <option value="swe7_bin"
                                                title="Swedish, Binary" {if $col eq 'swe7_bin'} selected="selected" {/if}>
                                            swe7_bin
                                        </option>
                                        <option value="swe7_swedish_ci"
                                                title="Swedish, case-insensitive" {if $col eq 'swe7_swedish_ci'} selected="selected" {/if}>
                                            swe7_swedish_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="tis620" title="TIS620 Thai">
                                        <option value="tis620_bin" title="Thai, Binary">tis620_bin</option>
                                        <option value="tis620_thai_ci"
                                                title="Thai, case-insensitive" {if $col eq 'tis620_thai_ci'} selected="selected" {/if}>
                                            tis620_thai_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="ucs2" title="UCS-2 Unicode">
                                        <option value="ucs2_bin"
                                                title="Unicode (multilingual), Binary" {if $col eq 'ucs2_bin'} selected="selected" {/if}>
                                            ucs2_bin
                                        </option>
                                        <option value="ucs2_croatian_ci"
                                                title="Croatian, case-insensitive" {if $col eq 'ucs2_croatian_ci'} selected="selected" {/if}>
                                            ucs2_croatian_ci
                                        </option>
                                        <option value="ucs2_czech_ci"
                                                title="Czech, case-insensitive" {if $col eq 'ucs2_czech_ci'} selected="selected" {/if}>
                                            ucs2_czech_ci
                                        </option>
                                        <option value="ucs2_danish_ci"
                                                title="Danish, case-insensitive" {if $col eq 'ucs2_danish_ci'} selected="selected" {/if}>
                                            ucs2_danish_ci
                                        </option>
                                        <option value="ucs2_esperanto_ci"
                                                title="Esperanto, case-insensitive" {if $col eq 'ucs2_esperanto_ci'} selected="selected" {/if}>
                                            ucs2_esperanto_ci
                                        </option>
                                        <option value="ucs2_estonian_ci"
                                                title="Estonian, case-insensitive" {if $col eq 'ucs2_estonian_ci'} selected="selected" {/if}>
                                            ucs2_estonian_ci
                                        </option>
                                        <option value="ucs2_general_ci"
                                                title="Unicode (multilingual), case-insensitive" {if $col eq 'ucs2_general_ci'} selected="selected" {/if}>
                                            ucs2_general_ci
                                        </option>
                                        <option value="ucs2_general_mysql500_ci"
                                                title="Unicode (multilingual)" {if $col eq ''} selected="ucs2_general_mysql500_ci" {/if}>
                                            ucs2_general_mysql500_ci
                                        </option>
                                        <option value="ucs2_german2_ci"
                                                title="German (phone book), case-insensitive" {if $col eq 'ucs2_german2_ci'} selected="selected" {/if}>
                                            ucs2_german2_ci
                                        </option>
                                        <option value="ucs2_hungarian_ci"
                                                title="Hungarian, case-insensitive" {if $col eq 'ucs2_hungarian_ci'} selected="selected" {/if}>
                                            ucs2_hungarian_ci
                                        </option>
                                        <option value="ucs2_icelandic_ci"
                                                title="Icelandic, case-insensitive" {if $col eq 'ucs2_icelandic_ci'} selected="selected" {/if}>
                                            ucs2_icelandic_ci
                                        </option>
                                        <option value="ucs2_latvian_ci"
                                                title="Latvian, case-insensitive" {if $col eq 'ucs2_latvian_ci'} selected="selected" {/if}>
                                            ucs2_latvian_ci
                                        </option>
                                        <option value="ucs2_lithuanian_ci"
                                                title="Lithuanian, case-insensitive" {if $col eq 'ucs2_lithuanian_ci'} selected="selected" {/if}>
                                            ucs2_lithuanian_ci
                                        </option>
                                        <option value="ucs2_persian_ci"
                                                title="Persian, case-insensitive" {if $col eq 'ucs2_persian_ci'} selected="selected" {/if}>
                                            ucs2_persian_ci
                                        </option>
                                        <option value="ucs2_polish_ci"
                                                title="Polish, case-insensitive" {if $col eq ''} selected="selected" {/if}>
                                            ucs2_polish_ci
                                        </option>
                                        <option value="ucs2_roman_ci"
                                                title="West European, case-insensitive" {if $col eq 'ucs2_roman_ci'} selected="selected" {/if}>
                                            ucs2_roman_ci
                                        </option>
                                        <option value="ucs2_romanian_ci"
                                                title="Romanian, case-insensitive" {if $col eq 'ucs2_romanian_ci'} selected="selected" {/if}>
                                            ucs2_romanian_ci
                                        </option>
                                        <option value="ucs2_sinhala_ci"
                                                title="unknown, case-insensitive" {if $col eq 'ucs2_sinhala_ci'} selected="selected" {/if}>
                                            ucs2_sinhala_ci
                                        </option>
                                        <option value="ucs2_slovak_ci"
                                                title="Slovak, case-insensitive" {if $col eq 'ucs2_slovak_ci'} selected="selected" {/if}>
                                            ucs2_slovak_ci
                                        </option>
                                        <option value="ucs2_slovenian_ci"
                                                title="Slovenian, case-insensitive" {if $col eq 'ucs2_slovenian_ci'} selected="selected" {/if}>
                                            ucs2_slovenian_ci
                                        </option>
                                        <option value="ucs2_spanish2_ci"
                                                title="Traditional Spanish, case-insensitive" {if $col eq 'ucs2_spanish2_ci'} selected="selected" {/if}>
                                            ucs2_spanish2_ci
                                        </option>
                                        <option value="ucs2_spanish_ci"
                                                title="Spanish, case-insensitive" {if $col eq 'ucs2_spanish_ci'} selected="selected" {/if}>
                                            ucs2_spanish_ci
                                        </option>
                                        <option value="ucs2_swedish_ci"
                                                title="Swedish, case-insensitive" {if $col eq 'ucs2_swedish_ci'} selected="selected" {/if}>
                                            ucs2_swedish_ci
                                        </option>
                                        <option value="ucs2_turkish_ci"
                                                title="Turkish, case-insensitive" {if $col eq 'ucs2_turkish_ci'} selected="selected" {/if}>
                                            ucs2_turkish_ci
                                        </option>
                                        <option value="ucs2_unicode_520_ci"
                                                title="Unicode (multilingual)" {if $col eq 'ucs2_unicode_520_ci'} selected="selected" {/if}>
                                            ucs2_unicode_520_ci
                                        </option>
                                        <option value="ucs2_unicode_ci"
                                                title="Unicode (multilingual), case-insensitive" {if $col eq 'ucs2_unicode_ci'} selected="selected" {/if}>
                                            ucs2_unicode_ci
                                        </option>
                                        <option value="ucs2_vietnamese_ci"
                                                title="unknown, case-insensitive" {if $col eq 'ucs2_vietnamese_ci'} selected="selected" {/if}>
                                            ucs2_vietnamese_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="ujis" title="EUC-JP Japanese">
                                        <option value="ujis_bin"
                                                title="Japanese, Binary" {if $col eq 'ujis_bin'} selected="selected" {/if}>
                                            ujis_bin
                                        </option>
                                        <option value="ujis_japanese_ci"
                                                title="Japanese, case-insensitive" {if $col eq 'ujis_japanese_ci'} selected="selected" {/if}>
                                            ujis_japanese_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="utf16" title="UTF-16 Unicode">
                                        <option value="utf16_bin"
                                                title="unknown, Binary" {if $col eq 'utf16_bin'} selected="selected" {/if}>
                                            utf16_bin
                                        </option>
                                        <option value="utf16_croatian_ci"
                                                title="Croatian, case-insensitive" {if $col eq 'utf16_croatian_ci'} selected="selected" {/if}>
                                            utf16_croatian_ci
                                        </option>
                                        <option value="utf16_czech_ci"
                                                title="Czech, case-insensitive" {if $col eq ''} selected="selected" {/if}>
                                            utf16_czech_ci
                                        </option>
                                        <option value="utf16_danish_ci"
                                                title="Danish, case-insensitive" {if $col eq 'utf16_danish_ci'} selected="selected" {/if}>
                                            utf16_danish_ci
                                        </option>
                                        <option value="utf16_esperanto_ci"
                                                title="Esperanto, case-insensitive" {if $col eq 'utf16_esperanto_ci'} selected="selected" {/if}>
                                            utf16_esperanto_ci
                                        </option>
                                        <option value="utf16_estonian_ci"
                                                title="Estonian, case-insensitive" {if $col eq 'utf16_estonian_ci'} selected="selected" {/if}>
                                            utf16_estonian_ci
                                        </option>
                                        <option value="utf16_general_ci"
                                                title="unknown, case-insensitive" {if $col eq 'utf16_general_ci'} selected="selected" {/if}>
                                            utf16_general_ci
                                        </option>
                                        <option value="utf16_german2_ci"
                                                title="German (phone book), case-insensitive" {if $col eq 'utf16_german2_ci'} selected="selected" {/if}>
                                            utf16_german2_ci
                                        </option>
                                        <option value="utf16_hungarian_ci"
                                                title="Hungarian, case-insensitive" {if $col eq 'utf16_hungarian_ci'} selected="selected" {/if}>
                                            utf16_hungarian_ci
                                        </option>
                                        <option value="utf16_icelandic_ci"
                                                title="Icelandic, case-insensitive" {if $col eq 'utf16_icelandic_ci'} selected="selected" {/if}>
                                            utf16_icelandic_ci
                                        </option>
                                        <option value="utf16_latvian_ci"
                                                title="Latvian, case-insensitive" {if $col eq 'utf16_latvian_ci'} selected="selected" {/if}>
                                            utf16_latvian_ci
                                        </option>
                                        <option value="utf16_lithuanian_ci"
                                                title="Lithuanian, case-insensitive" {if $col eq 'utf16_lithuanian_ci'} selected="selected" {/if}>
                                            utf16_lithuanian_ci
                                        </option>
                                        <option value="utf16_persian_ci"
                                                title="Persian, case-insensitive" {if $col eq 'utf16_persian_ci'} selected="selected" {/if}>
                                            utf16_persian_ci
                                        </option>
                                        <option value="utf16_polish_ci"
                                                title="Polish, case-insensitive" {if $col eq 'utf16_polish_ci'} selected="selected" {/if}>
                                            utf16_polish_ci
                                        </option>
                                        <option value="utf16_roman_ci"
                                                title="West European, case-insensitive" {if $col eq 'utf16_roman_ci'} selected="selected" {/if}>
                                            utf16_roman_ci
                                        </option>
                                        <option value="utf16_romanian_ci"
                                                title="Romanian, case-insensitive" {if $col eq 'utf16_romanian_ci'} selected="selected" {/if}>
                                            utf16_romanian_ci
                                        </option>
                                        <option value="utf16_sinhala_ci"
                                                title="unknown, case-insensitive" {if $col eq 'utf16_sinhala_ci'} selected="selected" {/if}>
                                            utf16_sinhala_ci
                                        </option>
                                        <option value="utf16_slovak_ci"
                                                title="Slovak, case-insensitive" {if $col eq 'utf16_slovak_ci'} selected="selected" {/if}>
                                            utf16_slovak_ci
                                        </option>
                                        <option value="utf16_slovenian_ci"
                                                title="Slovenian, case-insensitive" {if $col eq 'utf16_slovenian_ci'} selected="selected" {/if}>
                                            utf16_slovenian_ci
                                        </option>
                                        <option value="utf16_spanish2_ci"
                                                title="Traditional Spanish, case-insensitive" {if $col eq 'utf16_spanish2_ci'} selected="selected" {/if}>
                                            utf16_spanish2_ci
                                        </option>
                                        <option value="utf16_spanish_ci"
                                                title="Spanish, case-insensitive" {if $col eq 'utf16_spanish_ci'} selected="selected" {/if}>
                                            utf16_spanish_ci
                                        </option>
                                        <option value="utf16_swedish_ci"
                                                title="Swedish, case-insensitive" {if $col eq 'utf16_swedish_ci'} selected="selected" {/if}>
                                            utf16_swedish_ci
                                        </option>
                                        <option value="utf16_turkish_ci"
                                                title="Turkish, case-insensitive" {if $col eq 'utf16_turkish_ci'} selected="selected" {/if}>
                                            utf16_turkish_ci
                                        </option>
                                        <option value="utf16_unicode_520_ci"
                                                title="Unicode (multilingual)" {if $col eq 'utf16_unicode_520_ci'} selected="selected" {/if}>
                                            utf16_unicode_520_ci
                                        </option>
                                        <option value="utf16_unicode_ci"
                                                title="Unicode (multilingual), case-insensitive" {if $col eq 'utf16_unicode_ci'} selected="selected" {/if}>
                                            utf16_unicode_ci
                                        </option>
                                        <option value="utf16_vietnamese_ci"
                                                title="unknown, case-insensitive" {if $col eq 'utf16_vietnamese_ci'} selected="selected" {/if}>
                                            utf16_vietnamese_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="utf16le" title="UTF-16LE Unicode">
                                        <option value="utf16le_bin" title="unknown, Binary">utf16le_bin</option>
                                        <option value="utf16le_general_ci"
                                                title="unknown, case-insensitive" {if $col eq 'utf16le_general_ci'} selected="selected" {/if}>
                                            utf16le_general_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="utf32" title="UTF-32 Unicode">
                                        <option value="utf32_bin" title="unknown, Binary">utf32_bin</option>
                                        <option value="utf32_croatian_ci"
                                                title="Croatian, case-insensitive" {if $col eq 'utf32_croatian_ci'} selected="selected" {/if}>
                                            utf32_croatian_ci
                                        </option>
                                        <option value="utf32_czech_ci"
                                                title="Czech, case-insensitive" {if $col eq 'utf32_czech_ci'} selected="selected" {/if}>
                                            utf32_czech_ci
                                        </option>
                                        <option value="utf32_danish_ci"
                                                title="Danish, case-insensitive" {if $col eq 'utf32_danish_ci'} selected="selected" {/if}>
                                            utf32_danish_ci
                                        </option>
                                        <option value="utf32_esperanto_ci"
                                                title="Esperanto, case-insensitive" {if $col eq 'utf32_esperanto_ci'} selected="selected" {/if}>
                                            utf32_esperanto_ci
                                        </option>
                                        <option value="utf32_estonian_ci"
                                                title="Estonian, case-insensitive" {if $col eq 'utf32_estonian_ci'} selected="selected" {/if}>
                                            utf32_estonian_ci
                                        </option>
                                        <option value="utf32_general_ci"
                                                title="unknown, case-insensitive" {if $col eq 'utf32_general_ci'} selected="selected" {/if}>
                                            utf32_general_ci
                                        </option>
                                        <option value="utf32_german2_ci"
                                                title="German (phone book), case-insensitive" {if $col eq 'utf32_german2_ci'} selected="selected" {/if}>
                                            utf32_german2_ci
                                        </option>
                                        <option value="utf32_hungarian_ci"
                                                title="Hungarian, case-insensitive" {if $col eq 'utf32_hungarian_ci'} selected="selected" {/if}>
                                            utf32_hungarian_ci
                                        </option>
                                        <option value="utf32_icelandic_ci"
                                                title="Icelandic, case-insensitive" {if $col eq 'utf32_icelandic_ci'} selected="selected" {/if}>
                                            utf32_icelandic_ci
                                        </option>
                                        <option value="utf32_latvian_ci"
                                                title="Latvian, case-insensitive" {if $col eq 'utf32_latvian_ci'} selected="selected" {/if}>
                                            utf32_latvian_ci
                                        </option>
                                        <option value="utf32_lithuanian_ci"
                                                title="Lithuanian, case-insensitive" {if $col eq 'utf32_lithuanian_ci'} selected="selected" {/if}>
                                            utf32_lithuanian_ci
                                        </option>
                                        <option value="utf32_persian_ci"
                                                title="Persian, case-insensitive" {if $col eq 'utf32_persian_ci'} selected="selected" {/if}>
                                            utf32_persian_ci
                                        </option>
                                        <option value="utf32_polish_ci"
                                                title="Polish, case-insensitive" {if $col eq 'utf32_polish_ci'} selected="selected" {/if}>
                                            utf32_polish_ci
                                        </option>
                                        <option value="utf32_roman_ci"
                                                title="West European, case-insensitive" {if $col eq 'utf32_roman_ci'} selected="selected" {/if}>
                                            utf32_roman_ci
                                        </option>
                                        <option value="utf32_romanian_ci"
                                                title="Romanian, case-insensitive" {if $col eq 'utf32_romanian_ci'} selected="selected" {/if}>
                                            utf32_romanian_ci
                                        </option>
                                        <option value="utf32_sinhala_ci"
                                                title="unknown, case-insensitive" {if $col eq 'utf32_sinhala_ci'} selected="selected" {/if}>
                                            utf32_sinhala_ci
                                        </option>
                                        <option value="utf32_slovak_ci"
                                                title="Slovak, case-insensitive" {if $col eq 'utf32_slovak_ci'} selected="selected" {/if}>
                                            utf32_slovak_ci
                                        </option>
                                        <option value="utf32_slovenian_ci"
                                                title="Slovenian, case-insensitive" {if $col eq 'utf32_slovenian_ci'} selected="selected" {/if}>
                                            utf32_slovenian_ci
                                        </option>
                                        <option value="utf32_spanish2_ci"
                                                title="Traditional Spanish, case-insensitive" {if $col eq 'utf32_spanish2_ci'} selected="selected" {/if}>
                                            utf32_spanish2_ci
                                        </option>
                                        <option value="utf32_spanish_ci"
                                                title="Spanish, case-insensitive" {if $col eq 'utf32_spanish_ci'} selected="selected" {/if}>
                                            utf32_spanish_ci
                                        </option>
                                        <option value="utf32_swedish_ci"
                                                title="Swedish, case-insensitive" {if $col eq 'utf32_swedish_ci'} selected="selected" {/if}>
                                            utf32_swedish_ci
                                        </option>
                                        <option value="utf32_turkish_ci"
                                                title="Turkish, case-insensitive" {if $col eq 'utf32_turkish_ci'} selected="selected" {/if}>
                                            utf32_turkish_ci
                                        </option>
                                        <option value="utf32_unicode_520_ci"
                                                title="Unicode (multilingual)" {if $col eq 'utf32_unicode_520_ci'} selected="selected" {/if}>
                                            utf32_unicode_520_ci
                                        </option>
                                        <option value="utf32_unicode_ci"
                                                title="Unicode (multilingual), case-insensitive" {if $col eq 'utf32_unicode_ci'} selected="selected" {/if}>
                                            utf32_unicode_ci
                                        </option>
                                        <option value="utf32_vietnamese_ci"
                                                title="unknown, case-insensitive" {if $col eq 'utf32_vietnamese_ci'} selected="selected" {/if}>
                                            utf32_vietnamese_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="utf8" title="UTF-8 Unicode">
                                        <option value="utf8_bin"
                                                title="Unicode (multilingual), Binary" {if $col eq 'utf8_bin'} selected="selected" {/if}>
                                            utf8_bin
                                        </option>
                                        <option value="utf8_croatian_ci"
                                                title="Croatian, case-insensitive" {if $col eq 'utf8_croatian_ci'} selected="selected" {/if}>
                                            utf8_croatian_ci
                                        </option>
                                        <option value="utf8_czech_ci"
                                                title="Czech, case-insensitive" {if $col eq 'utf8_czech_ci'} selected="selected" {/if}>
                                            utf8_czech_ci
                                        </option>
                                        <option value="utf8_danish_ci"
                                                title="Danish, case-insensitive" {if $col eq 'utf8_danish_ci'} selected="selected" {/if}>
                                            utf8_danish_ci
                                        </option>
                                        <option value="utf8_esperanto_ci"
                                                title="Esperanto, case-insensitive" {if $col eq 'utf8_esperanto_ci'} selected="selected" {/if}>
                                            utf8_esperanto_ci
                                        </option>
                                        <option value="utf8_estonian_ci"
                                                title="Estonian, case-insensitive" {if $col eq 'utf8_estonian_ci'} selected="selected" {/if}>
                                            utf8_estonian_ci
                                        </option>
                                        <option value="utf8_general_ci" title="Unicode (multilingual), case-insensitive"
                                                {if $col eq 'utf8_general_ci'} selected="selected" {/if}>utf8_general_ci
                                        </option>
                                        <option value="utf8_general_mysql500_ci"
                                                title="Unicode (multilingual)" {if $col eq 'utf8_general_mysql500_ci'} selected="selected" {/if}>
                                            utf8_general_mysql500_ci
                                        </option>
                                        <option value="utf8_german2_ci"
                                                title="German (phone book), case-insensitive" {if $col eq 'utf8_german2_ci'} selected="selected" {/if}>
                                            utf8_german2_ci
                                        </option>
                                        <option value="utf8_hungarian_ci"
                                                title="Hungarian, case-insensitive" {if $col eq 'utf8_hungarian_ci'} selected="selected" {/if}>
                                            utf8_hungarian_ci
                                        </option>
                                        <option value="utf8_icelandic_ci"
                                                title="Icelandic, case-insensitive" {if $col eq 'utf8_icelandic_ci'} selected="selected" {/if}>
                                            utf8_icelandic_ci
                                        </option>
                                        <option value="utf8_latvian_ci"
                                                title="Latvian, case-insensitive" {if $col eq 'utf8_latvian_ci'} selected="selected" {/if}>
                                            utf8_latvian_ci
                                        </option>
                                        <option value="utf8_lithuanian_ci"
                                                title="Lithuanian, case-insensitive" {if $col eq 'utf8_lithuanian_ci'} selected="selected" {/if}>
                                            utf8_lithuanian_ci
                                        </option>
                                        <option value="utf8_persian_ci"
                                                title="Persian, case-insensitive" {if $col eq 'utf8_persian_ci'} selected="selected" {/if}>
                                            utf8_persian_ci
                                        </option>
                                        <option value="utf8_polish_ci"
                                                title="Polish, case-insensitive" {if $col eq 'utf8_polish_ci'} selected="selected" {/if}>
                                            utf8_polish_ci
                                        </option>
                                        <option value="utf8_roman_ci"
                                                title="West European, case-insensitive" {if $col eq 'utf8_roman_ci'} selected="selected" {/if}>
                                            utf8_roman_ci
                                        </option>
                                        <option value="utf8_romanian_ci"
                                                title="Romanian, case-insensitive" {if $col eq 'utf8_romanian_ci'} selected="selected" {/if}>
                                            utf8_romanian_ci
                                        </option>
                                        <option value="utf8_sinhala_ci"
                                                title="unknown, case-insensitive" {if $col eq 'utf8_sinhala_ci'} selected="selected" {/if}>
                                            utf8_sinhala_ci
                                        </option>
                                        <option value="utf8_slovak_ci"
                                                title="Slovak, case-insensitive" {if $col eq 'utf8_slovak_ci'} selected="selected" {/if}>
                                            utf8_slovak_ci
                                        </option>
                                        <option value="utf8_slovenian_ci"
                                                title="Slovenian, case-insensitive" {if $col eq 'utf8_slovenian_ci'} selected="selected" {/if}>
                                            utf8_slovenian_ci
                                        </option>
                                        <option value="utf8_spanish2_ci"
                                                title="Traditional Spanish, case-insensitive" {if $col eq 'utf8_spanish2_ci'} selected="selected" {/if}>
                                            utf8_spanish2_ci
                                        </option>
                                        <option value="utf8_spanish_ci"
                                                title="Spanish, case-insensitive" {if $col eq 'utf8_spanish_ci'} selected="selected" {/if}>
                                            utf8_spanish_ci
                                        </option>
                                        <option value="utf8_swedish_ci"
                                                title="Swedish, case-insensitive" {if $col eq 'utf8_swedish_ci'} selected="selected" {/if}>
                                            utf8_swedish_ci
                                        </option>
                                        <option value="utf8_turkish_ci"
                                                title="Turkish, case-insensitive" {if $col eq 'utf8_turkish_ci'} selected="selected" {/if}>
                                            utf8_turkish_ci
                                        </option>
                                        <option value="utf8_unicode_520_ci"
                                                title="Unicode (multilingual)" {if $col eq 'utf8_unicode_520_ci'} selected="selected" {/if}>
                                            utf8_unicode_520_ci
                                        </option>
                                        <option value="utf8_unicode_ci"
                                                title="Unicode (multilingual), case-insensitive" {if $col eq 'utf8_unicode_ci'} selected="selected" {/if}>
                                            utf8_unicode_ci
                                        </option>
                                        <option value="utf8_vietnamese_ci"
                                                title="unknown, case-insensitive" {if $col eq 'utf8_vietnamese_ci'} selected="selected" {/if}>
                                            utf8_vietnamese_ci
                                        </option>
                                    </optgroup>
                                    <optgroup label="utf8mb4" title="UTF-8 Unicode">
                                        <option value="utf8mb4_bin"
                                                title="Unicode (multilingual), Binary" {if $col eq 'utf8mb4_bin'} selected="selected" {/if}>
                                            utf8mb4_bin
                                        </option>
                                        <option value="utf8mb4_croatian_ci"
                                                title="Croatian, case-insensitive" {if $col eq 'utf8mb4_croatian_ci'} selected="selected" {/if}>
                                            utf8mb4_croatian_ci
                                        </option>
                                        <option value="utf8mb4_czech_ci"
                                                title="Czech, case-insensitive" {if $col eq 'utf8mb4_czech_ci'} selected="selected" {/if}>
                                            utf8mb4_czech_ci
                                        </option>
                                        <option value="utf8mb4_danish_ci"
                                                title="Danish, case-insensitive" {if $col eq 'utf8mb4_danish_ci'} selected="selected" {/if}>
                                            utf8mb4_danish_ci
                                        </option>
                                        <option value="utf8mb4_esperanto_ci"
                                                title="Esperanto, case-insensitive" {if $col eq 'utf8mb4_esperanto_ci'} selected="selected" {/if}>
                                            utf8mb4_esperanto_ci
                                        </option>
                                        <option value="utf8mb4_estonian_ci"
                                                title="Estonian, case-insensitive" {if $col eq 'utf8mb4_estonian_ci'} selected="selected" {/if}>
                                            utf8mb4_estonian_ci
                                        </option>
                                        <option value="utf8mb4_general_ci"
                                                title="Unicode (multilingual), case-insensitive" {if $col eq 'utf8mb4_general_ci'} selected="selected" {/if}>
                                            utf8mb4_general_ci
                                        </option>
                                        <option value="utf8mb4_german2_ci"
                                                title="German (phone book), case-insensitive" {if $col eq 'utf8mb4_german2_ci'} selected="selected" {/if}>
                                            utf8mb4_german2_ci
                                        </option>
                                        <option value="utf8mb4_hungarian_ci"
                                                title="Hungarian, case-insensitive" {if $col eq 'utf8mb4_hungarian_ci'} selected="selected" {/if}>
                                            utf8mb4_hungarian_ci
                                        </option>
                                        <option value="utf8mb4_icelandic_ci"
                                                title="Icelandic, case-insensitive" {if $col eq 'utf8mb4_icelandic_ci'} selected="selected" {/if}>
                                            utf8mb4_icelandic_ci
                                        </option>
                                        <option value="utf8mb4_latvian_ci"
                                                title="Latvian, case-insensitive" {if $col eq 'utf8mb4_latvian_ci'} selected="selected" {/if}>
                                            utf8mb4_latvian_ci
                                        </option>
                                        <option value="utf8mb4_lithuanian_ci"
                                                title="Lithuanian, case-insensitive" {if $col eq 'utf8mb4_lithuanian_ci'} selected="selected" {/if}>
                                            utf8mb4_lithuanian_ci
                                        </option>
                                        <option value="utf8mb4_persian_ci"
                                                title="Persian, case-insensitive" {if $col eq 'utf8mb4_persian_ci'} selected="selected" {/if}>
                                            utf8mb4_persian_ci
                                        </option>
                                        <option value="utf8mb4_polish_ci"
                                                title="Polish, case-insensitive" {if $col eq ''} selected="selected" {/if}>
                                            utf8mb4_polish_ci
                                        </option>
                                        <option value="utf8mb4_roman_ci"
                                                title="West European, case-insensitive" {if $col eq 'utf8mb4_roman_ci'} selected="selected" {/if}>
                                            utf8mb4_roman_ci
                                        </option>
                                        <option value="utf8mb4_romanian_ci"
                                                title="Romanian, case-insensitive" {if $col eq 'utf8mb4_romanian_ci'} selected="selected" {/if}>
                                            utf8mb4_romanian_ci
                                        </option>
                                        <option value="utf8mb4_sinhala_ci"
                                                title="unknown, case-insensitive" {if $col eq 'utf8mb4_sinhala_ci'} selected="selected" {/if}>
                                            utf8mb4_sinhala_ci
                                        </option>
                                        <option value="utf8mb4_slovak_ci"
                                                title="Slovak, case-insensitive" {if $col eq ''} selected="selected" {/if}>
                                            utf8mb4_slovak_ci
                                        </option>
                                        <option value="utf8mb4_slovenian_ci"
                                                title="Slovenian, case-insensitive" {if $col eq 'utf8mb4_slovenian_ci'} selected="selected" {/if}>
                                            utf8mb4_slovenian_ci
                                        </option>
                                        <option value="utf8mb4_spanish2_ci"
                                                title="Traditional Spanish, case-insensitive" {if $col eq 'utf8mb4_spanish2_ci'} selected="selected" {/if}>
                                            utf8mb4_spanish2_ci
                                        </option>
                                        <option value="utf8mb4_spanish_ci"
                                                title="Spanish, case-insensitive" {if $col eq 'utf8mb4_spanish_ci'} selected="selected" {/if}>
                                            utf8mb4_spanish_ci
                                        </option>
                                        <option value="utf8mb4_swedish_ci"
                                                title="Swedish, case-insensitive" {if $col eq 'utf8mb4_swedish_ci'} selected="selected" {/if}>
                                            utf8mb4_swedish_ci
                                        </option>
                                        <option value="utf8mb4_turkish_ci"
                                                title="Turkish, case-insensitive" {if $col eq 'utf8mb4_turkish_ci'} selected="selected" {/if}>
                                            utf8mb4_turkish_ci
                                        </option>
                                        <option value="utf8mb4_unicode_520_ci"
                                                title="Unicode (multilingual)" {if $col eq 'utf8mb4_unicode_520_ci'} selected="selected" {/if}>
                                            utf8mb4_unicode_520_ci
                                        </option>
                                        <option value="utf8mb4_unicode_ci"
                                                title="Unicode (multilingual), case-insensitive" {if $col eq 'utf8mb4_unicode_ci'} selected="selected" {/if}>
                                            utf8mb4_unicode_ci
                                        </option>
                                        <option value="utf8mb4_vietnamese_ci"
                                                title="unknown, case-insensitive" {if $col eq 'utf8mb4_vietnamese_ci'} selected="selected" {/if}>
                                            utf8mb4_vietnamese_ci
                                        </option>
                                    </optgroup>
                                </select>
                            </div>


                            <button type="submit" class="btn btn-primary"> {$_L['Submit']}</button>
                        </form>

                    </div>



                </div>
            </div>


        </div>

    </div>
{/block}

{block name="script"}
    <script>
        $(function () {

            var $home_currency = $("#home_currency");

            $("#tzone").select2();
            $("#country").select2();
            $home_currency.select2();
            $("#lan").select2();
            $("#df").select2();
            $("#cformat").select2();
            $("#coll").select2();
            $("#currency_symbol_position").select2();


            var $currency_code = $("#currency_code");


            var data_symbol = "";

            $home_currency.change(function(){

                data_symbol = $(this).find(':selected').data('symbol');

                $currency_code.val(data_symbol);



            });



        });
    </script>
{/block}
