HI all,
I,m using mysql version 5 and trying to do a import
SQL
USE witnessdw;
LOAD DATA INFILE 'c:/extract.txt'
INTO TABLE witnessdw.evaluationgi
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
IGNORE 1 LINES;
Error
Recieveing this message
Data too long for column 'Form Master Obj Ouid' at row 1 ///error 1406

Note:
The field type of the table is varchar(50)
But the maximum character in the text file field is not more than 15 characters


Any ideas??????????

can you give a sample records that stuck, and your table structure

Thanks for replying first of all.

I got around the problem but thanks anyway..