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.0 | paul.dubois | 25 May |
