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".

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.049 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.