svn commit - mysqldoc@docsrva: r4581 - in trunk: . refman-5.0 refman-5.1

[paul]

Author: paul
Date: 2007-01-19 20:11:55 +0100 (Fri, 19 Jan 2007)
New Revision: 4581

Log:
 r18507@polar:  paul | 2007-01-19 13:04:19 -0600
 Note on the collation for INFORMATION_SCHEMA string columns.
 (Thanks, Trudy)


Modified:
   trunk/refman-5.0/information-schema.xml
   trunk/refman-5.1/information-schema.xml

Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:18479
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:14920
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:13520
   + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:18507
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:14920
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:13520


Modified: trunk/refman-5.0/information-schema.xml
===================================================================
--- trunk/refman-5.0/information-schema.xml	2007-01-19 19:11:20 UTC (rev 4580)
+++ trunk/refman-5.0/information-schema.xml	2007-01-19 19:11:55 UTC (rev 4581)
Changed blocks: 2, Lines Added: 8, Lines Deleted: 2; 1281 bytes

@@ -267,6 +267,12 @@
     <literal>TABLES.TABLE_NAME</literal>) is generally
     <literal>VARCHAR(<replaceable>N</replaceable>) CHARACTER SET
     utf8</literal> where <replaceable>N</replaceable> is at least 64.
+    MySQL uses the default collation for this character set
+    (<literal>utf8_general_ci</literal>) for all searches, sorts,
+    comparisons, and other string operations on such columns. If the
+    default collation is not correct for your needs, you can force a
+    suitable collation with a <literal>COLLATE</literal> clause
+    (<xref linkend="charset-collate"/>).
   </para>
 
   <para>

@@ -281,10 +287,10 @@
     missing columns and some columns out of order. We are working on
     this and updating the documentation as changes are made.
   </para>
-  
+
   <para>
     For answers to questions that are often asked concerning the
-    <literal>INFORMATION_SCHEMA</literal> database, see 
+    <literal>INFORMATION_SCHEMA</literal> database, see
     <xref linkend="faqs-information-schema"/>.
   </para>
 


Modified: trunk/refman-5.1/information-schema.xml
===================================================================
--- trunk/refman-5.1/information-schema.xml	2007-01-19 19:11:20 UTC (rev 4580)
+++ trunk/refman-5.1/information-schema.xml	2007-01-19 19:11:55 UTC (rev 4581)
Changed blocks: 2, Lines Added: 8, Lines Deleted: 2; 1281 bytes

@@ -267,6 +267,12 @@
     <literal>TABLES.TABLE_NAME</literal>) is generally
     <literal>VARCHAR(<replaceable>N</replaceable>) CHARACTER SET
     utf8</literal> where <replaceable>N</replaceable> is at least 64.
+    MySQL uses the default collation for this character set
+    (<literal>utf8_general_ci</literal>) for all searches, sorts,
+    comparisons, and other string operations on such columns. If the
+    default collation is not correct for your needs, you can force a
+    suitable collation with a <literal>COLLATE</literal> clause
+    (<xref linkend="charset-collate"/>).
   </para>
 
   <para>

@@ -281,10 +287,10 @@
     missing columns and some columns out of order. We are working on
     this and updating the documentation as changes are made.
   </para>
-  
+
   <para>
     For answers to questions that are often asked concerning the
-    <literal>INFORMATION_SCHEMA</literal> database, see 
+    <literal>INFORMATION_SCHEMA</literal> database, see
     <xref linkend="faqs-information-schema"/>.
   </para>