Truncated data LOAD DATA INFILE

1

I have a problem with load data, trying to insert the CSV file the data is truncated because in fields like comments or in the address.

LOAD DATA INFILE 'exemplo.csv'
                INTO TABLE relat_produt_analistas_temp
                FIELDS TERMINATED BY '\t'
                LINES TERMINATED BY '\r\n'
                IGNORE 1 LINES

This is the query I'm using. And as this report I get comes from another company, I can not change the way it is generated. does anyone know how I can delete commands \t and \r\n extras that should be the possible cause of the problem?

    
asked by anonymous 01.07.2015 / 14:59

0 answers