Did you try LONGBLOB?
We use MySQL, SQLServer, and Oracle here and keep the equivalent of Oracle
CLOB data in LONGBLOB columns in MySQL and in TEXT columns in SQLServer. We
move data back and forth with no problem.
--Walt Weaver
Bozeman, Montana
-----Original Message-----
From: Ekins, Phil [mailto:pekins@stripped]
Sent: Tuesday, May 07, 2002 1:00 PM
To: mysql@stripped
Subject: Converting SQLServer 7.0 db to MySQL
My problem is finding an equivalent field for the "TEXT" data type in
SQLServer...
non of the datatypes I tried would hold the amount of characters I need...
Help!
---------------------------------------------------------------------
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 <mysql-thread108266@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-wweaver=rightnow.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php