Re: phpmyadmin problems with quoting exported text

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