Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2006
    Posts
    26

    Unhappy Unanswered: Load data Infile Data too long

    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??????????

  2. #2
    Join Date
    Jul 2004
    Posts
    62
    can you give a sample records that stuck, and your table structure

  3. #3
    Join Date
    Feb 2006
    Posts
    26
    Thanks for replying first of all.

    I got around the problem but thanks anyway..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •