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 mailmessagetext_table; For the field messagetext - varchar(7900), it only migrated few characters, not the complete length Please help Thanks Roma --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
