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

[paul]

Author: paul
Date: 2006-03-16 18:22:43 +0100 (Thu, 16 Mar 2006)
New Revision: 1606

Log:
 r8736@frost:  paul | 2006-03-16 11:22:03 -0600
 Indicate how to distinguish BINARY/CHAR, VARBINARY/VARCHAR, BLOB/TEXT
 using the C API.  (Check charset_nr == 63)


Modified:
   trunk/
   trunk/refman-4.1/apis.xml
   trunk/refman-5.0/apis.xml
   trunk/refman-5.1/apis.xml


Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:8732
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:3931
   + b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:8736
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:3931

Modified: trunk/refman-4.1/apis.xml
===================================================================
--- trunk/refman-4.1/apis.xml	2006-03-16 16:32:00 UTC (rev 1605)
+++ trunk/refman-4.1/apis.xml	2006-03-16 17:22:43 UTC (rev 1606)
@@ -1297,6 +1297,17 @@
 if (IS_NUM(field->type))
     printf("Field is numeric\n");
 </programlisting>
+
+          <para>
+            To distinguish between binary and non-binary data for string
+            data types, check whether the <literal>charset_nr</literal>
+            value is 63. If so, the character set is
+            <literal>binary</literal>, which indicates binary rather
+            than non-binary data. This is how to distinguish between
+            <literal>BINARY</literal> and <literal>CHAR</literal>,
+            <literal>VARBINARY</literal> and <literal>VARCHAR</literal>,
+            and <literal>BLOB</literal> and <literal>TEXT</literal>.
+          </para>
         </listitem>
 
       </itemizedlist>

Modified: trunk/refman-5.0/apis.xml
===================================================================
--- trunk/refman-5.0/apis.xml	2006-03-16 16:32:00 UTC (rev 1605)
+++ trunk/refman-5.0/apis.xml	2006-03-16 17:22:43 UTC (rev 1606)
@@ -1341,6 +1341,17 @@
 if (IS_NUM(field-&gt;type))
     printf("Field is numeric\n");
 </programlisting>
+
+          <para>
+            To distinguish between binary and non-binary data for string
+            data types, check whether the <literal>charset_nr</literal>
+            value is 63. If so, the character set is
+            <literal>binary</literal>, which indicates binary rather
+            than non-binary data. This is how to distinguish between
+            <literal>BINARY</literal> and <literal>CHAR</literal>,
+            <literal>VARBINARY</literal> and <literal>VARCHAR</literal>,
+            and <literal>BLOB</literal> and <literal>TEXT</literal>.
+          </para>
         </listitem>
 
       </itemizedlist>

Modified: trunk/refman-5.1/apis.xml
===================================================================
--- trunk/refman-5.1/apis.xml	2006-03-16 16:32:00 UTC (rev 1605)
+++ trunk/refman-5.1/apis.xml	2006-03-16 17:22:43 UTC (rev 1606)
@@ -1326,6 +1326,17 @@
 if (IS_NUM(field-&gt;type))
     printf("Field is numeric\n");
 </programlisting>
+
+          <para>
+            To distinguish between binary and non-binary data for string
+            data types, check whether the <literal>charset_nr</literal>
+            value is 63. If so, the character set is
+            <literal>binary</literal>, which indicates binary rather
+            than non-binary data. This is how to distinguish between
+            <literal>BINARY</literal> and <literal>CHAR</literal>,
+            <literal>VARBINARY</literal> and <literal>VARCHAR</literal>,
+            and <literal>BLOB</literal> and <literal>TEXT</literal>.
+          </para>
         </listitem>
 
       </itemizedlist>