Problem importing data from SQL server 2000 to mysql

Hi guys, I want to migrate data from SQL Server 2000 to Mysql.I have two problems. First is easy one, First problem is to migrate big fields which had type varchar(7900) or so I tried using Text datatype of mysql, is that the right one or I should have used BLOB. That field doesnt contain any

Problem importing data from SQL server 2000 to mysql

Hi guys, I want to migrate data from SQL Server 2000 to Mysql. My problem is to migrate big fields which had type varchar(7900) or so I tried using Text datatype of mysql, then I cant migrate data in that field I used command LOAD DATA INFILE c:/mysql/roma/mailmessagetext_table.txt INTO TABLE

Problem importing data from SQL server 2000 to mysql

Hi, I want to migrate data from SQL Server 2000 to Mysql. My problem is to migrate big fields which had type varchar(7900) or so I tried using Text datatype of mysql, then I cant migrate data in that field I used command LOAD DATA INFILE c:/mysql/roma/mailmessagetext_table.txt INTO TABLE