Importing text data from SQLServer in Mysql

[gareth gale]

Hi,

Has anyone got any ideas on how to import a table that I have in SQLServer 2000 into MySQL that contains a (SQLServer) "text" column ? Here's the (SQLServer) sample table structure :-

id - int
details - text

The target table in mySQL looks similar, i.e.

id - int
details - longblob

Can you use the mysqlimport utility for this ? If so, given that the text field contains single and double quotes, as well as carriage returns and line feeds, how do you specify it ?

Thanks