data truncation warnings by special characters

[C.R.Vegelin]

Hi List,

I get strange "Data truncated for column Description" warnings
when loading a tab separated file with special characters.
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