BINARY collations for every character set

1 files changed, 37 insertions, 2 deletions

diff --git a/sql/share/charsets/Index.xml b/sql/share/charsets/Index.xml
index 1278cb6c54a..8c2b7a05d03 100644
--- a/sql/share/charsets/Index.xml
+++ b/sql/share/charsets/Index.xml
@@ -1,6 +1,6 @@
 <?xml version='1.0' encoding="utf-8"?>
 
-<charsets max-id="83">
+<charsets max-id="91">
 
 <description>
 This file lists all of the available character sets.
@@ -21,6 +21,10 @@ To make maintaining easier please:
     <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">
@@ -96,7 +100,10 @@ To make maintaining easier please:
   <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_bin"		id="47"	order="Binary"			flag="binary"/>
+  <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>
@@ -173,6 +180,10 @@ To make maintaining easier please:
     <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">
@@ -185,6 +196,10 @@ To make maintaining easier please:
     <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">
@@ -242,6 +257,10 @@ To make maintaining easier please:
     <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">
@@ -253,6 +272,10 @@ To make maintaining easier please:
     <flag>primary</flag>
     <flag>compiled</flag>
   </collation>
+  <collation name="euckr_bin"	id="85">
+    <flag>binary</flag>
+    <flag>compiled</flag>
+  </collation>
 </charset>
 
 <charset name="latin7">
@@ -293,6 +316,10 @@ To make maintaining easier please:
     <flag>primary</flag>
     <flag>compiled</flag>
   </collation>
+  <collation name="gb2312_bin"	id="86">
+    <flag>binary</flag>
+    <flag>compiled</flag>
+  </collation>
 </charset>
 
 <charset name="greek">
@@ -333,6 +360,10 @@ To make maintaining easier please:
     <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">
@@ -386,6 +417,10 @@ To make maintaining easier please:
     <flag>primary</flag>
     <flag>compiled</flag>
   </collation>
+  <collation name="ucs2_bin"	id="90">
+    <flag>binary</flag>
+    <flag>compiled</flag>
+  </collation>
 </charset>
 
 <charset name="cp866">