Keith was right, the error on inserting large strings into mediumtext had to do with the variable max_allowed_packet. The defualt value can be seen by: mysql> show variables like "max_allowed_p%" and the default value was 1048576.
Thus I had to reset the max_allowed_packet size to allow for larger packets by restarting the server with /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf --set-variable max_allowed_packet=10M >/dev/null 2>&1 & To do this I edited the mysqld file in /etc/init.d so that this variable will be set whenever safe_mysqld starts up. I would have thought this could be specified in my.cnf, but it doesn't seem so. I can now insert large entreis into a mdeiumtext field with no problems. Thanks! Chris On Mon, 5 Jan 2004, Chris Seidel wrote: > 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]
