transfer mssql varchar to mysql text

[Cristian Dinu]

Hello,

I hope to find here o solution to my problem. I tried to copy a small table from MSSQL 2000 to MySql 4.1 using DTS. I'm using MySql ODBC 3.51 Driver. Here are the 2 tables:

MSSQL table: col(1) - int, col(2) - char(20), col(3) - varchar(1000)
MySql table: col(1) - int(11), col(2) - varchar(20), col(3) - text

If I try to transfer only first 2 columns everything is OK. If I add the third column all I get is an error. I tried to change the varchar(1000) to text type, but nothing is changed.

The only solution that I found was to use a local MySql 5.0 and change text to varchar(1000) type, but I need to connect to a hosting site and I cannot change their MySql version.

Is there any solution?
Thanks,
Cristian