Subject | RE: [IB-Conversions] mySql to Firebird varchar conversion error |
---|---|
Author | Paul Beach |
Post date | 2004-06-18T07:49:39Z |
<<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
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