On Tue, 3 Dec 2002, Roger Baklund wrote: > * 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.
True, but IMHO no severe limitation. The complete works of Shakespeare are 5346089 bytes in ASCII format. Who wants to put that into a single field? :-) Thomas Spahni > <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 > Filter: sql query --------------------------------------------------------------------- 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
