* Simon Green > A LONGBLOB can store 4294967295 bytes > A LONGTEXT can srote 4294967295 bytes
In theory, yes. But not for real. MySQL 3.23.x has a limitation on the max_allowed_packet parameter, the max setting is 16M. This will prevent any single field from containing more than 16M. This limitation was removed in 4.0.1. <URL: http://www.mysql.com/doc/en/Packet_too_large.html > > -----Original Message----- > From: Grant Cooper [mailto:[EMAIL PROTECTED]] > Sent: 03 December 2002 11:20 > To: [EMAIL PROTECTED] > Subject: MYSQL and large fields > > > We have switched over from Microsoft Access to MySQL because we > were unable > to store large files. 2-3 pages of written text. But M. Access 2-3 pages is 'nothing', probably less than 10K. You should not see any problems. -- Roger --------------------------------------------------------------------- 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