{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="{$key}" {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}
