Richard Lynch wrote:
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.
The program I am using to import the data is the MySQL tools. They
don't like the output of phpMyAdmin 2.6.1-rc1. And I don't have any
control over the server so I can't upgrade the version either. Unless I
find a work around, I'm SOL
--
Chris W
KE5GIX
Gift Giving Made Easy
Get the gifts you want &
give the gifts they want
One stop wish list for any gift,
from anywhere, for any occasion!
http://thewishzone.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
