> Please don't kick your cat.

I wouldnt really. I dont have one you see. But I might get one.

> Please do send a copy of the
> table definition that your program generated. The presence
> of blobs shouldn't have any effect.

Sorry, took a while until I was able to get to my MySQL server so I could run the transfer app. Heres the SQL it produces. The alter table is run only after a successfull creation bid.

create table trans1(
ID integer not null,
NAME varchar(60) not null,
SZ_ID smallint not null,
TYPE_ID smallint not null,
SZ_TYPE_SUB varchar(30),
HDT smallint not null,
HDN smallint not null,
HDM smallint not null,
HDH smallint not null,
INIT varchar(60) not null,
SPD varchar(120) not null,
SDF varchar(120) not null,
ARF varchar(120),
DARM varchar(120),
FRCH varchar(120) not null,
SA varchar(255),
SQ varchar(255),
SVS varchar(30) not null,
SVSF smallint,
SVSR smallint,
SVSW smallint,
AB varchar(50) not null,
S1 smallint,
S2 smallint,
S3 smallint,
S4 smallint,
S5 smallint,
S6 smallint,
SK blob sub_type 1 segment size 128,
FTS blob sub_type 1 segment size 128,
CLIM varchar(120) not null,
ORG blob sub_type 1 segment size 128,
CHR varchar(35) not null,
CHR_VALUE double precision not null,
TR varchar(120) not null,
AL varchar(60) not null,
ADV varchar(80),
DESCR blob sub_type 1 segment size 128,
DESCRG blob sub_type 1 segment size 128,
DESCR_C blob sub_type 1 segment size 128,
DESCR_SA blob sub_type 1 segment size 128,
DESCR_SK blob sub_type 1 segment size 128,
DESCR_FTS blob sub_type 1 segment size 128,
DESCR_CHR blob sub_type 1 segment size 128,
DESCR_CNS blob sub_type 1 segment size 128,
DESCR_TRA blob sub_type 1 segment size 128,
DESCR_CCA blob sub_type 1 segment size 128,
DFIRST smallint not null,
DVERSION varchar(32) not null,
SOURCE_NAME varchar(32) not null,
SOURCE_URL varchar(32) not null,
SOURCE_EMAIL varchar(32) not null,
SOURCE_ID integer not null,
CREATED date not null,
MODIFIED date not null,
MOD_ID integer not null,
DELETED_FLAG smallint not null);




alter table trans1 add constraint PK_TRANS1 primary key (ID);

> Do any of your other
> tables have blob fields?

Yes, but only two have this effect.

Thanks

Sean