* Thomas Spahni > 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?
Nobody, hopefully. :) But maybe someone wants to store "Hamlet, the movie" in a db for some reason... what was considered a 'big amount' of data some years ago, is not considered as big today. My guess is that this trend will continue, and that people in the future will put more and bigger 'chunks' of data into tables/fields, presumably "rich media" like video and audio. >From time to time people ask on the list how big amounts of data they can store (in a db/table/row/field). Because of the existence of the LONGBLOB and LONGTEXT fields, people seem to think that they can actually store 4G of data in a single field. They can't do that with 3.23.x, I don't know if they can with 4.0.x. ...hm... I think the docs have been updated recently...: <URL: http://www.mysql.com/doc/en/Column_types.html > >From the description of LONGBLOB/LONGTEXT: "Note that because the server/client protocol and MyISAM tables has currently a limit of 16M per communication packet / table row, you can't yet use this the whole range of this type." It does not say that this goes for 3.23.x only.... does anyone know? It seems to be in conflict with this page: <URL: http://www.mysql.com/doc/en/Packet_too_large.html > "In MySQL 4.0.1 and up, this is only limited by the amount on memory you have on your server (up to a theoretical maximum of 2G)." -- 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
