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.
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r2770 - in trunk: refman-4.1 refman-5.0 refman-5.1 | mcbrown | 19 Jul |
