TEXT field issue

[Matt Jenneson]

Hello all,

I'm trying to export from MSSQL to MYSQL using DTS. Everything works fine except for large text fields.

I have played around with changing the type of field in MSSQL to varchar rather than text, the dts fails unless i change the field in MYSQL to varchar, but 255 is not enough.

Think it might be a problem with the ODBC.

Does that make sense to anyone? any ideas?


Thanks



Edited 1 time(s). Last edit at 10/05/2007 05:41AM by Matt Jenneson.