Oracle to mySQL migration : Data truncation: Data too long for column

[Srini Raghavan]

Greetings ,

I am trying to migrate a table from Oracle 9.2 into MySQL 5.0.15 using Migration toolkit ver 1.1.11

I get the following error everytime :

Data truncation: Data too long for column 'comments' at row 266

If I save the file as a .sql file and upload it using the MySQL query browser - Open script - execute then it works.However this method cannot be applied to very large tables since the query browser window freezes.

However I do not understand why I am getting the error using the migration toolkit.The original datatype in oracle is varchar2(4000) and the corresponding datatype in mySQL is LONGTEXT.The maximum length of a value in the column is 195 , so the datatype LONGTEXT should be sufficient.

PLEASE HELP .

Srini