Bug #1886 Load csv file using utf8
Submitted: 19 Nov 2003 3:28 Modified: 21 Dec 2003 10:40
Reporter: [ name withheld ] Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S2 (Serious)
Version:4.1.0 OS:Linux (Linux)
Assigned to: Assigned Account CPU Architecture:Any

[19 Nov 2003 3:28] [ name withheld ]
Description:
I have a problem when I load a .csv file (UTF-8 datas). 

How to repeat:
#mysql --user=root password=root database;
#set character set utf8;
#load data infile '/usr/share/mysql/a.csv' into table database.xxx fields terminated by ',' enclosed by '"' lines terminated by '\r\n';

When I do "select * from a where xxx=_utf8'10';", 
I got datas which were not utf8 datas.
[21 Nov 2003 10:40] Dean Ellis
Can you try this with MySQL compiling from our latest 4.1.1 sources from either our BitKeeper repository or our daily source snapshots?

If not, please attach a test case with your CREATE TABLE and LOAD DATA statements, along with a sample of data which demonstrates the problem.

Thank you
[14 Feb 2005 22:54] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".