The Joys of an Unspecified Format

I’m currently importing batches of CSV (comma separated value) data into a MySQL database, using phpmyadmin.

As you might expect, phpmyadmin has a default character to “separate” the “values”. As you might not expect, the default is… a semicolon.

This entry was posted on Tuesday, May 15th, 2007 at 3:33 am and is filed under Web Dev. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

jennie

that's great. stupidly great. or greatly stupid.
Geoff

hrmm, I *might* have guessed at a different value separator, but I have been known to be lax in my interpretation when it comes to these things. Perhaps they should call it Delimiter Separated Value instead?

diary of an indie game developer

The Joys of an Unspecified Format