Hello, I have a table in which one of the column types has been declared as mediumtext to hold blocks of text averaging 250k in size. A mediumtext datatype should be able to hold > 16 million characters. However, I found my inserts failing when some of my strings exceeded 1 MB (e.g. a string of 1125921 bytes fails, while a string of 1009684 bytes succeeds).
I've been using this table for months, but recently some of my records grew to greater than 1 MB, and suddenly my inserts stopped working. Is there a bug with mediumtext such that it holds less than the advertised max? I'm using MySQL 3.23.56 on Linux RedHat 8, and have tried inserts via Perl DBI as well as via SQL command line. -Chris Seidel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
