>-----Original Message----- >From: C.R.Vegelin [mailto:[EMAIL PROTECTED] >Sent: Friday, April 18, 2008 8:42 AM >To: mysql@lists.mysql.com >Subject: data truncation warnings by special characters > >Hi List, > >I get strange "Data truncated for column Description" warnings >when loading a tab separated file with special characters.
[JS] This sounds like it is related to the problems I've been having. I think I've come to an understanding of my issues, but I am not using LOAD DATA INFILE. I'll be posting what I have learnt, once I get a chance, but I don't know if it will help you. What is the source of your input data? Windows? Linux? >The definition of the target table is: > >CREATE TEMPORARY TABLE tmp >( Code CHAR(8) NOT NULL, > Description TEXT NOT NULL, > KEY Code (Code) >) ENGINE = MyISAM CHARSET=UTF8; > >The Load Into statement I use is: > >LOAD DATA INFILE 'D:/Input/Data.txt' INTO TABLE tmp >FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\r\n' IGNORE 0 LINES; > >The truncation warnings are caused by words like PURÉES. >This leads to a truncted Description field like: "Jams, Jellies, Pur". > >Any idea how to solve this ? > >Thanks in advance, Cor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]