The real answer, yes. It has a limit of several GB, depending on your OS. It can take a huge string containing MBytes of BLOB data.
Just for grins, I loaded several MB of image data this way just to prove to myself that you could do it. The practical answer is then pretty much no. (Probably would run into a TCP/IP message length limitation first) I'm pretty sure the on-line documentation spells that out, or it is in the MySQL New Riders book, or the MySQL O'Reilly book. Also, If your are going to load lots of binary data, you need to be sure and use mysql_escape_string() to pass your data before building sending the query, and look at using mysql_real_query() rather than mysql_query(). It takes a length argument and is supposed to be faster, although I haven't personally looked at speed differences. Ken -----Original Message----- From: Edilson Vasconcelos de Melo Junior [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 3:41 PM To: MYSQL Subject: Length Limit Hi, Using the C API, does the sql parameter in the mysql_query function a length limit? Thank u very much, Edilson. Edilson Vasconcelos de Melo Junior www.jrsoftwares.com.br [EMAIL PROTECTED] Fone: (19) 3256-3577 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.361 / Virus Database: 199 - Release Date: 7/5/2002 --------------------------------------------------------------------- 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
