From: Gavin Towey (gtoweyffn.com)
Date: Wed Sep 16 2009 - 18:30:59 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi Tim,

Try using LOAD DATA INFILE from the mysql CLI. PMA can often introduce unexpected behavior for export/import.

Regards,
Gavin Towey

-----Original Message-----
From: Tim Thorburn [mailto:webmasterathydro.com]
Sent: Wednesday, September 16, 2009 7:14 AM
To: mysqllists.mysql.com
Subject: Importing CSV into MySQL

Hi,

I'm sure I'm missing something quite obvious here, but the caffeine
hasn't quite kicked in yet. As the subject says, I'm importing a csv
file into MySQL 5.1.36 on WinXP using phpMyAdmin 3.3.2 (Apache 2.2.11
and PHP 5.3.0 should it matter). I've done this many times, however I'm
now getting a strange error regarding a character in my csv file. I've
tried both MyISAM and InnoDB tables (I don't think that would make any
difference) and switching between utf8_general_ci and utf8_unicode_ci
(thought this might make a difference, but sadly no).

The error message I get is |#1366 - Incorrect string value: '\xE8s' when
it attempts to insert the word Radès. I'm using a simple varchar,
nothing really special there. After googling for awhile it seems the
most common option is to use PHP to convert the character into UTF8
format before putting it into MySQL - the problem is some of these csv's
are several hundred mb a piece so I'd much rather simply import than go
this route.

Any thoughts?

TIA,
-Tim
|

The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]