On 4 Dec 2002, at 17:29, Tom Roos wrote: > when i load a binary file (filesize 49Kb) into a blob field, the function is > ok but when the filesize is 1.8Mb, the function fails and my programs > aborts.
There are two limits you should be concerned about. First a BLOB field has a maximum size of 65,535 bytes. For the data you're talking about, you'll need a MEDIUMBLOB, which can handle nearly 16 MB. For more about column sizes, see http://www.mysql.com/doc/en/Column_types.html Second, your query size cannot exceed the max_allowed_packet setting, which I believe is 1 MB by default. See http://www.mysql.com/doc/en/Packet_too_large.html Whether you want to store the data in your database or in a separate file is another issue, one that's frequently brought up on this list. For something so large, I would have to have a pretty good reason for choosing to store it in the database. -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org Phone 202-667-6653 --------------------------------------------------------------------- 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
