Chris, you should set max_packet_size in my.cnf.
Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com/ ----- Original Message ----- From: "Chris Seidel" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Monday, January 05, 2004 11:07 PM Subject: mediumtext crash on strings > 1MB? > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]