List:Commits« Previous MessageNext Message »
From:paul.dubois Date:May 25 2011 4:24pm
Subject:svn commit - mysqldoc@oter02: r26334 - in trunk: . refman-5.0 refman-5.1 refman-5.5 refman-5.6 refman-6.0
View as plain text  
Author: pd221994
Date: 2011-05-25 18:24:02 +0200 (Wed, 25 May 2011)
New Revision: 26334

Log:
 r48330@dhcp-adc-twvpn-1-vpnpool-10-154-16-235:  paul | 2011-05-25 09:42:35 -0500
 Note about LOWER/UPPER and UCA version


Modified:
   svk:merge
   trunk/refman-5.0/functions-core.xml
   trunk/refman-5.1/functions-core.xml
   trunk/refman-5.5/functions-core.xml
   trunk/refman-5.6/functions-core.xml
   trunk/refman-6.0/functions-core.xml

Property changes on: trunk
___________________________________________________________________

Modified: svk:merge
===================================================================


Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 1277 bytes


Modified: trunk/refman-5.0/functions-core.xml
===================================================================
--- trunk/refman-5.0/functions-core.xml	2011-05-25 15:44:34 UTC (rev 26333)
+++ trunk/refman-5.0/functions-core.xml	2011-05-25 16:24:02 UTC (rev 26334)
Changed blocks: 1, Lines Added: 6, Lines Deleted: 5; 1137 bytes

@@ -4573,13 +4573,14 @@
 </programlisting>
 
         <para>
-          <literal role="func">UPPER()</literal> is ineffective when
-          applied to binary strings
+          See the description of <literal role="func">LOWER()</literal>
+          for information that also applies to
+          <literal role="func">UPPER()</literal>, such as information
+          about how to perform lettercase conversion of binary strings
           (<literal role="type">BINARY</literal>,
           <literal role="type">VARBINARY</literal>,
-          <literal role="type">BLOB</literal>). The description of
-          <literal role="func">LOWER()</literal> shows how to perform
-          lettercase conversion of binary strings.
+          <literal role="type">BLOB</literal>) for which these functions
+          are ineffective.
         </para>
 
         <remark role="help-description-end"/>


Modified: trunk/refman-5.1/functions-core.xml
===================================================================
--- trunk/refman-5.1/functions-core.xml	2011-05-25 15:44:34 UTC (rev 26333)
+++ trunk/refman-5.1/functions-core.xml	2011-05-25 16:24:02 UTC (rev 26334)
Changed blocks: 1, Lines Added: 6, Lines Deleted: 5; 1137 bytes

@@ -4502,13 +4502,14 @@
 </programlisting>
 
         <para>
-          <literal role="func">UPPER()</literal> is ineffective when
-          applied to binary strings
+          See the description of <literal role="func">LOWER()</literal>
+          for information that also applies to
+          <literal role="func">UPPER()</literal>, such as information
+          about how to perform lettercase conversion of binary strings
           (<literal role="type">BINARY</literal>,
           <literal role="type">VARBINARY</literal>,
-          <literal role="type">BLOB</literal>). The description of
-          <literal role="func">LOWER()</literal> shows how to perform
-          lettercase conversion of binary strings.
+          <literal role="type">BLOB</literal>) for which these functions
+          are ineffective.
         </para>
 
         <remark role="help-description-end"/>


Modified: trunk/refman-5.5/functions-core.xml
===================================================================
--- trunk/refman-5.5/functions-core.xml	2011-05-25 15:44:34 UTC (rev 26333)
+++ trunk/refman-5.5/functions-core.xml	2011-05-25 16:24:02 UTC (rev 26334)
Changed blocks: 1, Lines Added: 6, Lines Deleted: 5; 1137 bytes

@@ -4684,13 +4684,14 @@
 </programlisting>
 
         <para>
