Subject RE: [IB-Conversions] mySql to Firebird varchar conversion error
Author Paul Beach
<<Installed Firebird yesterday and now trying to convert
mysql database to firebird. I'm using dbpump tool utility.
On dbpump utility in 'generate sql' screen the field convert
option for String is:
if String length < 5 then CHAR else VARCHAR

I'm getting following error in generated .sql file

/* !!! Error: Unable get fields list for table archive: Invalid field
size */
/* Original table name is "archive" */
CREATE TABLE "archive" (
"AT_Id" INTEGER /* "AT_Id" */ ,
"AT_MM" INTEGER /* "AT_MM" */ ,
"IL_Side_Option" INTEGER /* "IL_Side_Option" */ ,
"AT_IL" INTEGER /* "AT_IL" */ ,
"AT_IO1" INTEGER /* "AT_IO1" */ ,
"AT_OT1" INTEGER /* "AT_OT1" */ ,
"AT_Emp" CHAR(-1) /* "AT_Emp" */ <<<<<<<< Error here
);

Actual MySql table:

CREATE TABLE `archive` (
`AT_Id` int(10) unsigned NOT NULL auto_increment,
`AT_MM` tinyint(2) unsigned default '0',
`IL_Side_Option` int(2) unsigned default '0',
`AT_IL` int(10) unsigned default '0',
`AT_IO1` mediumint(4) unsigned default '0',
`AT_OT1` mediumint(4) unsigned default '0',
`AT_Emp` varchar(25) default '0', <<<<<<<<< ACTUAL
`AT_Due` tinyint(1) unsigned default '0',
... there are about 80 fields in this table..>>

Don't know anything about dbpump, but I can tell you that a
CHAR(1) is not a valid column definition.... in any database
that I know.

Paul