MySQL skipping one column with LOAD DATA INFILE

Hello all,

I am troubleshooting a maddening problem with MySQL 5.0.18-nt on my XP
Pro dev
box. When running a LOAD DATA INFILE... command, it works correctly
when
executed from the MySQL command line, but skips one column (yet loads
the rest
of the table normally) when the exact same command is run from within
PHP5.

Has anyone experienced this? Or better yet, resolved it? Anybody know
why it's
happening?

The table in question is:

CREATE TABLE clean_events (
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY
KEY,
record_status ENUM('INCOMPLETE','NEW','OK') NOT NULL DEFAULT
'INCOMPLETE',
recycle_status ENUM('ACTIVE','RECYCLED','DELETED') NOT NULL
DEFAULT
'ACTIVE',
event_name VARCHAR(255) DEFAULT NULL,
artist_ids VARCHAR(255) DEFAULT NULL,
venue_id INT(10) UNSIGNED NOT NULL DEFAULT '0',
start_date DATE NOT NULL DEFAULT '0000-00-00',
end_date DATE NOT NULL DEFAULT '0000-00-00',
ticket_urls TEXT,
notes TEXT
);

The 'artist_ids' column is the one being skipped.

Any ideas?

Regards,
-Ray

Ray wrote:
> Hello all,
>
> I am troubleshooting a maddening problem with MySQL 5.0.18-nt on my XP
> Pro dev
> box. When running a LOAD DATA INFILE... command, it works correctly
> when
> executed from the MySQL command line, but skips one column (yet loads
> the rest
> of the table normally) when the exact same command is run from within
> PHP5.
>
> Has anyone experienced this? Or better yet, resolved it? Anybody know
> why it's
> happening?
>
> The table in question is:
>
> CREATE TABLE clean_events (
> id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY
> KEY,
> record_status ENUM('INCOMPLETE','NEW','OK') NOT NULL DEFAULT
> 'INCOMPLETE',
> recycle_status ENUM('ACTIVE','RECYCLED','DELETED') NOT NULL
> DEFAULT
> 'ACTIVE',
> event_name VARCHAR(255) DEFAULT NULL,
> artist_ids VARCHAR(255) DEFAULT NULL,
> venue_id INT(10) UNSIGNED NOT NULL DEFAULT '0',
> start_date DATE NOT NULL DEFAULT '0000-00-00',
> end_date DATE NOT NULL DEFAULT '0000-00-00',
> ticket_urls TEXT,
> notes TEXT
> );
>
> The 'artist_ids' column is the one being skipped.
>
> Any ideas?
>
> Regards,
> -Ray
>

You missed two important pieces, Ray.

What do your data and your LOAD FILE command look like?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================