Hi, Try this. set session collation_database=latin1_swedish_ci; set session character_set_database=latin1;
regards anandkl On 10/29/07, Dušan Pavlica <[EMAIL PROTECTED]> wrote: > > 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 > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >