MySQL CVS File Load Question

[Anon]

I am using the following MySQL command to load a delimited file into a MySQL table:
LOAD DATA LOCAL INFILE "SIRextract.txt" INTO TABLE issues
FIELDS
TERMINATED BY ','
ENCLOSED BY '\"'
LINES TERMINATED BY '\n'

Each line in the input file is terminated by a carriage return & line feed (Ascii 13 & 10), which I understand is equivalent to "new line".

My load statement appears to load every other line, so I assume it is something to do with my line termination. Any insights?

[Anon]

Correction: It is not every other record, as I stated. For parts of the data it is every other record, but in some cases it does not skip a record and in other cases it skips one or two records. Now, I am thinking that I must have some "unfriendly" character in the data records that are being dropped.

Several loaded records contain text with a single quote ('), so I assume this is not an offender.

[Anon]

Second Correction: It does skip every other record (this symptom escaped me at first because the order of result set returned from the query is different than the order in the source database).

The problem is, in fact, due to differences between Windows and UNIX interpretations of NEW LINE. On Windows (Excel & Access), new lines are created by adding two characters, ASCII 10 and 13 (Carriage return and line feed). The second character causes MySQL to skip the following line. If I delete all the carriage returns, all the records are imported.