Posted by Chris W on 10/20/50 11:31

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

[Back to original message]