Dear Tom, > 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.
The communication buffer (between client and server) is set to 1 MByte by default. You can change this either by starting the server with a different option or by setting the appropriate variable in the my.cnf/my.ini file. I prefer the latter: [mysqld] set-variable = max_allowed_packet=16M The communication buffer cannot be larger than 16 MByte at this moment, but this might change in versions to come. HTH. -- Stefan Hinz <[EMAIL PROTECTED]> CEO / Geschäftsleitung iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: "Tom Roos" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, December 04, 2002 4:29 PM Subject: question about mysql_real_escape_string() > hi > > does this function handle a binary string of any length or is there some > sort of max limit. > > 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. using the debugger, the program aborts when in this function. > > if mysql_real_escape_string() has a max limit, how does one get around this? > could it be set in my.cnf, or somewhere else? or is this a case of bad > practise to load big (> 1Mb) into mysql? > > tks > tom > > _________________________________________________________________ > Add photos to your messages with MSN 8. Get 2 months FREE*. > http://join.msn.com/?page=features/featuredemail > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
