Posted by "Richard Lynch" on 10/21/82 11:31

On Sun, November 6, 2005 2:17 am, Chris W wrote:
> I just tried to use the output of the export function on phpmyadmin
> and
> got a million errors. After looking at the file I found that certain
> columns that are strings were not quoted at all. I can't find any
> reason why some are and some are not quoted. Anyone have any idea why
> this is happening?

Because unless a field contains a ',' or '"' character, it doesn't
NEED quotes to delineate it:

1,test,3
1,"I said,""It's not the same""",3

is the same thing as:
1,"test",3
1,"I said,""It's not the same""",3

Your import function is BROKEN in a major way, by requiring quotes
where they are not strictly necessary to conform to the CSV
specification.

That said, it's probably easier to get phpMyAdmin to always quote the
output than it is to fix whatever broken import tool you are using.

--
Like Music?
http://l-i-e.com/artists.htm

[Back to original message]