Dana Monday 19. March 2007. 17:19:57 Jer napisa: > I've got a CSV file in which I need to use double quotes and import into > MySQL. However, I've > tried using a \ in front of each quote. I've tried using the HTML code. > > The \ doesn't work (and it's not something I want to mess with during data > entry). > > The HTML code gives a parse error. > > Any ideas? > > Jeremy
If you can export CSV file yourself and have access to it you may try and use apostrophe ( ' ) as field delimiter. After that edit CSV file and check how quotes are represented (possibly as quadriple apostrophe). Search/replace quotes representation with "real" quotes and than try importing CSV into MySQL. During all these operations please bear in mind that you have to use proper encodings for editing and mysql connection. Regards, -- Bratislav Velickovic http://blog.velickovic.net
