Importing

[harvillo]

I am importing from CSV records which in some instances may have characters such as commas and other characters. These characters obviously cause some fairly interesting results when imported via phpmyadmin or mysqlfront. Is there a something fundamental I'm missing to have sql ignore these nasty occurances? Essentially, I have several longtext description fields which, as expected, contain commas and other characters at times causing the import error. I'm trying to avoid writing an import script to strip chars.

Thanks

[bastien]

are you using the 'fields escaped by" character? its supposed to add a backslash to take care of those problems

[harvillo]

I'm using the following when importing from CSV.

Escaped by: \
Lines Terminated by: \n
Fields Terminated by: ,

[bastien]

escaped by should be a single slash, the second escapes the other slash...therefore leaving you in the situation you are in

change it to one slash

[harvillo]

Thanks!