Re: phpmyadmin problems with quoting exported text

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux