List:General Discussion« Previous MessageNext Message »
From:Caleb Racey Date:October 26 2007 1:34pm
Subject:load data infile and character set
View as plain text  
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

Thread
load data infile and character setCaleb Racey26 Oct
  • Re: load data infile and character setmysql26 Oct
  • Re: load data infile and character setBaron Schwartz26 Oct
  • Re: load data infile and character setDuĊĦan Pavlica29 Oct
    • Re: load data infile and character setAnanda Kumar29 Oct
      • Re: load data infile and character setmysql29 Oct
Re: load data infile and character setBaron Schwartz26 Oct