-          <literal role="func">UPPER()</literal> is ineffective when
-          applied to binary strings
+          See the description of <literal role="func">LOWER()</literal>
+          for information that also applies to
+          <literal role="func">UPPER()</literal>, such as information
+          about how to perform lettercase conversion of binary strings
           (<literal role="type">BINARY</literal>,
           <literal role="type">VARBINARY</literal>,
-          <literal role="type">BLOB</literal>). The description of
-          <literal role="func">LOWER()</literal> shows how to perform
-          lettercase conversion of binary strings.
+          <literal role="type">BLOB</literal>) for which these functions
+          are ineffective.
         </para>
 
         <remark role="help-description-end"/>


Modified: trunk/refman-5.6/functions-core.xml
===================================================================
--- trunk/refman-5.6/functions-core.xml	2011-05-25 15:44:34 UTC (rev 26333)
+++ trunk/refman-5.6/functions-core.xml	2011-05-25 16:24:02 UTC (rev 26334)
Changed blocks: 2, Lines Added: 22, Lines Deleted: 6; 2093 bytes

@@ -3638,6 +3638,20 @@
 +-------------+-----------------------------------+
 </programlisting>
 
+        <para>
+          For Unicode character sets,
+          <literal role="func">LOWER()</literal> and
+          <literal role="func">UPPER()</literal> work accounting to
+          Unicode Collation Algorithm (UCA) 5.2.0 for
+          <literal><replaceable>xxx</replaceable>_unicode_520_ci</literal>
+          collations and for language-specific collations that are
+          derived from them. For other Unicode collations,
+          <literal role="func">LOWER()</literal> and
+          <literal role="func">UPPER()</literal> work accounting to
+          Unicode Collation Algorithm (UCA) 4.0.0. See
+          <xref linkend="charset-unicode-sets"/>.
+        </para>
+
         <remark role="help-description-end"/>
 
         <para>

@@ -4754,13 +4768,15 @@
 </programlisting>
 
         <para>
-          <literal role="func">UPPER()</literal> is ineffective when
-          applied to binary strings
-          (<literal role="type">BINARY</literal>,
+          See the description of <literal role="func">LOWER()</literal>
+          for information that also applies to
+          <literal role="func">UPPER()</literal>. This included
+          information about how to perform lettercase conversion of
+          binary strings (<literal role="type">BINARY</literal>,
           <literal role="type">VARBINARY</literal>,
-          <literal role="type">BLOB</literal>). The description of
-          <literal role="func">LOWER()</literal> shows how to perform
-          lettercase conversion of binary strings.
+          <literal role="type">BLOB</literal>) for which these functions
+          are ineffective, and information about case folding for
+          Unicode character sets.
         </para>
 
         <remark role="help-description-end"/>


Modified: trunk/refman-6.0/functions-core.xml
===================================================================
--- trunk/refman-6.0/functions-core.xml	2011-05-25 15:44:34 UTC (rev 26333)
+++ trunk/refman-6.0/functions-core.xml	2011-05-25 16:24:02 UTC (rev 26334)
Changed blocks: 1, Lines Added: 6, Lines Deleted: 5; 1137 bytes

@@ -4672,13 +4672,14 @@
 </programlisting>
 
         <para>
-          <literal role="func">UPPER()</literal> is ineffective when
-          applied to binary strings
+          See the description of <literal role="func">LOWER()</literal>
+          for information that also applies to
+          <literal role="func">UPPER()</literal>, such as information
+          about how to perform lettercase conversion of binary strings
           (<literal role="type">BINARY</literal>,
           <literal role="type">VARBINARY</literal>,
-          <literal role="type">BLOB</literal>). The description of
-          <literal role="func">LOWER()</literal> shows how to perform
-          lettercase conversion of binary strings.
+          <literal role="type">BLOB</literal>) for which these functions
+          are ineffective.
         </para>
 
         <remark role="help-description-end"/>


Thread
svn commit - mysqldoc@oter02: r26334 - in trunk: . refman-5.0 refman-5.1 refman-5.5 refman-5.6 refman-6.0paul.dubois25 May