Hello Bill,
thank you for contribution!
We need to do some changes before we can add it into the sources,.
The problem is that cp500 is a separate character set, it is not
a collation for latin1. Thus, you should not add it into latin1.xml.
It should be as a separate file, with Unicode/Upper/Lower mapping.
You can use latin1.xml as an example.
Thank you!
Bill Maidment wrote:
> Guys
>
> I hope this is the right place to post this. I have created a new
> collation sequence (latin1_cp500_ci) for the EBCDIC collation sequence
> used in IBM and compatible mainframes. I use this to simulate an IBM
> mainframe COBOL database. I have attached Index.xml and latin1.xml from
> the 4.1.10 release (/usr/share/mysql/charsets directory), suitably
> amended. I have had a few people ask me for these additions and they
> report that they work. Can you please add them to the standard releases.
>
> Regards
> Bill
>
>
> ------------------------------------------------------------------------
>
> <?xml version='1.0' encoding="utf-8"?>
>
> <charsets max-id="95">
>
> <copyright>
> Copyright (C) 2003 MySQL AB
>
> This program is free software; you can redistribute it and/or modify
> it under the terms of the GNU General Public License as published by
> the Free Software Foundation; either version 2 of the License, or
> (at your option) any later version.
>
> This program is distributed in the hope that it will be useful,
> but WITHOUT ANY WARRANTY; without even the implied warranty of
> MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
> GNU General Public License for more details.
>
> You should have received a copy of the GNU General Public License
> along with this program; if not, write to the Free Software
> Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
> </copyright>
>
> <description>
> This file lists all of the available character sets.
> To make maintaining easier please:
> - keep records sorted by collation number.
> - change charsets.max-id when adding a new collation.
> </description>
>
> <charset name="big5">
> <family>Traditional Chinese</family>
> <description>Big5 Traditional Chinese</description>
> <alias>big-5</alias>
> <alias>bigfive</alias>
> <alias>big-five</alias>
> <alias>cn-big5</alias>
> <alias>csbig5</alias>
> <collation name="big5_chinese_ci" id="1" order="Chinese">
> <flag>primary</flag>
> <flag>compiled</flag>
> </collation>
> <collation name="big5_bin" id="84" order="Binary">
> <flag>binary</flag>
> <flag>compiled</flag>
> </collation>
> </charset>
>
> <charset name="latin2">
> <family>Central European</family>
> <description>ISO 8859-2 Central European</description>
> <alias>csisolatin2</alias>
> <alias>iso-8859-2</alias>
> <alias>iso-ir-101</alias>
> <alias>iso_8859-2</alias>
> <alias>iso_8859-2:1987</alias>
> <alias>l2</alias>
> <collation name="latin2_czech_cs" id="2" order="Czech" flag="compiled"/>
> <collation name="latin2_general_ci" id="9" flag="primary">
> <order>Hungarian</order>
> <order>Polish</order>
> <order>Romanian</order>
> <order>Croatian</order>
> <order>Slovak</order>
> <order>Slovenian</order>
> <order>Sorbian</order>
> </collation>
> <collation name="latin2_hungarian_ci" id="21" order="Hungarian"/>
> <collation name="latin2_croatian_ci" id="27" order="Croatian"/>
> <collation name="latin2_bin" id="77" order="Binary" flag="binary"/>
> </charset>
>
> <charset name="dec8">
> <family>Western</family>
> <description>DEC West European</description>
> <collation name="dec8_bin" id="69" order="Binary" flag="binary"/>
> <collation name="dec8_swedish_ci" id="3" flag="primary">
> <order>Dutch</order>
> <order>English</order>
> <order>French</order>
> <order>German Duden</order>
> <order>Italian</order>
> <order>Latin</order>
> <order>Portuguese</order>
> <order>Spanish</order>
> </collation>
> </charset>
>
> <charset name="cp850">
> <family>Western</family>
> <description>DOS West European</description>
> <alias>850</alias>
> <alias>cspc850multilingual</alias>
> <alias>ibm850</alias>
> <collation name="cp850_general_ci" id="4" flag="primary">
> <order>Dutch</order>
> <order>English</order>
> <order>French</order>
> <order>German Duden</order>
> <order>Italian</order>
> <order>Latin</order>
> <order>Portuguese</order>
> <order>Spanish</order>
> </collation>
> <collation name="cp850_bin" id="80" order="Binary" flag="binary"/>
> </charset>
>
> <charset name="latin1">
> <family>Western</family>
> <description>ISO 8859-1 West European</description>
> <alias>csisolatin1</alias>
> <alias>iso-8859-1</alias>
> <alias>iso-ir-100</alias>
> <alias>iso_8859-1</alias>
> <alias>iso_8859-1:1987</alias>
> <alias>l1</alias>
> <alias>latin1</alias>
> <collation name="latin1_german1_ci" id="5" order="German Duden"/>
> <collation name="latin1_swedish_ci" id="8" order="Finnish,
> Swedish" flag="primary"/>
> <collation name="latin1_danish_ci" id="15" order="Danish"/>
> <collation name="latin1_german2_ci" id="31" order="German
> Phonebook" flag="compiled"/>
> <collation name="latin1_spanish_ci" id="94" order="Spanish"/>
> <collation name="latin1_bin" id="47" order="Binary">
> <flag>binary</flag>
> <flag>compiled</flag>
> </collation>
> <collation name="latin1_general_ci" id="48">
> <order>Dutch</order>
> <order>English</order>
> <order>French</order>
> <order>German Duden</order>
> <order>Italian</order>
> <order>Latin</order>
> <order>Portuguese</order>
> <order>Spanish</order>
> </collation>
> <collation name="latin1_general_cs" id="49">
> <order>Dutch</order>
> <order>English</order>
> <order>French</order>
> <order>German Duden</order>
> <order>Italian</order>
> <order>Latin</order>
> <order>Portuguese</order>
> <order>Spanish</order>
> </collation>
> <collation name="latin1_cp500_ci" id="95" order="EBCDIC"/>
> </charset>
>
> <charset name="hp8">
> <family>Western</family>
> <description>HP West European</description>
> <alias>hproman8</alias>
> <collation name="hp8_bin" id="72" order="Binary" flag="binary"/>
> <collation name="hp8_english_ci" id="6" flag="primary">
> <order>Dutch</order>
> <order>English</order>
> <order>French</order>
> <order>German Duden</order>
> <order>Italian</order>
> <order>Latin</order>
> <order>Portuguese</order>
> <order>Spanish</order>
> </collation>
> </charset>
>
> <charset name="koi8r">
> <family>Cyrillic</family>
> <description>KOI8-R Relcom Russian</description>
> <alias>koi8-r</alias>
> <alias>cskoi8r</alias>
> <collation name="koi8r_general_ci" id="7" order="Russian" flag="primary"/>
> <collation name="koi8r_bin" id="74" order="Binary" flag="binary"/>
> </charset>
>
> <charset name="swe7">
> <family>Western</family>
> <description>7bit Swedish</description>
> <alias>iso-646-se</alias>
> <collation name="swe7_swedish_ci" id="10" order="Swedish" flag="primary"/>
> <collation name="swe7_bin" id="82" order="Binary" flag="binary"/>
> </charset>
>
> <charset name="ascii">
> <family>Western</family>
> <description>US ASCII</description>
> <alias>us</alias>
> <alias>us-ascii</alias>
> <alias>csascii</alias>
> <alias>iso-ir-6</alias>
> <alias>iso646-us</alias>
> <collation name="ascii_general_ci" id="11" order="English" flag="primary"/>
> <collation name="ascii_bin" id="65" order="Binary" flag="binary"/>
> </charset>
>
> <charset name="ujis">
> <family>Japanese</family>
> <description>EUC-JP Japanese</description>
> <alias>euc-jp</alias>
> <collation name="ujis_japanese_ci" id="12" order="Japanese">
> <flag>primary</flag>
> <flag>compiled</flag>
> </collation>
> <collation name="ujis_bin" id="91" order="Japanese">
> <flag>binary</flag>
> <flag>compiled</flag>
> </collation>
> </charset>
>
> <charset name="sjis">
> <family>Japanese</family>
> <description>Shift-JIS Japanese</description>
> <alias>s-jis</alias>
> <alias>shift-jis</alias>
> <alias>x-sjis</alias>
> <collation name="sjis_japanese_ci" id="13" order="Japanese">
> <flag>primary</flag>
> <flag>compiled</flag>
> </collation>
> <collation name="sjis_bin" id="88" order="Binary">
> <flag>binary</flag>
> <flag>compiled</flag>
> </collation>
> </charset>
>
> <charset name="cp1251">
> <family>Cyrillic</family>
> <description>Windows Cyrillic</description>
> <alias>windows-1251</alias>
> <alias>ms-cyr</alias>
> <alias>ms-cyrillic</alias>
> <collation name="cp1251_bulgarian_ci" id="14">
> <order>Belarusian</order>
> <order>Bulgarian</order>
> <order>Macedonian</order>
> <order>Russian</order>
> <order>Serbian</order>
> <order>Mongolian</order>
> <order>Ukrainian</order>
> </collation>
> <collation name="cp1251_ukrainian_ci" id="23" order="Ukrainian"/>
> <collation name="cp1251_bin" id="50" order="Binary" flag="binary"/>
> <collation name="cp1251_general_ci" id="51" flag="primary">
> <order>Belarusian</order>
> <order>Bulgarian</order>
> <order>Macedonian</order>
> <order>Russian</order>
> <order>Serbian</order>
> <order>Mongolian</order>
> <order>Ukrainian</order>
> </collation>
> <collation name="cp1251_general_cs" id="52">
> <order>Belarusian</order>
> <order>Bulgarian</order>
> <order>Macedonian</order>
> <order>Russian</order>
> <order>Serbian</order>
> <order>Mongolian</order>
> <order>Ukrainian</order>
> </collation>
> </charset>
>
> <charset name="hebrew">
> <family>Hebrew</family>
> <description>ISO 8859-8 Hebrew</description>
> <alias>csisolatinhebrew</alias>
> <alias>iso-8859-8</alias>
> <alias>iso-ir-138</alias>
> <collation name="hebrew_general_ci" id="16" order="Hebrew" flag="primary"/>
> <collation name="hebrew_bin" id="71" order="Binary" flag="binary"/>
> </charset>
>
> <charset name="tis620">
> <family>Thai</family>
> <description>TIS620 Thai</description>
> <alias>tis-620</alias>
> <collation name="tis620_thai_ci" id="18" order="Thai">
> <flag>primary</flag>
> <flag>compiled</flag>
> </collation>
> <collation name="tis620_bin" id="89" order="Binary">
> <flag>binary</flag>
> <flag>compiled</flag>
> </collation>
> </charset>
>
> <charset name="euckr">
> <family>Korean</family>
> <description>EUC-KR Korean</description>
> <alias>euc_kr</alias>
> <alias>euc-kr</alias>
> <collation name="euckr_korean_ci" id="19" order="Korean">
> <flag>primary</flag>
> <flag>compiled</flag>
> </collation>
> <collation name="euckr_bin" id="85">
> <flag>binary</flag>
> <flag>compiled</flag>
> </collation>
> </charset>
>
> <charset name="latin7">
> <family>Baltic</family>
> <description>ISO 8859-13 Baltic</description>
> <alias>BalticRim</alias>
> <alias>iso-8859-13</alias>
> <alias>l7</alias>
> <collation name="latin7_estonian_cs" id="20">
> <order>Estonian</order>
> </collation>
> <collation name="latin7_general_ci" id="41">
> <order>Latvian</order>
> <order>Lithuanian</order>
> <flag>primary</flag>
> </collation>
> <collation name="latin7_general_cs" id="42">
> <order>Latvian</order>
> <order>Lithuanian</order>
> </collation>
> <collation name="latin7_bin" id="79" order="Binary" flag="binary"/>
> </charset>
>
> <charset name="koi8u">
> <family>Cyrillic</family>
> <description>KOI8-U Ukrainian</description>
> <alias>koi8-u</alias>
> <collation name="koi8u_general_ci" id="22" order="Ukranian" flag="primary"/>
> <collation name="koi8u_bin" id="75" order="Binary" flag="binary"/>
> </charset>
>
> <charset name="gb2312">
> <family>Simplified Chinese</family>
> <description>GB2312 Simplified Chinese</description>
> <alias>chinese</alias>
> <alias>iso-ir-58</alias>
> <collation name="gb2312_chinese_ci" id="24" order="Chinese">
> <flag>primary</flag>
> <flag>compiled</flag>
> </collation>
> <collation name="gb2312_bin" id="86">
> <flag>binary</flag>
> <flag>compiled</flag>
> </collation>
> </charset>
>
> <charset name="greek">
> <family>Greek</family>
> <description>ISO 8859-7 Greek</description>
> <alias>csisolatingreek</alias>
> <alias>ecma-118</alias>
> <alias>greek8</alias>
> <alias>iso-8859-7</alias>
> <alias>iso-ir-126</alias>
> <collation name="greek_general_ci" id="25" order="Greek" flag="primary"/>
> <collation name="greek_bin" id="70" order="Binary" flag="binary"/>
> </charset>
>
> <charset name="cp1250">
> <family>Central European</family>
> <description>Windows Central European</description>
> <alias>ms-ce</alias>
> <alias>windows-1250</alias>
> <collation name="cp1250_general_ci" id="26" flag="primary">
> <order>Hungarian</order>
> <order>Polish</order>
> <order>Romanian</order>
> <order>Croatian</order>
> <order>Slovak</order>
> <order>Slovenian</order>
> <order>Sorbian</order>
> </collation>
> <collation name="cp1250_czech_cs" id="34" order="Czech">
> <flag>compiled</flag>
> </collation>
> <collation name="cp1250_bin" id="66" order="Binary" flag="binary"/>
> </charset>
>
> <charset name="gbk">
> <family>East Asian</family>
> <description>GBK Simplified Chinese</description>
> <alias>cp936</alias>
> <collation name="gbk_chinese_ci" id="28" order="Chinese">
> <flag>primary</flag>
> <flag>compiled</flag>
> </collation>
> <collation name="gbk_bin" id="87" order="Binary">
> <flag>binary</flag>
> <flag>compiled</flag>
> </collation>
> </charset>
>
> <charset name="cp1257">
> <family>Baltic</family>
> <description>Windows Baltic</description>
> <alias>WinBaltRim</alias>
> <alias>windows-1257</alias>
> <collation name="cp1257_lithuanian_ci" id="29" order="Lithuanian"/>
> <collation name="cp1257_bin" id="58" order="Binary" flag="binary"/>
> <collation name="cp1257_general_ci" id="59" flag="primary">
> <order>Latvian</order>
> <order>Lithuanian</order>
> </collation>
> <!--collation name="cp1257_ci" id="60"/-->
> <!--collation name="cp1257_cs" id="61"/-->
> </charset>
>
> <charset name="latin5">
> <family>South Asian</family>
> <description>ISO 8859-9 Turkish</description>
> <alias>csisolatin5</alias>
> <alias>iso-8859-9</alias>
> <alias>iso-ir-148</alias>
> <alias>l5</alias>
> <alias>latin5</alias>
> <alias>turkish</alias>
> <collation name="latin5_turkish_ci" id="30" order="Turkish" flag="primary"/>
> <collation name="latin5_bin" id="78" order="Binary" flag="binary"/>
> </charset>
>
> <charset name="armscii8">
> <family>South Asian</family>
> <description>ARMSCII-8 Armenian</description>
> <alias>armscii-8</alias>
> <collation
> name="armscii8_general_ci" id="32" order="Armenian" flag="primary"/>
> <collation name="armscii8_bin" id="64" order="Binary" flag="binary"/>
> </charset>
>
> <charset name="utf8">
> <family>Unicode</family>
> <description>UTF-8 Unicode</description>
> <alias>utf-8</alias>
> <collation name="utf8_general_ci" id="33">
> <flag>primary</flag>
> <flag>compiled</flag>
> </collation>
> <collation name="utf8_bin" id="83">
> <flag>binary</flag>
> <flag>compiled</flag>
> </collation>
> </charset>
>
> <charset name="ucs2">
> <family>Unicode</family>
> <description>UCS-2 Unicode</description>
> <collation name="ucs2_general_ci" id="35">
> <flag>primary</flag>
> <flag>compiled</flag>
> </collation>
> <collation name="ucs2_bin" id="90">
> <flag>binary</flag>
> <flag>compiled</flag>
> </collation>
> </charset>
>
> <charset name="cp866">
> <family>Cyrillic</family>
> <description>DOS Russian</description>
> <alias>866</alias>
> <alias>csibm866</alias>
> <alias>ibm866</alias>
> <alias>DOSCyrillicRussian</alias>
> <collation name="cp866_general_ci" id="36" order="Russian" flag="primary"/>
> <collation name="cp866_bin" id="68" order="Binary" flag="binary"/>
> </charset>
>
> <charset name="keybcs2">
> <family>Central European</family>
> <description>DOS Kamenicky Czech-Slovak</description>
> <collation name="keybcs2_general_ci" id="37" order="Czech" flag="primary"/>
> <collation name="keybcs2_bin" id="73" order="Binary" flag="binary"/>
> </charset>
>
> <charset name="macce">
> <family>Central European</family>
> <description>Mac Central European</description>
> <alias>MacCentralEurope</alias>
> <collation name="macce_general_ci" id="38" flag="primary">
> <order>Hungarian</order>
> <order>Polish</order>
> <order>Romanian</order>
> <order>Croatian</order>
> <order>Slovak</order>
> <order>Slovenian</order>
> <order>Sorbian</order>
> </collation>
> <collation name="macce_bin" id="43" order="Binary" flag="binary"/>
> </charset>
>
> <charset name="macroman">
> <family>Western</family>
> <description>Mac West European</description>
> <alias>Mac</alias>
> <alias>Macintosh</alias>
> <alias>csmacintosh</alias>
> <collation name="macroman_general_ci" id="39" flag="primary">
> <order>Dutch</order>
> <order>English</order>
> <order>French</order>
> <order>German Duden</order>
> <order>Italian</order>
> <order>Latin</order>
> <order>Portuguese</order>
> <order>Spanish</order>
> </collation>
> <collation name="macroman_bin" id="53" order="Binary" flag="binary"/>
> <!--collation name="macroman_ci" id="54"/-->
> <!--collation name="macroman_ci_ai" id="55"/-->
> <!--collation name="macroman_cs" id="56"/-->
> </charset>
>
> <charset name="cp852">
> <family>Central European</family>
> <description>DOS Central European</description>
> <alias>852</alias>
> <alias>cp852</alias>
> <alias>ibm852</alias>
> <collation name="cp852_general_ci" id="40" flag="primary">
> <order>Hungarian</order>
> <order>Polish</order>
> <order>Romanian</order>
> <order>Croatian</order>
> <order>Slovak</order>
> <order>Slovenian</order>
> <order>Sorbian</order>
> </collation>
> <collation name="cp852_bin" id="81" order="Binary" flag="binary"/>
> </charset>
>
> <charset name="cp1256">
> <family>Arabic</family>
> <description>Windows Arabic</description>
> <alias>ms-arab</alias>
> <alias>windows-1256</alias>
> <collation name="cp1256_bin" id="67" order="Binary" flag="binary"/>
> <collation name="cp1256_general_ci" id="57" order="Arabic" flag="primary">
> <order>Arabic</order>
> <order>Persian</order>
> <order>Pakistani</order>
> <order>Urdu</order>
> </collation>
> </charset>
>
> <charset name="geostd8">
> <family>South Asian</family>
> <description>GEOSTD8 Georgian</description>
> <collation
> name="geostd8_general_ci" id="92" order="Georgian" flag="primary"/>
> <collation name="geostd8_bin" id="93" order="Binary" flag="binary"/>
> </charset>
>
> <charset name="binary">
> <description>Binary pseudo charset</description>
> <collation name="binary" id="63" order="Binary">
> <flag>primary</flag>
> <flag>compiled</flag>
> </collation>
> </charset>
>
> </charsets>
>
>
> ------------------------------------------------------------------------
>
> <?xml version='1.0' encoding="utf-8"?>
>
> <charsets>
>
> <copyright>
> Copyright (C) 2003 MySQL AB
>
> This program is free software; you can redistribute it and/or modify
> it under the terms of the GNU General Public License as published by
> the Free Software Foundation; either version 2 of the License, or
> (at your option) any later version.
>
> This program is distributed in the hope that it will be useful,
> but WITHOUT ANY WARRANTY; without even the implied warranty of
> MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
> GNU General Public License for more details.
>
> You should have received a copy of the GNU General Public License
> along with this program; if not, write to the Free Software
> Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
> </copyright>
>
> <charset name="latin1">
>
> <ctype>
> <map>
> 00
> 20 20 20 20 20 20 20 20 20 28 28 28 28 28 20 20
> 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
> 48 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10
> 84 84 84 84 84 84 84 84 84 84 10 10 10 10 10 10
> 10 81 81 81 81 81 81 01 01 01 01 01 01 01 01 01
> 01 01 01 01 01 01 01 01 01 01 01 10 10 10 10 10
> 10 82 82 82 82 82 82 02 02 02 02 02 02 02 02 02
> 02 02 02 02 02 02 02 02 02 02 02 10 10 10 10 20
> 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
> 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
> 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01
> 01 01 01 01 01 01 01 00 01 01 01 01 01 01 01 02
> 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02
> 02 02 02 02 02 02 02 00 02 02 02 02 02 02 02 02
> </map>
> </ctype>
>
>
> <lower>
> <map>
> 00 01 02 03 04 05 06 07 08 09 0A 0B 0C 0D 0E 0F
> 10 11 12 13 14 15 16 17 18 19 1A 1B 1C 1D 1E 1F
> 20 21 22 23 24 25 26 27 28 29 2A 2B 2C 2D 2E 2F
> 30 31 32 33 34 35 36 37 38 39 3A 3B 3C 3D 3E 3F
> 40 61 62 63 64 65 66 67 68 69 6A 6B 6C 6D 6E 6F
> 70 71 72 73 74 75 76 77 78 79 7A 5B 5C 5D 5E 5F
> 60 61 62 63 64 65 66 67 68 69 6A 6B 6C 6D 6E 6F
> 70 71 72 73 74 75 76 77 78 79 7A 7B 7C 7D 7E 7F
> 80 81 82 83 84 85 86 87 88 89 8A 8B 8C 8D 8E 8F
> 90 91 92 93 94 95 96 97 98 99 9A 9B 9C 9D 9E 9F
> A0 A1 A2 A3 A4 A5 A6 A7 A8 A9 AA AB AC AD AE AF
> B0 B1 B2 B3 B4 B5 B6 B7 B8 B9 BA BB BC BD BE BF
> E0 E1 E2 E3 E4 E5 E6 E7 E8 E9 EA EB EC ED EE EF
> F0 F1 F2 F3 F4 F5 F6 D7 F8 F9 FA FB FC FD FE DF
> E0 E1 E2 E3 E4 E5 E6 E7 E8 E9 EA EB EC ED EE EF
> F0 F1 F2 F3 F4 F5 F6 F7 F8 F9 FA FB FC FD FE FF
> </map>
> </lower>
>
>
> <upper>
> <map>
> 00 01 02 03 04 05 06 07 08 09 0A 0B 0C 0D 0E 0F
> 10 11 12 13 14 15 16 17 18 19 1A 1B 1C 1D 1E 1F
> 20 21 22 23 24 25 26 27 28 29 2A 2B 2C 2D 2E 2F
> 30 31 32 33 34 35 36 37 38 39 3A 3B 3C 3D 3E 3F
> 40 41 42 43 44 45 46 47 48 49 4A 4B 4C 4D 4E 4F
> 50 51 52 53 54 55 56 57 58 59 5A 5B 5C 5D 5E 5F
> 60 41 42 43 44 45 46 47 48 49 4A 4B 4C 4D 4E 4F
> 50 51 52 53 54 55 56 57 58 59 5A 7B 7C 7D 7E 7F
> 80 81 82 83 84 85 86 87 88 89 8A 8B 8C 8D 8E 8F
> 90 91 92 93 94 95 96 97 98 99 9A 9B 9C 9D 9E 9F
> A0 A1 A2 A3 A4 A5 A6 A7 A8 A9 AA AB AC AD AE AF
> B0 B1 B2 B3 B4 B5 B6 B7 B8 B9 BA BB BC BD BE BF
> C0 C1 C2 C3 C4 C5 C6 C7 C8 C9 CA CB CC CD CE CF
> D0 D1 D2 D3 D4 D5 D6 D7 D8 D9 DA DB DC DD DE DF
> C0 C1 C2 C3 C4 C5 C6 C7 C8 C9 CA CB CC CD CE CF
> D0 D1 D2 D3 D4 D5 D6 F7 D8 D9 DA DB DC DD DE FF
> </map>
> </upper>
>
>
> <unicode>
> <map>
> 0000 0001 0002 0003 0004 0005 0006 0007 0008 0009 000A 000B 000C 000D 000E 000F
> 0010 0011 0012 0013 0014 0015 0016 0017 0018 0019 001A 001B 001C 001D 001E 001F
> 0020 0021 0022 0023 0024 0025 0026 0027 0028 0029 002A 002B 002C 002D 002E 002F
> 0030 0031 0032 0033 0034 0035 0036 0037 0038 0039 003A 003B 003C 003D 003E 003F
> 0040 0041 0042 0043 0044 0045 0046 0047 0048 0049 004A 004B 004C 004D 004E 004F
> 0050 0051 0052 0053 0054 0055 0056 0057 0058 0059 005A 005B 005C 005D 005E 005F
> 0060 0061 0062 0063 0064 0065 0066 0067 0068 0069 006A 006B 006C 006D 006E 006F
> 0070 0071 0072 0073 0074 0075 0076 0077 0078 0079 007A 007B 007C 007D 007E 007F
> 0080 0081 0082 0083 0084 0085 0086 0087 0088 0089 008A 008B 008C 008D 008E 008F
> 0090 0091 0092 0093 0094 0095 0096 0097 0098 0099 009A 009B 009C 009D 009E 009F
> 00A0 00A1 00A2 00A3 00A4 00A5 00A6 00A7 00A8 00A9 00AA 00AB 00AC 00AD 00AE 00AF
> 00B0 00B1 00B2 00B3 00B4 00B5 00B6 00B7 00B8 00B9 00BA 00BB 00BC 00BD 00BE 00BF
> 00C0 00C1 00C2 00C3 00C4 00C5 00C6 00C7 00C8 00C9 00CA 00CB 00CC 00CD 00CE 00CF
> 00D0 00D1 00D2 00D3 00D4 00D5 00D6 00D7 00D8 00D9 00DA 00DB 00DC 00DD 00DE 00DF
> 00E0 00E1 00E2 00E3 00E4 00E5 00E6 00E7 00E8 00E9 00EA 00EB 00EC 00ED 00EE 00EF
> 00F0 00F1 00F2 00F3 00F4 00F5 00F6 00F7 00F8 00F9 00FA 00FB 00FC 00FD 00FE 00FF
> </map>
> </unicode>
>
>
> <collation name="latin1_swedish_ci">
> <map>
> 00 01 02 03 04 05 06 07 08 09 0A 0B 0C 0D 0E 0F
> 10 11 12 13 14 15 16 17 18 19 1A 1B 1C 1D 1E 1F
> 20 21 22 23 24 25 26 27 28 29 2A 2B 2C 2D 2E 2F
> 30 31 32 33 34 35 36 37 38 39 3A 3B 3C 3D 3E 3F
> 40 41 42 43 44 45 46 47 48 49 4A 4B 4C 4D 4E 4F
> 50 51 52 53 54 55 56 57 58 59 5A 5B 5C 5D 5E 5F
> 60 41 42 43 44 45 46 47 48 49 4A 4B 4C 4D 4E 4F
> 50 51 52 53 54 55 56 57 58 59 5A 7B 7C 7D 7E 7F
> 80 81 82 83 84 85 86 87 88 89 8A 8B 8C 8D 8E 8F
> 90 91 92 93 94 95 96 97 98 99 9A 9B 9C 9D 9E 9F
> A0 A1 A2 A3 A4 A5 A6 A7 A8 A9 AA AB AC AD AE AF
> B0 B1 B2 B3 B4 B5 B6 B7 B8 B9 BA BB BC BD BE BF
> 41 41 41 41 5C 5B 5C 43 45 45 45 45 49 49 49 49
> 44 4E 4F 4F 4F 4F 5D D7 D8 55 55 55 59 59 DE DF
> 41 41 41 41 5C 5B 5C 43 45 45 45 45 49 49 49 49
> 44 4E 4F 4F 4F 4F 5D F7 D8 55 55 55 59 59 DE FF
> </map>
> </collation>
>
>
> <collation name="latin1_german1_ci">
> <map>
> 00 01 02 03 04 05 06 07 08 09 0A 0B 0C 0D 0E 0F
> 10 11 12 13 14 15 16 17 18 19 1A 1B 1C 1D 1E 1F
> 20 21 22 23 24 25 26 27 28 29 2A 2B 2C 2D 2E 2F
> 30 31 32 33 34 35 36 37 38 39 3A 3B 3C 3D 3E 3F
> 40 41 42 43 44 45 46 47 48 49 4A 4B 4C 4D 4E 4F
> 50 51 52 53 54 55 56 57 58 59 5A 5B 5C 5D 5E 5F
> 60 41 42 43 44 45 46 47 48 49 4A 4B 4C 4D 4E 4F
> 50 51 52 53 54 55 56 57 58 59 5A 7B 7C 7D 7E 7F
> 80 81 82 83 84 85 86 87 88 89 8A 8B 8C 8D 8E 8F
> 90 91 92 93 94 95 96 97 98 99 9A 9B 9C 9D 9E 9F
> A0 A1 A2 A3 A4 A5 A6 A7 A8 A9 AA AB AC AD AE AF
> B0 B1 B2 B3 B4 B5 B6 B7 B8 B9 BA BB BC BD BE BF
> 41 41 41 41 41 41 41 43 45 45 45 45 49 49 49 49
> D0 4E 4F 4F 4F 4F 4F D7 4F 55 55 55 55 59 DE 53
> 41 41 41 41 41 41 41 43 45 45 45 45 49 49 49 49
> D0 4E 4F 4F 4F 4F 4F F7 4F 55 55 55 55 59 DE FF
> </map>
> </collation>
>
>
> <collation name="latin1_danish_ci">
> <map>
> 00 01 02 03 04 05 06 07 08 09 0A 0B 0C 0D 0E 0F
> 10 11 12 13 14 15 16 17 18 19 1A 1B 1C 1D 1E 1F
> 20 21 22 23 24 25 26 27 28 29 2A 2B 2C 2D 2E 2F
> 30 31 32 33 34 35 36 37 38 39 3A 3B 3C 3D 3E 3F
> 40 41 42 43 44 45 46 47 48 49 4A 4B 4C 4D 4E 4F
> 50 51 52 53 54 55 56 57 58 59 5A 5B 5C 5D 5E 5F
> 60 41 42 43 44 45 46 47 48 49 4A 4B 4C 4D 4E 4F
> 50 51 52 53 54 55 56 57 58 59 5A 7B 7C 7D 7E 7F
> 80 81 82 83 84 85 86 87 88 89 8A 8B 8C 8D 8E 8F
> 90 91 92 93 94 95 96 97 98 99 9A 9B 9C 9D 9E 9F
> A0 A1 A2 A3 A4 A5 A6 A7 A8 A9 AA AB AC AD AE AF
> B0 B1 B2 B3 B4 B5 B6 B7 B8 B9 BA BB BC BD BE BF
> 41 41 41 41 5B 5D 5B 43 45 45 45 45 49 49 49 49
> 44 4E 4F 4F 4F 4F 5C D7 5C 55 55 55 59 59 DE DF
> 41 41 41 41 5B 5D 5B 43 45 45 45 45 49 49 49 49
> 44 4E 4F 4F 4F 4F 5C F7 5C 55 55 55 59 59 DE FF
> </map>
> </collation>
>
>
> <collation name="latin1_german2_ci"/>
>
>
> <collation name="latin1_bin" flag="binary"/>
>
>
> <collation name="latin1_general_ci">
> <map>
> 00 01 02 03 04 05 06 07 08 09 0A 0B 0C 0D 0E 0F
> 10 11 12 13 14 15 16 17 18 19 1A 1B 1C 1D 1E 1F
> 20 21 22 23 24 25 26 27 28 29 2A 2B 2C 2D 2E 2F
> 30 31 32 33 34 35 36 37 38 39 3A 3B 3C 3D 3E 3F
> 40 41 51 53 57 5B 65 67 69 6B 75 77 79 7B 7D 81
> 8F 91 93 95 98 9A A4 A6 A8 AA AF B3 B4 B5 B6 B7
> B8 41 51 53 57 5B 65 67 69 6B 75 77 79 7B 7D 81
> 8F 91 93 95 98 9A A4 A6 A8 AA AF B9 BA BB BC BF
> C0 C1 C2 C3 C4 C5 C6 C7 C8 C9 CA CB CC CD CE CF
> D0 D1 D2 D3 D4 D5 D6 D7 D8 D9 DA DB DC DD DE DF
> E0 E1 E2 E3 E4 E5 E6 E7 E8 E9 EA EB EC ED EE EF
> F0 F1 F2 F3 F4 F5 F6 F7 F8 F9 FA FB FC FD FE FF
> 43 45 47 49 4B 4D 4F 55 5D 5F 61 63 6D 6F 71 73
> 59 7F 83 85 87 89 8B BD 8D 9C 9E A0 A2 AC B1 97
> 43 45 47 49 4B 4D 4F 55 5D 5F 61 63 6D 6F 71 73
> 59 7F 83 85 87 89 8B BE 8D 9C 9E A0 A2 AC B1 AE
> </map>
> </collation>
>
>
> <collation name="latin1_general_cs">
> <map>
> 00 01 02 03 04 05 06 07 08 09 0A 0B 0C 0D 0E 0F
> 10 11 12 13 14 15 16 17 18 19 1A 1B 1C 1D 1E 1F
> 20 21 22 23 24 25 26 27 28 29 2A 2B 2C 2D 2E 2F
> 30 31 32 33 34 35 36 37 38 39 3A 3B 3C 3D 3E 3F
> 40 41 51 53 57 5B 65 67 69 6B 75 77 79 7B 7D 81
> 8F 91 93 95 98 9A A4 A6 A8 AA AF B3 B4 B5 B6 B7
> B8 42 52 54 58 5C 66 68 6A 6C 76 78 7A 7C 7E 82
> 90 92 94 96 99 9B A5 A7 A9 AB B0 B9 BA BB BC BF
> C0 C1 C2 C3 C4 C5 C6 C7 C8 C9 CA CB CC CD CE CF
> D0 D1 D2 D3 D4 D5 D6 D7 D8 D9 DA DB DC DD DE DF
> E0 E1 E2 E3 E4 E5 E6 E7 E8 E9 EA EB EC ED EE EF
> F0 F1 F2 F3 F4 F5 F6 F7 F8 F9 FA FB FC FD FE FF
> 43 45 47 49 4B 4D 4F 55 5D 5F 61 63 6D 6F 71 73
> 59 7F 83 85 87 89 8B BD 8D 9C 9E A0 A2 AC B1 97
> 44 46 48 4A 4C 4E 50 56 5E 60 62 64 6E 70 72 74
> 5A 80 84 86 88 8A 8C BE 8E 9D 9F A1 A3 AD B2 AE
> </map>
> </collation>
>
>
> <collation name="latin1_spanish_ci">
> <map>
> 00 01 02 03 04 05 06 07 08 09 0A 0B 0C 0D 0E 0F
> 10 11 12 13 14 15 16 17 18 19 1A 1B 1C 1D 1E 1F
> 20 21 22 23 24 25 26 27 28 29 2A 2B 2C 2D 2E 2F
> 30 31 32 33 34 35 36 37 38 39 3A 3B 3C 3D 3E 3F
> 40 41 51 53 57 5B 65 67 69 6B 75 77 79 7B 7D 81
> 8F 91 93 95 98 9A A4 A6 A8 AA AF B3 B4 B5 B6 B7
> B8 41 51 53 57 5B 65 67 69 6B 75 77 79 7B 7D 81
> 8F 91 93 95 98 9A A4 A6 A8 AA AF B9 BA BB BC BF
> C0 C1 C2 C3 C4 C5 C6 C7 C8 C9 CA CB CC CD CE CF
> D0 D1 D2 D3 D4 D5 D6 D7 D8 D9 DA DB DC DD DE DF
> E0 E1 E2 E3 E4 E5 E6 E7 E8 E9 EA EB EC ED EE EF
> F0 F1 F2 F3 F4 F5 F6 F7 F8 F9 FA FB FC FD FE FF
> 41 41 41 41 41 41 41 53 5B 5B 5B 5B 6B 6B 6B 6B
> 57 7F 81 81 81 81 81 BD 81 9A 9A 9A 9A AA B1 97
> 41 41 41 41 41 41 41 53 5B 5B 5B 5B 6B 6B 6B 6B
> 57 7F 81 81 81 81 81 BE 81 9A 9A 9A 9A AA B1 AA
> </map>
> </collation>
>
>
> <collation name="latin1_cp500_ci">
> <map>
> 00 01 02 03 04 05 06 07 08 09 0A 0B 0C 0D 0E 0F
> 10 11 12 13 14 15 16 17 18 19 1A 1B 1C 1D 1E 1F
> 40 5A 7F 7B 5B 6C 50 7D 4D 5D 5C 4E 6B 60 4B 61
> F0 F1 F2 F3 F4 F5 F6 F7 F8 F9 7A 5E 4C 7E 6E 6F
> 7C C1 C2 C3 C4 C5 C6 C7 C8 C9 D1 D2 D3 D4 D5 D6
> D7 D8 D9 E2 E3 E4 E5 E6 E7 E8 E9 AD E0 BD 5E 6D
> 79 C1 C2 C3 C4 C5 C6 C7 C8 C9 D1 D2 D3 D4 D5 D6
> D7 D8 D9 E2 E3 E4 E5 E6 E7 E8 E9 C0 4F D0 A1 7F
> 80 81 82 83 84 85 86 87 88 89 8A 8B 8C 8D 8E 8F
> 90 91 92 93 94 95 96 97 98 99 9A 9B 9C 9D 9E 9F
> A0 A1 A2 A3 A4 A5 A6 A7 A8 A9 AA AB AC AD AE AF
> B0 B1 B2 B3 B4 B5 B6 B7 B8 B9 BA BB BC BD BE BF
> 41 41 41 41 5C 5B 5C 43 45 45 45 45 49 49 49 49
> 44 4E 4F 4F 4F 4F 5D D7 D8 55 55 55 59 59 DE DF
> 41 41 41 41 5C 5B 5C 43 45 45 45 45 49 49 49 49
> 44 4E 4F 4F 4F 4F 5D F7 D8 55 55 55 59 59 DE FF
> </map>
> </collation>
>
> </charset>
>
> </charsets>
>
