View Single Post

   
  #7 (permalink)  
Old 02-28-2008, 08:37 AM
Ted
 
Posts: n/a
Default Re: Trouble with truncation error when loading data from a file

In my case, the issue seems to be related to the fact the field is
empty. All of the fields in all of the records prior to the problem
record, and all of the fields on the problem record prior to the
problem field, have proper data values. The field causing the problem,
on the record causing the problem, is empty (represented in the data
file by consecutive tabs).

Are there known issues in MySQL WRT how LOAD DATA INFILE handles
missing values?

Ted

Reply With Quote