List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:April 18 2008 1:30pm
Subject:RE: data truncation warnings by special characters
View as plain text  
>-----Original Message-----
>From: C.R.Vegelin [mailto:cr.vegelin@stripped]
>Sent: Friday, April 18, 2008 8:42 AM
>To: mysql@stripped
>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;
>
>This leads to a truncted Description field like: "Jams, Jellies, Pur".
>
>Any idea how to solve this ?
>
>Thanks in advance, Cor



Thread
data truncation warnings by special charactersC.R.Vegelin18 Apr
  • RE: data truncation warnings by special charactersJerry Schwartz18 Apr
  • RE: data truncation warnings by special charactersJerry Schwartz18 Apr
  • Re: data truncation warnings by special charactersC.R.Vegelin18 Apr
    • Re: data truncation warnings by special charactersChris W18 Apr
  • Re: data truncation warnings by special characters [SOLVED]C.R.Vegelin18 Apr