I am trying to load fields with quite large data into a MySQL database. Some of the data in the fields has single quotation marks. I need to retain those quotation marks, but when I load the data with 'load data ....' the field terminates when it meets the first quotation mark. The actual field teminator is not affected, the next field starts at the right position. What it does is truncate the data in the field and refuse to go past the quotation mark. If I load the data with 'insert...' it works fine and retains the quotation marks. However I have several thousand rows to load and insert would be far too long winded. Why does 'load data ' fail like this and is there anything I can do about it? Also is there anyway to see what the warnings mean? The documentation seems to suggest there isn't, but that seems just plain silly.

Bob

It sounds very much like you need to re-assess you LOAD DATA query to include some extra instructions like FIELDS ESCAPED BY etc, without seeing it, it is hard to properly assess what the problem is

This link might help

Regards

Ian

Thanks. It put me on the right track. I couldn't make any difference with the enclosed by or escaped by clauses but it was clear it was using quotation marks as special characters, so I globally escaped them in my loadfile and they all load in properly now. Wish I could see what the warnings meant it would make these things easier. Oracle writes the warnings to an error file in its load function, don't know why mysql can't do the same.

Bob