Bug #1278 LOAD DATA + SET NAMES

• Submitted: 14 Sep 2003 21:56
• Modified: 22 Nov 2010 7:25
• Reporter: Georg Richter
• Status: Closed
• Category: MySQL Server
• Severity: S4 (Feature request)
• Version: 4.1.1
• OS: Any
• Assigned to: Alexander Barkov
• CPU Architecture: Any

[14 Sep 2003 21:56] Georg Richter

Description:
LOAD DATA ingores  SET NAMES. 
 

How to repeat:
mysql> set names cp850; 
Query OK, 0 rows affected (0.07 sec) 
 
mysql> load data infile '/home/georg/work/dpa/appdb/umzug/x.x' into table b; 
Query OK, 1 row affected (0.00 sec) 
Records: 1  Deleted: 0  Skipped: 0  Warnings: 0 
 
mysql> select * from b; 
+------------+ 
| a          | 
+------------+ 
 |N?rtingen 
+------------+ 
1 row in set (0.00 sec) 
 
File x.x 
N~Artingen

[19 Dec 2003 6:55] Alexander Barkov

This is not a bug. This is missing of a feature.
We need to extend LOAD DATA INFILE with some syntax
to specify the character set of the file being loaded.
I have added a worklog item for this. 
I'm closing this bug ticket as "not a bug".

Georg, thank you for testing and reporting!

[19 Dec 2003 7:58] Georg Richter

changed status

[22 Nov 2010 7:25] Alexander Barkov

"LOAD DATA INFILE ... CHARACTER SET" syntax was added at some point of the past.
Closing the report.