svn commit - mysqldoc@docsrva: r2770 - in trunk: refman-4.1 refman-5.0 refman-5.1

[mcbrown]

Author: mcbrown
Date: 2006-07-19 11:38:23 +0200 (Wed, 19 Jul 2006)
New Revision: 2770

Log:
Adding a note on ucs2_roman_ci and utf8_roman_ci collations. 



Modified:
   trunk/refman-4.1/charset.xml
   trunk/refman-5.0/charset.xml
   trunk/refman-5.1/charset.xml


Modified: trunk/refman-4.1/charset.xml
===================================================================
--- trunk/refman-4.1/charset.xml	2006-07-19 04:36:22 UTC (rev 2769)
+++ trunk/refman-4.1/charset.xml	2006-07-19 09:38:23 UTC (rev 2770)
Changed blocks: 2, Lines Added: 10, Lines Deleted: 1; 1161 bytes

@@ -2104,7 +2104,8 @@
 
     <section id="charset-show">
 
-      <title><literal>SHOW</literal> Statements and
<literal>INFORMATION_SCHEMA</literal></title>
+      <title><literal>SHOW</literal> Statements and
+        <literal>INFORMATION_SCHEMA</literal></title>
 
       <para>
         Several <literal>SHOW</literal> statements are added or modified

@@ -3186,6 +3187,14 @@
       </itemizedlist>
 
       <para>
+        Note that in the <literal>ucs2_roman_ci</literal> and
+        <literal>utf8_roman_ci</literal> collations,
+        <literal>I</literal> and <literal>J</literal> are given
the same
+        precedence, and <literal>U</literal> and
<literal>V</literal>
+        are given the same precedence.
+      </para>
+
+      <para>
         There is a limitation in MySQL 4.1 that results in two
         characters not being correctly handled when a user tries to
         change their case using <literal>LOWER()</literal> or


Modified: trunk/refman-5.0/charset.xml
===================================================================
--- trunk/refman-5.0/charset.xml	2006-07-19 04:36:22 UTC (rev 2769)
+++ trunk/refman-5.0/charset.xml	2006-07-19 09:38:23 UTC (rev 2770)
Changed blocks: 2, Lines Added: 10, Lines Deleted: 1; 1131 bytes

@@ -2018,7 +2018,8 @@
 
     <section id="charset-show">
 
-      <title><literal>SHOW</literal> Statements and
<literal>INFORMATION_SCHEMA</literal></title>
+      <title><literal>SHOW</literal> Statements and
+        <literal>INFORMATION_SCHEMA</literal></title>
 
       <para>
         Several <literal>SHOW</literal> statements provide additional

@@ -2747,6 +2748,14 @@
       </itemizedlist>
 
       <para>
+        Note that in the <literal>ucs2_roman_ci</literal> and
+        <literal>utf8_roman_ci</literal> collations,
+        <literal>I</literal> and <literal>J</literal> compare as
equals,
+        and <literal>U</literal> and <literal>V</literal> compare
as
+        equals.
+      </para>
+
+      <para>
         The <literal>ucs2_esperanto_ci</literal> and
         <literal>utf8_esperanto_ci</literal> collations were added in
         MySQL 5.0.13. The <literal>ucs2_hungarian_ci</literal> and


Modified: trunk/refman-5.1/charset.xml
===================================================================
--- trunk/refman-5.1/charset.xml	2006-07-19 04:36:22 UTC (rev 2769)
+++ trunk/refman-5.1/charset.xml	2006-07-19 09:38:23 UTC (rev 2770)
Changed blocks: 2, Lines Added: 10, Lines Deleted: 1; 1085 bytes

@@ -2014,7 +2014,8 @@
 
     <section id="charset-show">
 
-      <title><literal>SHOW</literal> Statements and
<literal>INFORMATION_SCHEMA</literal></title>
+      <title><literal>SHOW</literal> Statements and
+        <literal>INFORMATION_SCHEMA</literal></title>
 
       <para>
         Several <literal>SHOW</literal> statements provide additional

@@ -2746,6 +2747,14 @@
       </itemizedlist>
 
       <para>
+        Note that in the <literal>ucs2_roman_ci</literal> and
+        <literal>utf8_roman_ci</literal> collations,
+        <literal>I</literal> and <literal>J</literal> compare as
equals,
+        and <literal>U</literal> and <literal>V</literal> compare
as
+        equals.
+      </para>
+
+      <para>
         The <literal>ucs2_hungarian_ci</literal> and
         <literal>utf8_hungarian_ci</literal> collations were added in
         MySQL 5.1.5.