Hosting Provided By

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

From: <paul(at)mysql.com>
Date: Tue Jul 31 2007 - 13:37:46 EDT

Author: paul
Date: 2007-07-31 19:37:42 +0200 (Tue, 31 Jul 2007) New Revision: 7289

Log:
r28079@polar: paul | 2007-07-31 11:05:48 -0500 LOAD DATA INFILE interprets all fields as having the same character set, regardless of the data types of the target table.

Modified:

   trunk/refman-4.1/sql-syntax.xml
   trunk/refman-5.0/sql-syntax.xml
   trunk/refman-5.1/sql-syntax.xml
   trunk/refman-5.2/sql-syntax.xml

Property changes on: trunk

Name: svk:merge

4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:28041 7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:23143 b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218 bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:18941 + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:28079 7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:23143 b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218 bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:18941

Modified: trunk/refman-4.1/sql-syntax.xml

trunk/refman-4.1/sql-syntax.xml 2007-07-31 17:36:02 UTC (rev 7288) +++ trunk/refman-4.1/sql-syntax.xml 2007-07-31 17:37:42 UTC (rev 7289) Changed blocks: 1, Lines Added: 18, Lines Deleted: 3; 1776 bytes

@@ -5312,12 +5312,27 @@

         As of MySQL 4.1, the character set indicated by the
         character_set_database system variable is
         used to interpret the information in the file. SET
-        NAMES and the setting of
-        character_set_client do not affect
-        interpretation of input.
+        NAMES and the setting of the
+        character_set_client system variable do not
+        affect interpretation of input.
       
 
       
+        LOAD DATA INFILE interprets all fields in the
+        file as having the same character set, regardless of the data
+        types of the columns into which field values are loaded. For
+        proper interpretation of file contents, you must ensure that it
+        was written with the correct character set. For example, if you
+        write a data file with mysqldump -T or by
+        issuing a SELECT ... INTO OUTFILE statement
+        in mysql, be sure to use a
+         option with
+        mysqldump or mysql so that
+        output is written in the character set to be used when the file
+        is loaded with LOAD DATA INFILE.
+      
+
+      
         Note that it is currently not possible to load data files that
         use the ucs2 character set.

Modified: trunk/refman-5.0/sql-syntax.xml

trunk/refman-5.0/sql-syntax.xml 2007-07-31 17:36:02 UTC (rev 7288) +++ trunk/refman-5.0/sql-syntax.xml 2007-07-31 17:37:42 UTC (rev 7289) Changed blocks: 1, Lines Added: 15, Lines Deleted: 0; 1282 bytes

@@ -5305,6 +5305,21 @@

Do you need help?

</para>

       
+        LOAD DATA INFILE interprets all fields in the
+        file as having the same character set, regardless of the data
Do you need more help? 
In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software:Learn more about Pantek's Technical Support offerings
Place an order for 24/7/365 Technical Support here
Learn more about Pantek, who we are, and what we do
Chat with a Live Operator
Related lists.mysql.com Links
announce
benchmarks
bugs
certification
cluster
commits
dotnet
gui-tools
internals
java
maxdb
myodbc
mysql
mysqldoc
packagers
perl
plusplus
replication
win32
Request more information about Pantek
+        types of the columns into which field values are loaded. For
+        proper interpretation of file contents, you must ensure that it
+        was written with the correct character set. For example, if you
+        write a data file with mysqldump -T or by
+        issuing a SELECT ... INTO OUTFILE statement
+        in mysql, be sure to use a
+         option with
+        mysqldump or mysql so that
+        output is written in the character set to be used when the file
+        is loaded with LOAD DATA INFILE.
+      
+
+      
         Note that it is currently not possible to load data files that
         use the ucs2 character set.

Modified: trunk/refman-5.1/sql-syntax.xml

trunk/refman-5.1/sql-syntax.xml 2007-07-31 17:36:02 UTC (rev 7288) +++ trunk/refman-5.1/sql-syntax.xml 2007-07-31 17:37:42 UTC (rev 7289) Changed blocks: 1, Lines Added: 15, Lines Deleted: 0; 1282 bytes

@@ -7175,6 +7175,21 @@

</para>

       
+        LOAD DATA INFILE interprets all fields in the
+        file as having the same character set, regardless of the data
+        types of the columns into which field values are loaded. For
+        proper interpretation of file contents, you must ensure that it
+        was written with the correct character set. For example, if you
+        write a data file with mysqldump -T or by
+        issuing a SELECT ... INTO OUTFILE statement
+        in mysql, be sure to use a
+         option with
+        mysqldump or mysql so that
+        output is written in the character set to be used when the file
+        is loaded with LOAD DATA INFILE.
Can we help you? 
In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software:Learn more about Pantek's Technical Support offerings
Place an order for 24/7/365 Technical Support here
Learn more about Pantek, who we are, and what we do
Chat with a Live Operator
Related lists.mysql.com Links
announce
benchmarks
bugs
certification
cluster
commits
dotnet
gui-tools
internals
java
maxdb
myodbc
mysql
mysqldoc
packagers
perl
plusplus
replication
win32
Request more information about Pantek
+      
+
+      
         Note that it is currently not possible to load data files that
         use the ucs2 character set.

Modified: trunk/refman-5.2/sql-syntax.xml

trunk/refman-5.2/sql-syntax.xml 2007-07-31 17:36:02 UTC (rev 7288) +++ trunk/refman-5.2/sql-syntax.xml 2007-07-31 17:37:42 UTC (rev 7289) Changed blocks: 1, Lines Added: 15, Lines Deleted: 0; 1282 bytes

@@ -7182,6 +7182,21 @@

</para>

       
+        LOAD DATA INFILE interprets all fields in the
+        file as having the same character set, regardless of the data
+        types of the columns into which field values are loaded. For
+        proper interpretation of file contents, you must ensure that it
+        was written with the correct character set. For example, if you
+        write a data file with mysqldump -T or by
+        issuing a SELECT ... INTO OUTFILE statement
+        in mysql, be sure to use a
+         option with
+        mysqldump or mysql so that
+        output is written in the character set to be used when the file
+        is loaded with LOAD DATA INFILE.
+      
+
+      
         Note that it is currently not possible to load data files that
         use the ucs2 character set.

-- 
MySQL Code Commits Mailing List
For list archives: 
http://lists.mysql.com/commits
To unsubscribe:    
http://lists.mysql.com/commits?unsub=lists@pantek.com

Received on Tue Jul 31 13:38:04 2007

This message: [ Message body ]
Next message: paul(at)mysql.com: "svn commit - mysqldoc@docsrva: r7290 - in trunk: . dynamic-docs/command-optvars"
Previous message: paul(at)mysql.com: "svn commit - mysqldoc@docsrva: r7288 - in trunk: . refman-5.1"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Thu Aug 09 2007 - 19:20:03 EDT

Can't find what you're looking for?