From: Dušan Pavlica
Date: October 29 2007 7:26am
Subject: Re: load data infile and character set
List-Archive: http://lists.mysql.com/mysql/209751
Message-Id: <47258B1E.4000306@unidataz.cz>
MIME-Version: 1.0
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit

Are you sure your file is coded in utf8? Character set of your file must 
be same as charset of your database.

Dusan

Caleb Racey napsal(a):
> Does anyone know how to get the load data infile command to load utf8 data?
>
> I have setup a database as utf8 with a collation of utf8_general_ci,   the
> mysqld server is started with --character-set-server=utf8. Server variables
> say character_set_database = utf8. I use the sql below
>
> LOAD DATA INFILE 'filename' REPLACE INTO TABLE db.table CHARACTER SET utf8
> FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'
>
> Yet when i try to load a file with an accented value in it e.g. "Agustín"
> the value gets truncated to "Agust"
>
> anyone got any solutions to this?
>
> Regards
>
> Cal
>
>