Author: paul
Date: 2007-11-06 21:06:10 +0100 (Tue, 06 Nov 2007)
New Revision: 8557
Log:
r32403@polar: paul | 2007-11-06 12:50:33 -0600
Move warning tag, revise wording.
Modified:
trunk/refman-4.1/sql-syntax.xml
trunk/refman-5.0/sql-syntax.xml
trunk/refman-5.1/sql-syntax.xml
trunk/refman-6.0/sql-syntax.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:32401
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:26562
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:21581
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:32403
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:26562
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:21581
Modified: trunk/refman-4.1/sql-syntax.xml
===================================================================
--- trunk/refman-4.1/sql-syntax.xml 2007-11-06 18:25:44 UTC (rev 8556)
+++ trunk/refman-4.1/sql-syntax.xml 2007-11-06 20:06:10 UTC (rev 8557)
Changed blocks: 1, Lines Added: 9, Lines Deleted: 8; 1640 bytes
@@ -812,25 +812,26 @@
<warning>
<para>
- The preceding operation converts column values between the
- character sets. This is <emphasis>not</emphasis> what you
- want if you have a column in one character set (like
+ The <literal>CONVERT TO</literal> operation converts
+ column values between the character sets. This is
+ <emphasis>not</emphasis> what you want if you have a
+ column in one character set (like
<literal>latin1</literal>) but the stored values actually
use some other, incompatible character set (like
<literal>utf8</literal>). In this case, you have to do the
following for each such column:
</para>
- </warning>
<programlisting>
ALTER TABLE t1 CHANGE c1 c1 BLOB;
ALTER TABLE t1 CHANGE c1 c1 TEXT CHARACTER SET utf8;
</programlisting>
- <para>
- The reason this works is that there is no conversion when
- you convert to or from <literal>BLOB</literal> columns.
- </para>
+ <para>
+ The reason this works is that there is no conversion when
+ you convert to or from <literal>BLOB</literal> columns.
+ </para>
+ </warning>
<para>
If you specify <literal>CONVERT TO CHARACTER SET
Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml 2007-11-06 18:25:44 UTC (rev 8556)
+++ trunk/refman-5.0/sql-syntax.xml 2007-11-06 20:06:10 UTC (rev 8557)
Changed blocks: 1, Lines Added: 9, Lines Deleted: 8; 1640 bytes
@@ -858,25 +858,26 @@
<warning>
<para>
- The preceding operation converts column values between the
- character sets. This is <emphasis>not</emphasis> what you
- want if you have a column in one character set (like
+ The <literal>CONVERT TO</literal> operation converts
+ column values between the character sets. This is
+ <emphasis>not</emphasis> what you want if you have a
+ column in one character set (like
<literal>latin1</literal>) but the stored values actually
use some other, incompatible character set (like
<literal>utf8</literal>). In this case, you have to do the
following for each such column:
</para>
- </warning>
<programlisting>
ALTER TABLE t1 CHANGE c1 c1 BLOB;
ALTER TABLE t1 CHANGE c1 c1 TEXT CHARACTER SET utf8;
</programlisting>
- <para>
- The reason this works is that there is no conversion when
- you convert to or from <literal>BLOB</literal> columns.
- </para>
+ <para>
+ The reason this works is that there is no conversion when
+ you convert to or from <literal>BLOB</literal> columns.
+ </para>
+ </warning>
<para>
If you specify <literal>CONVERT TO CHARACTER SET
Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml 2007-11-06 18:25:44 UTC (rev 8556)
+++ trunk/refman-5.1/sql-syntax.xml 2007-11-06 20:06:10 UTC (rev 8557)
Changed blocks: 1, Lines Added: 9, Lines Deleted: 8; 1642 bytes
@@ -1393,25 +1393,26 @@
<warning>
<para>
- The preceding operation converts column values between the
- character sets. This is <emphasis>not</emphasis> what you
- want if you have a column in one character set (like
+ The <literal>CONVERT TO</literal> operation converts
+ column values between the character sets. This is
+ <emphasis>not</emphasis> what you want if you have a
+ column in one character set (like
<literal>latin1</literal>) but the stored values actually
use some other, incompatible character set (like
<literal>utf8</literal>). In this case, you have to do the
following for each such column:
</para>
- </warning>
<programlisting>
ALTER TABLE t1 CHANGE c1 c1 BLOB;
ALTER TABLE t1 CHANGE c1 c1 TEXT CHARACTER SET utf8;
</programlisting>
- <para>
- The reason this works is that there is no conversion when
- you convert to or from <literal>BLOB</literal> columns.
- </para>
+ <para>
+ The reason this works is that there is no conversion when
+ you convert to or from <literal>BLOB</literal> columns.
+ </para>
+ </warning>
<para>
If you specify <literal>CONVERT TO CHARACTER SET
Modified: trunk/refman-6.0/sql-syntax.xml
===================================================================
--- trunk/refman-6.0/sql-syntax.xml 2007-11-06 18:25:44 UTC (rev 8556)
+++ trunk/refman-6.0/sql-syntax.xml 2007-11-06 20:06:10 UTC (rev 8557)
Changed blocks: 1, Lines Added: 9, Lines Deleted: 8; 1642 bytes
@@ -1374,25 +1374,26 @@
<warning>
<para>
- The preceding operation converts column values between the
- character sets. This is <emphasis>not</emphasis> what you
- want if you have a column in one character set (like
+ The <literal>CONVERT TO</literal> operation converts
+ column values between the character sets. This is
+ <emphasis>not</emphasis> what you want if you have a
+ column in one character set (like
<literal>latin1</literal>) but the stored values actually
use some other, incompatible character set (like
<literal>utf8</literal>). In this case, you have to do the
following for each such column:
</para>
- </warning>
<programlisting>
ALTER TABLE t1 CHANGE c1 c1 BLOB;
ALTER TABLE t1 CHANGE c1 c1 TEXT CHARACTER SET utf8;
</programlisting>
- <para>
- The reason this works is that there is no conversion when
- you convert to or from <literal>BLOB</literal> columns.
- </para>
+ <para>
+ The reason this works is that there is no conversion when
+ you convert to or from <literal>BLOB</literal> columns.
+ </para>
+ </warning>
<para>
If you specify <literal>CONVERT TO CHARACTER SET
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r8557 - in trunk: . refman-4.1 refman-5.0 refman-5.1 refman-6.0 | paul | 6 Nov |
