Author: paul
Date: 2009-02-03 18:01:12 +0100 (Tue, 03 Feb 2009)
New Revision: 13536
Log:
r38137@frost: paul | 2009-02-03 11:02:08 -0500
Additional information about mixing _bin with non-_bin collations (Bar)
Modified:
trunk/refman-4.1/internationalization.xml
trunk/refman-5.0/internationalization.xml
trunk/refman-5.1/internationalization.xml
trunk/refman-6.0/internationalization.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:41130
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:38136
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:36139
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:41130
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:38137
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:36139
Modified: trunk/refman-4.1/internationalization.xml
===================================================================
--- trunk/refman-4.1/internationalization.xml 2009-02-03 17:01:03 UTC (rev 13535)
+++ trunk/refman-4.1/internationalization.xml 2009-02-03 17:01:12 UTC (rev 13536)
Changed blocks: 1, Lines Added: 7, Lines Deleted: 3; 1118 bytes
@@ -2360,9 +2360,13 @@
<listitem>
<para>
For an operation with operands from the same character
- set but that mix <literal>_bin</literal> and
- <literal>_ci</literal> collations, the
- <literal>_bin</literal> collation is used.
+ set but that mix a <literal>_bin</literal> collation
+ and a <literal>_ci</literal> or <literal>_cs</literal>
+ collation, the <literal>_bin</literal> collation is
+ used. This is similar to how operations that mix
+ non-binary and binary strings evaluate the operands as
+ binary strings, except that it is for collations
+ rather than data types.
</para>
</listitem>
Modified: trunk/refman-5.0/internationalization.xml
===================================================================
--- trunk/refman-5.0/internationalization.xml 2009-02-03 17:01:03 UTC (rev 13535)
+++ trunk/refman-5.0/internationalization.xml 2009-02-03 17:01:12 UTC (rev 13536)
Changed blocks: 1, Lines Added: 7, Lines Deleted: 3; 1118 bytes
@@ -2388,9 +2388,13 @@
<listitem>
<para>
For an operation with operands from the same character
- set but that mix <literal>_bin</literal> and
- <literal>_ci</literal> collations, the
- <literal>_bin</literal> collation is used.
+ set but that mix a <literal>_bin</literal> collation
+ and a <literal>_ci</literal> or <literal>_cs</literal>
+ collation, the <literal>_bin</literal> collation is
+ used. This is similar to how operations that mix
+ non-binary and binary strings evaluate the operands as
+ binary strings, except that it is for collations
+ rather than data types.
</para>
</listitem>
Modified: trunk/refman-5.1/internationalization.xml
===================================================================
--- trunk/refman-5.1/internationalization.xml 2009-02-03 17:01:03 UTC (rev 13535)
+++ trunk/refman-5.1/internationalization.xml 2009-02-03 17:01:12 UTC (rev 13536)
Changed blocks: 1, Lines Added: 7, Lines Deleted: 3; 1118 bytes
@@ -2384,9 +2384,13 @@
<listitem>
<para>
For an operation with operands from the same character
- set but that mix <literal>_bin</literal> and
- <literal>_ci</literal> collations, the
- <literal>_bin</literal> collation is used.
+ set but that mix a <literal>_bin</literal> collation
+ and a <literal>_ci</literal> or <literal>_cs</literal>
+ collation, the <literal>_bin</literal> collation is
+ used. This is similar to how operations that mix
+ non-binary and binary strings evaluate the operands as
+ binary strings, except that it is for collations
+ rather than data types.
</para>
</listitem>
Modified: trunk/refman-6.0/internationalization.xml
===================================================================
--- trunk/refman-6.0/internationalization.xml 2009-02-03 17:01:03 UTC (rev 13535)
+++ trunk/refman-6.0/internationalization.xml 2009-02-03 17:01:12 UTC (rev 13536)
Changed blocks: 1, Lines Added: 7, Lines Deleted: 3; 1118 bytes
@@ -2384,9 +2384,13 @@
<listitem>
<para>
For an operation with operands from the same character
- set but that mix <literal>_bin</literal> and
- <literal>_ci</literal> collations, the
- <literal>_bin</literal> collation is used.
+ set but that mix a <literal>_bin</literal> collation
+ and a <literal>_ci</literal> or <literal>_cs</literal>
+ collation, the <literal>_bin</literal> collation is
+ used. This is similar to how operations that mix
+ non-binary and binary strings evaluate the operands as
+ binary strings, except that it is for collations
+ rather than data types.
</para>
</listitem>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r13536 - in trunk: . refman-4.1 refman-5.0 refman-5.1 refman-6.0 | paul.dubois | 3 Feb |
